ismt e 120
Download
Skip this Video
Download Presentation
ISMT E-120

Loading in 2 Seconds...

play fullscreen
1 / 24

ISMT E-120 - PowerPoint PPT Presentation


  • 104 Views
  • Uploaded on

ISMT E-120. Desktop Applications for Managers. Integrating Applications. Integrating Applications. Clipboard Intermediate Formats Exporting & Importing Mail Merge – Excel & Access Integrated Query Object Linking & Embedding Hyperlinks. Integrating Applications. Clipboard

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' ISMT E-120' - blaise


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
ismt e 120

ISMT E-120

Desktop Applications for Managers

Integrating Applications

integrating applications
Integrating Applications
  • Clipboard
  • Intermediate Formats
  • Exporting & Importing
  • Mail Merge – Excel & Access
  • Integrated Query
  • Object Linking & Embedding
  • Hyperlinks
integrating applications1
Integrating Applications
  • Clipboard
  • Intermediate Formats
  • Exporting & Importing
  • Mail Merge – Excel & Access
  • Integrated Query
  • Object Linking & Embedding
  • Hyperlinks
clipboard
Clipboard
  • Small Application
  • Always available
  • Converts Formats
  • Windows vs. Office Clipboard
intermediate formats
Intermediate Formats
  • Text Only
    • Loses formatting, some content
    • Lowest denominator
    • Can be delimited (tab, “”, space, …)
  • RTF: Rich Text Format
    • File contains only text characters
    • Preserves visual content and format
exporting and importing
Exporting and Importing
  • Export
    • Source document knows about destination

OR

    • Converts to intermediate format
  • Import
    • Destination document knows about source

OR

    • Source converted to intermediate format
export examples
Export Examples
  • Access to Excel
  • Excel To Access
import examples
Import Examples
  • Access from Excel
    • Import
    • Link
  • HTML
integrating applications2
Integrating Applications
  • Clipboard
  • Intermediate Formats
  • Exporting & Importing
  • Mail Merge – Excel & Access
  • Integrated Query
  • Object Linking & Embedding
  • Hyperlinks
mail merge
Mail Merge
  • Excel
    • Entire worksheet as source
  • Access
    • Table as source
    • Query results as source
integrating applications3
Integrating Applications
  • Clipboard
  • Intermediate Formats
  • Exporting & Importing
  • Mail Merge – Excel & Access
  • Integrated Query
  • Object Linking & Embedding
  • Hyperlinks
integrated query
Integrated Query
  • Query
    • Data in Excel
    • Data in Access
microsoft query
Microsoft Query
  • Query Engine from Access
  • Invoke from Excel
  • ODBC
    • Standard protocol
    • Drivers for different databases
    • Masks idiosyncrasies among databases
integrating applications4
Integrating Applications

Cooperative Applications

  • Clipboard
  • Intermediate Formats
  • Exporting & Importing
  • Mail Merge – Excel & Access
  • Integrated Query
  • Object Linking & Embedding (OLE)
  • Hyperlinks
object embedding
Object Embedding
  • Copy of source object embedded
  • No live link maintained
  • Edit source object within container
  • More portable – all components go
  • Files larger
object linking
Object Linking
  • Live link between two applications
  • Change in source updates destination document
  • Stores only the location of the original data, not data itself
  • Not as portable – why?
using ole
Using OLE
  • Text-oriented example
  • Presentation-oriented example
  • Database-oriented example
using ole example
Using OLE - Example
  • Spreadsheet
  • Sound clip
  • Database ??
integrating applications5
Integrating Applications
  • Clipboard
  • Intermediate Formats
  • Exporting & Importing
  • Mail Merge – Excel & Access
  • Integrated Query
  • Object Linking & Embedding
  • Document Hyperlinks
document hyperlinks
Document Hyperlinks
  • File
  • Named Object Within File
  • Web Page
  • FTP Site
hyperlinks word
Hyperlinks: Word
  • Bookmark within a Word document
  • Hyperlink to other Word documents
  • And to Excel
  • … to PowerPoint
  • … to Access
hyperlinks excel
Hyperlinks: Excel
  • Worksheet
  • Named Range of Cells
  • Not Defined Names
hyperlinks powerpoint
Hyperlinks: PowerPoint
  • Word
    • Document, Bookmark, Web Page
  • Excel
    • Worksheet, Named Range
  • PowerPoint
    • Slide Name or Number
hyperlinks access
Hyperlinks: Access
  • Table
  • Form
  • Report
  • Object-type object-name syntax
  • Hyperlink to Access database form
ad