Use a report to print and share data from Access. This is an overview of Access reports where you’ll learn the basics of creating a report and using options like sorting, grouping, and summarizing the data, and how to preview and print the report.

When you create a report by using the Report tool (available on the Create tab, in the Reports group), or by using the Report Wizard, Access adds the fields to the report for you and creates the most appropriate control to display each field, based on the field's data type.

Do you need to create a report in Access? Learn what tools to use to make specific types of reports.

Create a report in Access that groups data and displays subtotals, averages, and other aggregates.

Create a report. Select Create > Report Wizard. Select a table or query, double-click each field in Available Fields you want to add it to the report, and select Next. Double-click the field you want to group by, and select Next. Complete the rest of the wizard screens, and select Finish. For more info, see Create basic reports or Create a ...

This topic describes the techniques you can use to modify an existing Access report. Access provides two views that you can use to make changes to your report: Layout view and Design view. Your choice of which view to use depends on what specific task you are …

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.

When you distribute an Access report, you create a static report of data at a certain moment in time, such as daily, weekly, or monthly. By doing so, you have a single point of truth that information workers can use to make good business decisions, answer questions, find alternatives, determine best plans, evaluate risks, and improve quality.

You can use a report to quickly analyze your data or to present it a certain way in print or in other formats. For example, you may send a colleague a report that groups data and calculates totals. Or, you may create a report with address data formatted for printing mailing labels.

This article explains how to preview and print a report that was created with or opened in Microsoft Access. This article also provides basic information about how to change commonly used print settings, such as the margins and the number of columns on a printed page.