michigan informatics

Reports

Access reports are used for printing data summaries, charts and labels. Like forms, they can be time consuming to create by hand. Access offers Auto Report Wizards to help in the report creation process.

Reports can be based on tables or queries. You could base a report on a table, but then you would get all the data in your table in the report. It is much more likely that you would want to create a report for a specific purpose, and base it on a query created specifically for that purpose. 

Because we have already saved a query, we will use that query to generate our report.

In your database window, click on the Reports object, and click New. From the list on the right, select AutoReport: Columnar (1), and the table or query (2) that you want to base your report on.

Click the OK button (3), and your report will be created and shown in Preview Mode.