Wish I had found you before I spent $100 to take a class. Thanks!”

Online Learner

Creating Opportunities For A Better Life.®

Access 2000

Single page view print copy

Creating a Report

AutoReport

You can develop reports many ways, but in this lesson, we'll discuss how to create a report using AutoReport and the Report Wizard.

Some of the simplest reports to produce, AutoReports are extremely useful; especially if all the data you want is in one table or query.

To Create an AutoReport:

  • Open the database window. Choose Report from the Object palette.

Database window - Report

  • Click New to open the New Reports dialog box.

New button

  • Choose AutoReport: Columnar or AutoReport: Tabular.

New Report dialog box - AutoReport

  • Click the drop-down list and choose the table or query on which the report or query is based.

Choose table - AutoReport

  • If you forget this step, the Office Assistant gives you the following error message:

Office Assistant's error message

  • Click OK to create the report and open it in Print Preview. Your mouse pointer changes to the magnifying glass. Remember, you cannot edit data in print preview.

Important pointWhen you save a report, only the structure of the report is saved, not the underlying data you see in the preview. Data shown in the preview is always as current as the records in the database.

1 2 3 4 5 6