Software & Apps MS Office Microsoft Access Database Reports Tutorial Create reports in Access by Mike Chapple Writer Former Lifewire writer Mike Chapple is an IT professional with more than 10 years' experience cybersecurity and extensive knowledge of SQL and database management. our editorial process Twitter Mike Chapple Updated on September 18, 2020 MS Office Word Excel Powerpoint Outlook Tweet Share Email 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, 2016, 2013, and 2010. Paul Bradbury / Caiaimage / Getty Images How to Make a Report in MS 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 select the Create tab. Select Report Wizard in the Reports group. 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 button to move it to the Selected Fields list. Double-clicking a field in the Selected Fields list will move 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.