Today we’d like to share an excerpt from one of our upcoming books: Microsoft Access 2010 Plain & Simple, by Curtis Frye. We’ll publish this book in Summer 2010. You can learn more about the book here: http://oreilly.com/catalog/9780735627307/.
In this excerpt, Curt describes an easy way to create reports in Access 2010. Enjoy:
Reports give you the ability to present your table and query data in an accessible format. In some ways, reports and forms are very similar—both types of database objects let you display your table records and query results at one record per page, in a series of columns or rows, or in a custom layout you create in Design view. The difference between forms and reports is that in addition to presenting your table and query data, reports let you summarize your data. For example, you can create a report that not only lists every order made by every customer, but also finds the total amount of all orders for a particular customer. It’s possible to do the same thing with queries, but the Report Wizard streamlines the process greatly, saving you time and effort while producing valuable information.
Although it might be possible to generate useful reports from the data in a single table or query, it’s very likely that you’ll want to combine data from more than one table or query into a single report. For example, you might have product data in one table and supplier data in another table, and then want to create a report where full supplier contact information accompanies the product information. You can do that by creating a report using the Report Wizard:
Here’s a tip: You can remove fields from the Selected Fields pane of the Report Wizard by clicking the field name and then clicking either Remove, to remove the selected field, or clicking Remove All, to remove all fields.