Table of contents
Create reports
Create reports

Create basic reports

Your browser does not support video.

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.

  1. 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.

  2. On the Create tab, select the report tool you want to use and, to create the report, follow any instructions.

Report tool



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.


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

  1. In Design View, open the report.

  2. If the Group, Sort, and Total pane is not already open, on the Design tab, select Group & Sort.

  3. Select Add a group or Add a sort, and then select the field you want to group or sort.

  4. To set more options and to add totals, on a grouping or sorting line, select More.

Want more?

Create a grouped or summary report

Excel training

Outlook training

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!