Slide 1

ISMT E-120 The Influence of Software and Hardware Technologies on Business Productivity Integrating Applications

Slide 2

2 Common Connectors Mail Merge Excel & Access Integration Template + Database + Pivot Table = Report & Chart Dynamic Web Queries with Excel Object Linking & Embedding Hyperlinks Macros

Slide 3

3 Common Connectors Clipboard Intermediate Formats Export & Import between applications

Slide 4

4 Common Connectors Clipboard

Slide 5

5 Intermediate Formats Text Only o Loses formatting o Lowest common denominator across applications o Can be delimited (tab, , space, comma) RTF: Rich Text Format o Text characters only o Preserves some visual content and format

Slide 6

6 Export and Import Source document understands the destination application or Converts to an intermediate format

Slide 7

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

Slide 8

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

Slide 9

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

Slide 10

10 Integrated Excel & Access Query 1.Query an Access database 2.Import the data into Excel custom templates 3.Create a Pivot Table 4.Use the Pivot Table to analyze the data 5.Populate the analyzed data into the templates

Slide 11

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

Slide 12

12 Web Query with Excel Dynamic Web Query with Excel

Slide 13

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

Slide 14

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

Slide 15

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?

Slide 16

16 Using OLE Text-oriented example Presentation-oriented example Database-oriented example Spreadsheet Sound clip Special note about Access

Slide 17

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

Slide 18

18 Document Hyperlinks To/From Various types of Files/Documents Named Object Within File Web Page FTP Site

Slide 19

19 Hyperlinks: Word Bookmark within a Word document Hyperlink to other Word documents And to Excel to PowerPoint to Access

Slide 20

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

Slide 21

21 Hyperlinks: PowerPoint To Word o Document, Bookmark, Graphic To Excel o File, Named Range In PowerPoint o Presentation, Slide Name or Number Web Page To Access

Slide 22

22 Hyperlinks: Access Table Form Report Syntax: #Object-type object-name Hyperlink to Access database form

Slide 23

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

Slide 24

24 Macros Repeat Sequence of Actions Get an Exact Replica Small Program Written in Visual Basic for Applications (VBA)

Slide 25

25 Macro Recorder View tab > Macro.dotm type is a macro-enabled Word template.xltm type is a macro-enabled Excel template

Slide 26

26 Sample Macros Word Excel Access covered in the Database lectures

Slide 27

27 Invoking Macros View Macros or Developer > Macros Macro button Keyboard Shortcut

Slide 28

28 Whats Next Visio for Diagramming