# How to Generate Report in MS Access

> To generate a report in Microsoft Access, open the database, click Report Wizard on the Create tab, select your data and fields, set sorting, layout, and orientation, name the report, and click Finish after choosing to preview it.

Canonical: https://livedemo.ai/tutorials/how-to-generate-report-in-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3eb9ab56e05a00fe68d3/preview?step=1

## Steps

1. Launch MS Access and open the database containing the data for the report.
2. Go to the 'Create' tab on the ribbon.
3. In the 'Reports' group, click 'Report Wizard'.
4. Choose the table or query that contains the data you want to use.
5. Select the fields you want to include in the report by moving them to the 'Selected Fields' box. Click 'Next'.
6. Choose up to four fields to sort your data and click 'Next'.
7. Select a layout for the report and choose a page orientation.
8. Click 'Next'.
9. Provide a name for your report.
10. Select 'Preview the Report'.
11. Click 'Finish'.
12. By following these steps, you can generate a report in MS access easily.