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:

Marianna asks that you prepare another report similar to
rptCoachPurchasesDetail, but it should provide a summary of the purchases. This
report should contain only the total spent, percentage of budget, and remaining
budget for each sport. Marianna suggests that you use a line in the report to
separate the summary for each sport, and change the font color of the
calculated values as you did in rptCoachPurchasesDetail for sports that are
over their $700 budget. Finally, this report needs a page header on all but the
first page. (Hint: Use the report’s properties to specify where the page header
appears.) Name this report rptCoachPurchasesSummary.

»