Learn Microsoft Office 2019

Creating a report based on a table or query

Reports can be created in Design view using the wizard. It is always recommended that tables and queries are created in Design view, and that reports and forms are created with Report Wizard:

1. Open the database that you would like to create a report for. We will continue to use SSGSchoolDB.accdb, as in the previous example.
2. Click on the Create tab and locate the Reports group. Choose the Report Wizard icon and the report wizard will open:

3. Select a table to create the report on using the drop-down arrow at the top of the dialog box.
4. Select the fields for the report from the Available Fields: box ...