Microsoft Office Tutorials and References
In Depth Information
To start the Report Wizard and select the fields to include in the report:
1. Click the Create tab on the Ribbon.
2. In the Reports group on the Create tab, click the Report Wizard button. The first
Report Wizard dialog box opens.
As was the case when you created the form with a subform, initially you can choose
only one table or query to be the data source for the report. Then you can include
data from other tables or queries. You will select the primary Customer table first.
3. If necessary, click the Tables/Queries arrow, and then click Table: Customer .
In the first Report Wizard dialog box, you select fields in the order you want them
to appear on the report. Taylor wants the Customer ID, Company, First Name, Last
Name, City, and Phone fields from the Customer table to appear on the report, in
4. Click Customer ID in the Available Fields list box (if necessary), and then click the
button. The field moves to the Selected Fields list box.
5. Repeat Step 4 to add the Company , First Name , Last Name , City , and Phone
fields to the report.
6. Click the Tables/Queries arrow, and then scroll the list up and click Table:
Contract . The fields from the Contract table appear in the Available Fields list box.
The Customer ID field will appear on the report with the customer data, so you do
not have to include it in the detail records for each contract. Otherwise, Taylor
wants all the fields from the Contract table to be included in the report.
7. Click the button to move all the fields from the Available Fields list box to the
Selected Fields list box.
8. Click Contract.Customer ID in the Selected Fields list box, click the button to
move the selected field back to the Available Fields list box, and then click the
Next button. The second Report Wizard dialog box opens. See Figure 4-20.
Choosing a grouped or ungrouped report
You can display tips for
creating reports and
examples of reports by
clicking the “Show me
more information” button.
click to d isplay
tips and examples