Page 4 of 12PREVNEXT

Create reports for a new Access 2007 database

Steps for creating a tabular report in Access 2007

The Report tool is the easiest way to create a report. Like the Form tool that you saw in the previous course, the Report tool automatically creates a report that is bound, or connected, to a single data source, either a table or query. All you have to do is select the table or query and click a button.

Callout 1 In the Navigation Pane, select the table or query that you want to use as the data source for the report.
Callout 2 Click the Create tab, and in the Reports group, click Report. Access creates a report that includes all the fields in your data source. The report automatically uses the tabular layout, and if your data source contains enough fields, Access creates the report in landscape format.
Callout 3 The report opens in Layout view, which gives you a chance to change it. For example, you can resize a field by clicking and dragging a single control, or you can switch to a stacked layout, something you'll get a chance to try during the practice.
Callout 4 While you work, you can switch to Report view at any time to view your changes.
Page 4 of 12PREVNEXT