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.

Things You'll Need

• Microsoft Access

Instructions

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.

Create Your Own Report

1. Repeat the first two steps above.

2. When the dialog box appears, click Design View.

3. Select the table or query that you intend to use.

4. Click OK.

Report Wizard

1. Repeat the first two steps above.

2. Click the wizard that you want to use for your report.

3. Select the table or query that you want to use for your report.

4. Click OK.

5. Follow the instructions that the wizard provides.

Tips & Warnings

• Reports generated with AutoReport contain all fields and records that occur in the table or query that was used.

• You can edit, modify and add controls to your report from Design view.

• You can change the look of your report in Design view.