How to Create Summary Reports MS Access

Quick summary

This tutorial shows how to create summary reports in Microsoft Access using the built-in Report Wizard, covering data selection, grouping, sorting, layout, and final output. Following these steps lets users generate structured, print-ready Access reports without writing any code.

Steps

1. Go to the Create tab in the MS Access ribbon.
2. In the Report group, select Report Wizard to launch the wizard.
3. Select the table or query that contains the data you want to report on.
4. Add the fields you want to include in the report.
5. In the wizard, group the data by the relevant field and click Next when prompted.
6. Sort your data by the desired field and click Next.
7. Choose a layout for your report and click Next.
8. Give your report a name and click Finish to generate it.
9. Save the report and switch to Print Preview to verify that summaries and groupings are correct.