Providing a User Interface for the Hershey College Intramural Department In this project, you…

Providing a User Interface for the Hershey College Intramural
Department

In this project, you continue to work with Marianna Fuentes,
assistant director of the Intramural Department at Hershey College. She has
some concerns about the purchases that coaches have made and asks that you flag
large purchases in the Hershey database. She wants to highlight the large
purchases on-screen and on the written purchases detail report.

In addition, to maintain security and make the Hershey
database easier to use, Marianna does not want the staff to work directly with
the objects in the
»

Providing a User Interface for the Hershey College Intramural
Department

In this project, you continue to work with Marianna Fuentes,
assistant director of the Intramural Department at Hershey College. She has
some concerns about the purchases that coaches have made and asks that you flag
large purchases in the Hershey database. She wants to highlight the large
purchases on-screen and on the written purchases detail report.

In addition, to maintain security and make the Hershey
database easier to use, Marianna does not want the staff to work directly with
the objects in the Navigation pane. Most department employees are not familiar
with Access, and she wants to provide a menu system that includes options users
can choose to open the queries, forms, and reports in the database.

Complete the following:

Recently, a coach turned in a purchase receipt, which the
intramural staff recorded in the database using frmPurchaseData. Later, a staff
member inadvertently deleted the record of that purchase, and no one could find
the original receipt or a copy. Marianna wants to avoid this kind of problem in
the future. In frmPurchaseData, provide a means to caution users when they are
deleting a purchase record. The caution should ask users if they have a receipt
for the purchase and then confirm that the record should be deleted.

»