Microsoft Office Tutorials and References
In Depth Information
a. Save the report as rptTeacherLessons .
b. The LastName field (from the tblTeacher table) is a grouping field.
c. The LessonType field is a sort field, and the LastName field (from the tblStudent
table) is a sort field.
d. Hide duplicate values for the LessonType field.
e. Add the FirstName field (from the tblTeacher table) to the Group Header section,
and then delete its attached label.
5. Create a mailing label report according to the following instructions:
a. Use the tblStudent table as the record source.
b. Use Avery C2160 labels, use a larger font size and a heavier font weight, and use
the other default font and color options.
c. For the prototype label, place FirstName, a space, and LastName on the first line;
Address 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 enter
the report name
e. Change the mailing label layout to snaking columns.
6. Close the Contract database without exiting Access, make a backup copy of the
database, open the Contract database, compact and repair the database, close the
database, and then exit Access.