Enhancing the Database for Hershey College Marianna Fuentes, assistant director of the Intramural…

Enhancing the Database for Hershey College

Marianna Fuentes, assistant director of the Intramural Department
at Hershey College, is concerned about the purchases that coaches have made.
She asks that you “flag” large unapproved purchases in frmPurchaseData with a
message box indicating that the purchase requires her approval, and to put a
message on the form when the amount exceeds $100. Marianna is also finding
transposed phone area codes in the database. Because the college is located in
an area with only one phone area code, she asks if there is a way to ask the
user to confirm the
»

Enhancing the Database for Hershey College

Marianna Fuentes, assistant director of the Intramural Department
at Hershey College, is concerned about the purchases that coaches have made.
She asks that you “flag” large unapproved purchases in frmPurchaseData with a
message box indicating that the purchase requires her approval, and to put a
message on the form when the amount exceeds $100. Marianna is also finding
transposed phone area codes in the database. Because the college is located in
an area with only one phone area code, she asks if there is a way to ask the
user to confirm the entry of telephone and cell phone numbers when they do not
begin with the 717 area code.

Complete the following:

Use Help to learn about the CurrentUser method, and then use
this method to display the name of the current user when frmStudentData is
opened, which will be the On Load event. Have a message box display with the
text “Database currently being viewed by:” (Hint: You will add &
CurrentUser( ) to the end of the previous statement. Note: If you are working
in a secured database, this would be the name of the user who has logged in. If
you are using an unsecured database, this function would return Admin, which is
the default account name of the user.

»