MS Access Advanced TopicMS Access - Advanced Topic
Advanced Topics
Importing Information
Exporting Information
Importing Objects from Another Access Database
Linking Information from an External Source
Analyzing Records with Microsoft Excel
Exporting Records to Microsoft Word
Mail Merging Records to Microsoft Word
Using Hyperlink Fields
Using OLE Object Fields
Displaying Database Object Dependencies
Review
One of the great benefits of working with Windows is that you can share information between different programs. Nowhere is this truer than with Microsoft Access. This tutorial explains how you can use Access with other programs. You'll learn how to import and export databases in other file formats. You'll also learn the difference between importing objects from another database versus linking to objects in another database. And you'll learn how to create a Microsoft Excel worksheet based on an Access query, transfer an Access table to Microsoft Word, or use Word with Access to create mail-merge letters.