Access 2007 for Starters: The Missing Manual

Chapter 8. Creating Reports

• Report Basics

• Printing, Previewing, and Exporting a Report

• Formatting a Report

• Filtering and Sorting a Report

There are many reasons to create a hard copy of your lovingly maintained Access data. With a good printout, you can:

• Carry your information without lugging your computer around. For example, you can take an inventory list while you go shopping.

• Show your information to non-Access users. For example, you can hand out product catalogs, order forms, and class lists to other people.

• Review details outside the office. For example, you can search for mistakes while you're on the commuter train home.

• Impress your boss. After all, it's difficult to argue with 286 pages of raw data.

In Chapter 3 you learned how to print the raw data that's in a table, straight from the datasheet. This technique is handy, but it provides relatively few features. You don't have the flexibility to deal with large blocks of information, you can't fine-tune the formatting of different fields, and you don't have tools like grouping and summarizing that can make the information easier to understand. As you've probably already guessed, Access provides another printing feature that fills in these gaps. It's called reports, and it allows you to create a fine-tuned blueprint that tells Access exactly how it should prepare your data for the printer.

Reports are specialized database objects, much like tables and queries. As a result, you can prepare as many reports as you need, ...