Chapter 16. Sharing Data

IN THIS CHAPTER

  • Export data to Excel and import Excel data into Access

  • Export and import to text files

  • Publish Access reports to Word

  • Use Word’s mail-merge with your Access names and addresses to create several letters at once

  • Send Access data via email

  • Use AutoCorrect to help prevent typos

Access is much more than just a database. It’s part of the best suite of computer software on the market. Access, Word, and Excel all work well together, which means data that’s entered in one application can be used in another.

Most of the time, you’ll find Excel or Word just a button click away. The OfficeLinks button on the Database toolbar offers three options:

  • Merge It with MS Word

  • Publish It with MS Word

  • Analyze It with MS Excel

But there’s ...

Get Absolute Beginner’s Guide to Microsoft® Access 2002 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.