Creating a Summary Report

Although both database object types let you display your table and query records, one thing you can do in a report that you can’t with a form is to summarize your data within a report. For example, if you created a summary report of all orders and grouped the report’s contents by product, you could add a summary function to find the total sales for each product. You could also find the minimum, maximum, or average value of orders for each listed product.

Build a Summary Report

  1. Click the Create tab.

  2. Click Report Wizard.

  3. Click ...

Get Microsoft® Office Access™ 2007 Plain & Simple 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.