Microsoft Office Tutorials and References
In Depth Information
Session 4.2
Figure 4-19
Report sketch for the Employers and Positions report
Employers and Positions
fields from
the related
Position table
Employer ID
XXXXX
X
Contact First Name X
X
X
X
Employer Name
X
Contact Last Name
City
State/Prov
X
X
X
X
Phone
XX
fields from
the primary
Employer table
Position ID Position Title Wage Hours/Week Experience Start Date End Date Openings
XXXX
XXXX
XXXX
X
X
X
X
XX
XX
XX
XX/XX/XXXX
XX/XX/XXXX
XX/XX/XXXX
XX/XX/XXXX
XX/XX/XXXX
XX/XX/XXXX
X
X
X
X
X
X
X
detail records
X
X
X
X
(Repeat next employer and positions here)
(Repeat next employer and positions here)
(Repeat next employer and positions here)
date
Page X of X
You’ll use the Report Wizard to create the report according to the design in Zack’s sketch.
To start the Report Wizard and select the fields to include in the report:
1. Click Reports in the Objects bar of the Database window to display the Reports list box.
You have not yet created any reports.
2. Click the New button in the Database window. The New Report 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. You will select the primary Employer table in the New Report dialog box.
3. Click Report Wizard , click the list arrow for choosing a table or query, and then click
Employer .
4. Click the OK button. The first Report Wizard dialog box opens.
In the first Report Wizard dialog box, you select fields in the order you want them to
appear on the report. Zack wants the EmployerID, EmployerName, City, StateProv,
ContactFirstName, ContactLastName, and Phone fields from the Employer table to appear
on the report.
 
Search JabSto ::




Custom Search