How to Create a Report in Microsoft Access

Organize your data for printing by creating a Microsoft Access report. You can generate reports by using the AutoReport function, by using a Report wizard or by designing the report yourself. These instructions are for Access 97.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Microsoft Access

AutoReport

1. Open the database window (F11) and click on the Report tab.
2. Click New. A dialog box appears.
3. Choose between Columnar and Tabular.
4. Select the table or query that you want to use for your report.
5. Click OK.

Report Wizard

6. Repeat the first two steps above.
7. Click the wizard that you want to use for your report.
8. Select the table or query that you want to use for your report.
9. Click OK.
10. Follow the instructions that the wizard provides.

Create Your Own Report

11. Repeat the first two steps above.
12. When the dialog box appears, click Design View.
13. Select the table or query that you intend to use.
14. Click OK.

Tips & Warnings

• Reports generated with AutoReport contain all fields and records that occur in the table or query that was used.
• You can change the look of your report in Design view.
• You can edit, modify and add controls to your report from Design view.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.