microsoft/access/training/courses - Access -creating a report

Hi Susan

There are three ways to create a report.

-----------------------------------------------------------------
1.
Based on a single table or query by using AutoReport. AutoReport creates a report that displays all fields and records in the underlying table or query

How?

In the Database window, click Reports under Objects.
Click the New button on the Database window toolbar.
In the New Report dialog box, click one of the following wizards:

AutoReport: Columnar
Each field appears on a separate line with a label to its left.

AutoReport: Tabular
The fields in each record appear on one line, and the labels print once at the top of each page.


------------------------------------------------------------
2.
Based on one or more tables or queries with a wizard.

The wizard asks you detailed questions about the record sources, fields, layout, and format you want and creates a report based on your answers.

How?

In the Database window, click Reports under Objects.
Click the New button on the Database window toolbar.
In the New Report dialog box, click the wizard that you want to use. A description of the wizard appears in the left side of the dialog box.
Click the table or query that contains the data you want to base your report on.

Note You don't need to do this step if you clicked Report Wizard in step 3