[ Team LiB ] Previous Section Next Section

Creating a Report Using a Wizard

graphics/microsoft178_1.gif

One of the features you can use to create a simple report in Access is the AutoReport Wizard, which arranges data in a selected table or query as a formatted report. The AutoReport: Columnar Wizard displays each record's data vertically, while the AutoReport: Tabular Wizard displays the data for each record horizontally. You can also create a report using the Report Wizard, which allows you to select the fields and information you want presented and to choose from available formatting options that determine how the report will look.

Create and Save a Report Using the AutoReport Wizard

graphics/1_icon.jpg

In the Database window, click Reports on the Objects bar, and then click New.

graphics/2_icon.jpg

Click AutoReport: Columnar (to display records in a column), or click AutoReport: Tabular (to display records in rows).

graphics/3_icon.jpg

Click the list arrow, and then click a table or query on which to base the report.

graphics/4_icon.jpg Click OK.

Access displays the form in Print Preview, but you can switch to Design view, save, print, or close the report.

graphics/5_icon.jpg

Click the Save button, type a name for your report, and then click OK.

graphics/08inf04.jpg

Did You Know?

You can create an instant report with the AutoReport command. In the Database window, select the table or query that contains the data you want formatted as a report. Click the Insert menu, and then click AutoReport. After a moment, Access generates a simple columnar report without headers or footers.


Create and Save a Report Using the Report Wizard

graphics/1_icon.jpg

In the Database window, click Reports on the Objects bar, and then double-click the Create Report By Using Wizard icon.

graphics/2_icon.jpg

Click the list arrow for choosing a table or query on which to base the form, and then click the name of the table or query you want.

graphics/3_icon.jpg

Select the fields you want to include, indicating the source of any fields you want to include from other tables or queries. Click Next to continue.

graphics/4_icon.jpg

If necessary, specify any groupings of the records, choosing any or all of the selected fields (up to ten). Click Next to continue.

graphics/5_icon.jpg

Specify the order of records within each group, sorting by up to four fields at a time, and then specify ascending or descending order. Click Next to continue.

graphics/6_icon.jpg

Determine the layout and orientation of your report. Click Next to continue.

graphics/7_icon.jpg

Specify the style of the report, which affects its formatting and final appearance. Click Next to continue.

graphics/8_icon.jpg

In the final wizard dialog box, name your report, and then indicate whether you want to preview the report or display it in Design view. Click Finish.

graphics/08inf05.jpg

    [ Team LiB ] Previous Section Next Section