Creating Meaningful Reports for the Hershey College Intramural Department In this project, you help.

Creating Meaningful Reports for the Hershey College
Intramural Department

In this project, you help Marianna Fuentes, assistant
director of the intramural department at Hershey College, to create reports for
the department. First, Marianna needs to print labels that identify the
equipment. Then she needs a report of the coaches’ purchases. Each coach has
been given $700 to spend on each of their assigned sports. This budget is for
items that are not supplied directly through the department, such as shirts,
water bottles, or trophies. As coaches make their purchases, they are to submit
»

Creating Meaningful Reports for the Hershey College
Intramural Department

In this project, you help Marianna Fuentes, assistant
director of the intramural department at Hershey College, to create reports for
the department. First, Marianna needs to print labels that identify the
equipment. Then she needs a report of the coaches’ purchases. Each coach has
been given $700 to spend on each of their assigned sports. This budget is for
items that are not supplied directly through the department, such as shirts,
water bottles, or trophies. As coaches make their purchases, they are to submit
their receipts to Marianna. Marianna has been recording the receipts in a
separate database and wants that data now to be incorporated with the
department database. She asks if you can import the data into the database and
then generate some reports based on this data.

Complete the following:

Before you can create the coach purchases report, you need
to import the data from Marianna’s database. The database,
CoachPurchases.accdb, is located in the Chapter  5EOCCase 3 folder. The
data you need is in the tblPurchaseByCoach table. Be sure you establish
appropriate relationships after you have imported the tblPurchaseByCoach table.

»