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 needs a report that shows what each coach has spent
from their $700 budget for each sport. The report should show the sport,
the coach name, the purchases for that sport, and the total spent. Because this
is the first year they are using a budget, the intramural staff is aware that
the purchases might exceed the budget.

She also says that for each sport, you should show the
percentage of the budget that has been spent, as well as the remaining amount
in the budget. (Hint: This could be a negative number.) She also asks you to
indicate those sports that have gone over budget by changing the font color of
each of the calculated values: the total amount, the percentage of the budget,
and the remaining amount in the budget. The date and time of printing should
also appear near the title of the report, and the Hershey college logo should
appear on all reports. Name the report rptCoachPurchasesDetail.

»