Run a Report in Microsoft Access

There are a few ways to run your training reports in Microsoft Access. If using a database that was purchased and downloaded from this site, it is recommended that you use the Report Wizard to run a report and to base your report on one of the ready-made queries provided on the navigation pane.


Create a Report Using the Report Tool

1. In the Navigation Pane, click the table or query on which you want to base the report.

2. On the Create tab, in the Reports group, click Report.
Access builds the report and displays it in Layout view.

3. For more about viewing and printing your report, see the section View, print, or send your report as an e-mail message.


Create a Report Using the Report Wizard

1. On the Create tab, in the Reports group, click Report Wizard.

2. Follow the directions on the Report Wizard pages. On the last page, click Finish.

When you preview the report, you see the report as it will appear in print. You can also increase the magnification to zoom in on details. For more about viewing and printing your report, see the section View, print, or send your report as an e-mail message.


Create a Report Using the Blank Report Tool and Build Your Report from Scratch

1. On the Create tab, in the Reports group, click Blank Report.

A blank report is displayed in Layout view, and the Field List (field list: A window that lists all the fields in the underlying record source or database object, except in data access page Design view. In data access page Design view, it lists all the record sources and their fields in the underlying database.) pane is displayed on the right side of the Access window.

2. In the Field List pane, click the plus sign next to the table or tables containing the fields that you want to see on the report.

3. Drag each field onto the report one at a time, or hold down CTRL and select several fields, and then drag them onto the report at the same time.

4. Use the tools in the Controls group on the Format tab to add a logo, title, page numbers, or the date and time to the report.

No comments: