About this lesson
Learn how to create a new report and fix a broken report.
Download this lesson’s related exercise files.Services_22_Start_Creating Reports in Access.accdb
1.5 MB Services_22_Creating Reports in Access.accdb
Creating Reports in Access, Fix Broken Report
Blank Report Command
The Blank Report command creates a blank report with a Page Header section, Detail section, and a Page Footer section. It opens in Layout View.
The Report button in the Reports group on the CREATE ribbon creates an AutoReport that is a basic report based on the table or query selected in the Navigation Pane. If a form or report is selected, the report will be based on its Record Source. If what is selected does not have a Record Source (such as an unbound object, Macro, or Module), this button will not be enabled.
Report Design Command
The Report Design command creates a blank report with a Page Header section, Detail section, and a Page Footer section. It opens in Design View.
Report Wizard Command
The Report Wizard command pops up a wizard that steps you through creating different types of reports that can then be customized using Design or Layout View.
The Labels command opens the Label Wizard, which enables you to choose data to print on labels using purchased label paper (such as Avery 5160) or create custom labels.
Fix a Broken Report
- Go to the design view of the report and click on the builder button (...) in the Record Source property (Data tab of Property Sheet) for the report.
Create a Report
- To create a new report, click on the CREATE ribbon
- Choose one of the commands in the Reports Group
Lesson notes are only available for subscribers.