Introduction - Database Processing: Fundamentals, Design, and Implementation - page 32

1.68 Using the Microsoft Access report wizard, create a report named Wedgewood Pacific
Corporation Employee Report that presents the data contained in your EMPLOYEE
table sorted first by employee last name and then by employee first name. Make any
adjustments necessary to the report so that all headings and data display properly.
Print a copy of this report.
1.69 Using the Microsoft Access form wizard, create a form that has all of the data from
both tables. When asked how you want to view your data, select by DEPARTMENT.
Choose the default options for other questions that the wizard asks. Open your form
and page through your departments.
1.70 Using the Microsoft Access report wizard, create a report that has all of the data from
both tables. When asked how you want to view your data, select by DEPARTMENT. For
the data contained in your EMPLOYEE table in the report, specify that it will be sorted
first by employee last name and then by employee first name. Make any adjustments
necessary to the report so that all headings and data display properly. Print a copy of
this report.
1.71 Explain, to the level of detail in this chapter, what is going on within Microsoft Access
in Project Questions 1.67, 1.68, 1.69, and 1.70. What subcomponent created the form
and report? Where is the data stored? What role do you think SQL is playing?