Video: Create basic reports
Applies To
Access for Microsoft 365 Access 2024 Access 2021 Access 2019 Access 2016
Try it!
Note: The information on this page applies only to Access desktop databases. Access web apps don't support reports.
Before you share your database with others, put the information in a format that’s easy to understand. View, format, and summarize the information in your database with reports.
-
In the Navigation pane, select a record source. The record source of a report might be a table or a named query. It must contain all of the rows and columns of data that you want to include in the report.
-
On the Create tab, select the report tool you want to use and, to create the report, follow any instructions.
|
Report tool |
Description |
|---|---|
|
Report |
Create a simple, tabular report containing all of the fields in the record source you selected in the Navigation pane. |
|
Report Design |
Open a blank report in Design view, and then add the fields and controls you need. |
|
Blank Report |
Open a blank report in Layout view, and then select fields to add from the Field List. |
|
Report Wizard |
Follow the instructions to specify fields, grouping and sorting levels, and layout options. |
|
Labels |
Select standard or custom label sizes, which fields you want to include in the report, and how you want them sorted. |
Add grouping, sorting, or totals to fields in the report
-
In Design View, open the report.
-
If the Group, Sort, and Total pane is not already open, on the Design tab, select Group & Sort.
-
Select Add a group or Add a sort, and then select the field you want to group or sort.
-
To set more options and to add totals, on a grouping or sorting line, select More.
Want more?
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
