Microsoft Office Tutorials and References
In Depth Information
| Case Problem 2
Apply what you
learned in the tutorial
to work with the data
for a health and
Data File needed for this Case Problem: Training.accdb ( cont. from Tutorial 6 )
Parkhurst Health & Fitness Center Martha Parkhurst wants you to create a custom
report and mailing labels for the Training database. The custom report will be based on
the results of a query you will create. You will create the query, the custom report, and
the mailing labels by completing the following steps:
1. Open the Training database located in the Level.02\Case2 folder provided with your
2. Create a query that displays the ProgramID, ProgramType, and MonthlyFee fields
from the tblProgram table, and the MembershipStatus, FirstName, and LastName
fields from the tblMember table. Sort in ascending order by the ProgramID,
MembershipStatus, and LastName fields, and then save the query as
3. Create a custom report based on the qryProgramMembership query. Figure 7-49
shows a sample of the last page of the completed report. Refer to the figure as you
create the report.
a. Save the report as rptProgramMembership .
b. The ProgramID field is a grouping field.
c. The MembershipStatus field is a sort field, and the LastName field is a sort field.
d. Hide duplicate values for the MembershipStatus field.
e. Add the ProgramType field to the Group Header section, and then delete its
4. Use the following instructions to create the mailing labels:
a. Use the tblMember table as the record source for the mailing labels.
b. Use Avery C2160 labels, and use the default font and color.
c. For the prototype label, place FirstName, a space, and LastName on the first line;
Street on the second line; and City, a space, State, a space, and Zip on the
d. Sort by Zip and then by LastName, and then type the report name rptMemberLabels .
5. Close the Training database with out exiting Access, make a backup copy of the
database, open the Training database, compact and repair the database, close the
database, and then exit Access.