Microsoft Access Reports visualize data for presentations, printable formats, management reports, or simple summaries of what the tables represent from the database. Using the Report Wizard, you can quickly create a basic report.
Instructions in this article apply to Access for Microsoft 365, Access 2019, Access 2016, Access 2013, and Access 2010.
How to Make a Report in Microsoft Access
The Access Report Wizard allows you to choose the fields that appear in your report, how data is grouped or sorted, and more.
-
Open the database and go to the Create tab.
-
In the Reports group, select Report Wizard.
-
The Report Wizard opens.
-
In the Tables/Queries list, choose the table on which you want to base the report.
-
In the Available Fields list, double-click a field name to add it to the report or select the field and click the single right arrow to move it to the Selected Fields list.
Double-clicking a field in the Selected Fields list moves it back to Available Fields.
-
Select Next when you finish adding fields.
-
Choose the fields by which you want to sort the records and select Next.
-
In the Layout section, select the layout in which you want the report to appear. Options include Columnar, Tabular, and Justified. You can choose Portrait or Landscape orientation, as well.
A preview of the selected layout style appears on the left.
-
Select Next to continue.
-
Enter a title for the report.
-
Choose Preview the report to see the completed report in Report View when finished or select Modify the report's design to open the report in Design View and select Finish.
Go to Home > View to open the report in a different view.