Ismt e 120
Download
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