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

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 more. You can import data into Access, export data out of Access, or even link to data in other applications. In this chapter, we'll review the previously mentioned shortcuts and a few wizards that make sharing your Access data easy.

Note

graphics/nman.gif

You can download the Chapter 16.mdb sample file, which is inclusive of all the examples in this chapter, from http://www.quepublishing.com/. If you want to follow along with our examples, download Chapter 15.mdb .




Absolute Beginner's Guide to Microsoft Office Access 2003
Absolute Beginners Guide to Microsoft Office Access 2003
ISBN: 0789729407
EAN: 2147483647
Year: 2002
Pages: 124

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net