• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 42. Linking Multiple Tables > Secrets of the Office Masters: Sharing th...

Secrets of the Office Masters: Sharing the (Data) Wealth

Unlike previous versions, Access 2000 enables you to import or link directly to information in an Outlook data file. If you choose to link Outlook data to a database, Access directly connects to the Personal Folders file (*.pst) or Exchange folder that contains the data. As a result, you can do things that aren't possible with Access alone. For example, you can create a sophisticated contact management system to track activities related to your Outlook contacts. Or create a separate relational table that enables you to link Outlook contacts to information in a customers or suppliers table. You can also use the contents of the Outlook Tasks folder to create a project management and billing system, with features and capabilities not present in Outlook itself.

The secret is using the Link Exchange/Outlook Wizard, shown here. From your Access database, choose File, Get External Data, Link Tables. In the Files of Type list, choose Exchange or Outlook, and then follow the wizard's instructions to link one or more Outlook folders to your database. Because these are direct links to your Outlook data, any information you add, edit, or delete in Outlook or Access automatically appears in the other location.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint