NB: The information provided on this page only relates to Access desktop databases. Reports are not supported by Access web apps.
Before sharing your database with other people, organise the data in a straightforward, easily accessible format. Reports enable you to view, format, and summarise your database’s contents.
In the Navigation pane, click a record source.
A table or a named query can be defined as a record source of a report. This must include every single row and column of data that are essential for your report.
- On the Create tab, choose your desired report tool and, follow any given instructions to produce the report, follow any instructions.
|Report||Produce a basic, tabular report including every field in the record source you confirmed in the Navigation pane.|
|Report Design||Open a new report in Design view, and next, add the necessary fields and controls.|
|Blank Report||Open a blank report in Layout view, and then choose fields to expand from the Field List.|
|Report Wizard||Follow the instructions to define fields, grouping and sorting levels, and layout options.|
|Labels||Select standard or custom label sizes, the specific fields you want to include in the report, and your preference for arranging them.|
Add grouping, sorting, or totals to fields in the report
- In Design View, open the report.
- If the Group, Sort, and Total pane is still closed, on the Design tab, choose Group & Sort.
- Select Add a group or Add a sort, and then verify the field you want to group or sort.
- Click More to enforce extra options and to add totals, on a grouping or sorting line.
Your data is meant to be shared with others, but raw data in a table often isn’t very clear.
This is where database reports come in. For example, create a report to show a snapshot of data for a moment in time.
Review details about specific records, as in a simple report of phone numbers for all your contacts.
Or summarise the big picture your data reveals, like in a summary report showing which customers recently placed the largest orders.
The first step in creating a desktop database report is to select the source of the records for the report.
The record source must contain all the rows and columns of data you want to display in the report.
The record source can be a single table. But if the data is spread across two or more tables, use a named query or an embedded query that includes those tables.
In the Navigation Pane, select the table or query that is your record source.
Select Create. Here you can see different ways to create a report.
With Report, you design a simple tabular report which includes all the fields in your record source.
Report Design opens a blank report in Design view. Then you add the fields and controls you want from your record source.
If you don’t have a record source set up, use Blank Report and the Field List to add fields and controls directly to your report design.
Labels—like customer address labels—are a type of report, too, because they arrange fields from a table or query in a specific format. Use the Labels tool and walk through the wizard to select the label size, fields, and sort order.
For the report we’re creating now, select Report Wizard. This wizard guides us through picking the fields, selecting the field grouping or sorting, and specifying the report’s layout.
From Available Fields, select the first field you want in the report, and then select this right arrow.
Continue to select and add the fields you want in your report from the fields available in your selected record source.
You’re not locked in to using only the fields in the one table or query you selected as your record source. If you want, select fields from other related tables or queries.
Here you specify how you want to see the data, based on what you choose to emphasise. Let’s set up the report to view by order status.
On this page, specify grouping to organise or “chunk” large amounts of data to make it easier to understand.
Select Grouping Options to see more choices about the grouping level you just added.
On this page, specify the sort order. Let’s say we want an ascending sort by Order ID.
Select Summary Options to specify whether you want any calculations done on your numeric data.
Here, select your report layout.
Specify whether you want the report to be in portrait or landscape orientation and whether you want fields to adjust to the size of the page.
Add a title for your report.
Let’s see how the report looks so far. Preview is already selected, so select Finish.
Looks pretty good. We can make adjustments here on the Print Preview tab.
When we’re done, select Close Print Preview.
The report appears in Design view.
Take a look at the Reports list in the Navigation Pane. Your new report is added to the list of report objects.
Although you might want to make some adjustments over time, you now have your basic report, which is ready to share and tell the story your data reveals.