Advanced Topics

TASK: EXPORT AND IMPORT INFORMATION TO AND FROM A MICROSOFT ACCESS DATABASE

Prerequisites

• How to use menus, toolbars, dialog boxes, and shortcut keystrokes.

• How to open and modify database objects.

• A basic understanding of Microsoft Excel and Microsoft Word.

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.