1 / 24

ISMT E-120

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

blaise
Download Presentation

ISMT E-120

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ISMT E-120 Desktop Applications for Managers Integrating Applications

  2. Integrating Applications • Clipboard • Intermediate Formats • Exporting & Importing • Mail Merge – Excel & Access • Integrated Query • Object Linking & Embedding • Hyperlinks

  3. Integrating Applications • Clipboard • Intermediate Formats • Exporting & Importing • Mail Merge – Excel & Access • Integrated Query • Object Linking & Embedding • Hyperlinks

  4. Clipboard • Small Application • Always available • Converts Formats • Windows vs. Office Clipboard

  5. 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

  6. 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

  7. Export Examples • Access to Excel • Excel To Access

  8. Import Examples • Access from Excel • Import • Link • HTML

  9. Integrating Applications • Clipboard • Intermediate Formats • Exporting & Importing • Mail Merge – Excel & Access • Integrated Query • Object Linking & Embedding • Hyperlinks

  10. Mail Merge • Excel • Entire worksheet as source • Access • Table as source • Query results as source

  11. Integrating Applications • Clipboard • Intermediate Formats • Exporting & Importing • Mail Merge – Excel & Access • Integrated Query • Object Linking & Embedding • Hyperlinks

  12. Integrated Query • Query • Data in Excel • Data in Access

  13. Microsoft Query • Query Engine from Access • Invoke from Excel • ODBC • Standard protocol • Drivers for different databases • Masks idiosyncrasies among databases

  14. Integrating Applications Cooperative Applications • Clipboard • Intermediate Formats • Exporting & Importing • Mail Merge – Excel & Access • Integrated Query • Object Linking & Embedding (OLE) • Hyperlinks

  15. Object Embedding • Copy of source object embedded • No live link maintained • Edit source object within container • More portable – all components go • Files larger

  16. 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?

  17. Using OLE • Text-oriented example • Presentation-oriented example • Database-oriented example

  18. Using OLE - Example • Spreadsheet • Sound clip • Database ??

  19. Integrating Applications • Clipboard • Intermediate Formats • Exporting & Importing • Mail Merge – Excel & Access • Integrated Query • Object Linking & Embedding • Document Hyperlinks

  20. Document Hyperlinks • File • Named Object Within File • Web Page • FTP Site

  21. Hyperlinks: Word • Bookmark within a Word document • Hyperlink to other Word documents • And to Excel • … to PowerPoint • … to Access

  22. Hyperlinks: Excel • Worksheet • Named Range of Cells • Not Defined Names

  23. Hyperlinks: PowerPoint • Word • Document, Bookmark, Web Page • Excel • Worksheet, Named Range • PowerPoint • Slide Name or Number

  24. Hyperlinks: Access • Table • Form • Report • Object-type object-name syntax • Hyperlink to Access database form

More Related