AutoReport creates a report automatically based on a single table or query. AutoReport incorporates all the information, both the field names and the individual records, from a selected object and then creates the report for you. There are two layout options for the report, tabularthe records display in a table layout, or columnarthe records display in a column.
In this activity, you will create a report for James Smith that lists the club members who are participating in the fundraiser.
With your 3A_Fundraiser database open, on the Objects bar click Reports.
On the Database window toolbar, click New .
From the list, click AutoReport: Tabular. To the right of Choose the table or query where the objects data comes from, click the arrow, and then click Club Members. Compare your screen with Figure 3.32.
Click OK, and then compare your screen with Figure 3.33.
The Club Members report is created and displays in print preview. A report displays the data as it is currently entered in the database. You cannot use a report to edit the data in the database. The mouse pointer displays as a magnifying glass so you can zoom in and out on the report.
Do not be concerned if your report displays a different style from the one shown in the figure. The last style that was applied to a report, using the Access program installed on your computer, is the style that is applied when an AutoReport is created.
Click once to change the magnification so you can see the entire report on the screen.
Point to the last record in the report and click once.
If you have been instructed to submit your file electronically, skip this step. Otherwise, on the Print Preview toolbar, click the Print button to print the report.
On the menu bar, click the Close Window button .
Click Yes. In the displayed Save As dialog box, accept the default nameClub Membersand then click OK.
GO! with Microsoft Office 2003 Brief (2nd Edition)