1 / 0

ISMT E-120

ISMT E-120. The Influence of Software and Hardware Technologies on Business Productivity Integrating Applications. Integrating Applications. Common Connectors Mail Merge – Excel & Access Integration – Template + Database + Pivot Table = Report & Chart Dynamic Web Queries with Excel

phoebe
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

    The Influence of Software and Hardware Technologies on Business Productivity Integrating Applications
  2. Integrating Applications Common Connectors Mail Merge – Excel & Access Integration – Template + Database + Pivot Table = Report & Chart Dynamic Web Queries with Excel Object Linking & Embedding Hyperlinks Macros
  3. Common Connectors Clipboard Intermediate Formats Export & Import between applications
  4. Common Connectors Clipboard
  5. Intermediate Formats Text Only Loses formatting Lowest common denominator across applications Can be delimited (tab, “”, space, comma) RTF: Rich Text Format Text characters only Preserves some visual content and format
  6. Export and Import Source document understands the destination application or Converts to an intermediate format
  7. Integrating Applications Common Connectors Mail Merge – Excel & Access Integration – Template + Database + Pivot Table = Report & Chart Dynamic Web Queries with Excel Object Linking & Embedding Hyperlinks Macros
  8. Mail Merge Word - Excel - Access What is Mail Merge and what is it used for? Excel as a data source Access table or query as data source
  9. Integrating Applications Common Connectors Mail Merge – Excel & Access Integration > Template + Database + Pivot Table = Report & Chart Dynamic Web Queries with Excel Object Linking & Embedding Hyperlinks Macros
  10. Integrated Excel & Access Query Query an Access database Import the data into Excel custom templates Create a Pivot Table Use the Pivot Table to analyze the data Populate the analyzed data into the templates
  11. Integrating Applications Common Connectors Mail Merge – Excel & Access Integration – Template + Database + Pivot Table = Report & Chart Dynamic Web Queries with Excel Object Linking & Embedding Hyperlinks Macros
  12. Web Query with Excel Dynamic Web Query with Excel
  13. Integrating Applications Common Connectors Mail Merge – Excel & Access Integration – Template + Database + Pivot Table = Report & Chart Dynamic Web Queries with Excel Object Linking & Embedding Hyperlinks Macros
  14. Object Embedding Copy of source object is embedded No live link maintained Edit source object within container More portable – all components go Files larger
  15. Object Linking Creates a live link between two application files Change in source updates destination document Stores only the location of the original data, not data itself Not as portable – why?
  16. Using OLE Text-oriented example Presentation-oriented example Database-oriented example Spreadsheet Sound clip Special note about Access
  17. Integrating Applications Common Connectors Mail Merge – Excel & Access Integration – Template + Database + Pivot Table = Report & Chart Dynamic Web Queries with Excel Object Linking & Embedding Hyperlinks Macros
  18. Document Hyperlinks To/From Various types of Files/Documents Named Object Within File Web Page FTP Site
  19. Hyperlinks: Word Bookmark within a Word document Hyperlink to other Word documents And to Excel … to PowerPoint … to Access
  20. Hyperlinks: Excel Worksheet To Named Ranges, but not defined names To Word to an object/graphic/bookmark To PowerPoint – presentation, slide # or name To Access
  21. Hyperlinks: PowerPoint To Word Document, Bookmark, Graphic To Excel File, Named Range In PowerPoint Presentation, Slide Name or Number Web Page To Access
  22. Hyperlinks: Access Table Form Report Syntax: #Object-type object-name Hyperlink to Access database form
  23. Integrating Applications Common Connectors Mail Merge – Excel & Access Integration – Template + Database + Pivot Table = Report & Chart Dynamic Web Queries with Excel Object Linking & Embedding Hyperlinks Macros
  24. Macros Repeat Sequence of Actions Get an Exact Replica Small Program Written in Visual Basic for Applications (VBA)
  25. Macro Recorder View tab > Macro .dotm type is a macro-enabled Word template .xltm type is a macro-enabled Excel template
  26. Sample Macros Word Excel Access – covered in the Database lectures
  27. Invoking Macros View  Macros …or… Developer > Macros Macro button Keyboard Shortcut
  28. What’s Next Visio for Diagramming
More Related