Creating a Report

In Access 2000 creating reports is easy. Just follow the step-by-step instructions provided in this free lesson.

Using AutoReport

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

AutoReports, some of the simplest reports to produce, 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 Objects 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.