You are the general manager of a large hotel chain. Your establishment provides a variety of guest services ranging from rooms and conferences to weddings. The data entry accuracy of your staff could bear some improvement, so you have decided to move to Microsoft Access and implement several data validation techniques. You also will take advantage of Access's Expression Builder to help analyze data.

Steps to Perform:

Step	Instructions	Points Possible
1	Start Access. Open the file named exploring_a05_grader_h2_Hotel.accdb.	0
2	Open the Members table in Design view. Add a phone number input mask to the Phone field. Accept all defaults. Save and close the table.	10
3	Open the Location table in Design view. Change the Required property for the City and Address fields to Yes.	20
4	Convert the LastRenovation field to a Lookup Wizard. Look the values up in the Renovation table. Save and close the Location table.	15
5	Open the Orders table in Design view. Add a validation rule that requires the value of the NumInParty field to be less than or equal to 75. Set validation text to Party sizes cannot exceed 75. (include the period). Save and close the Orders table.	15
6	Create a copy of the Average By Day query. Name the new query Average By Month.	2
7	Delete the ServiceDate field from the Average By Month query. Add a new column using the Expression Builder. Create a formula to extract the name of the month from the ServiceDate field using a combination of the DatePart and MonthName functions. Name the column Month, and move the Month field to the left of the NumInParty field. Run the query. Save and close the query.	20
8	Create a copy of the Average By Month query. Name the new query Average By Month and Year.	2
9	Add a second grouping field between the Month and NumInParty fields. The field should display the four-digit year in the ServiceDate field. Name the new field Year. Sort by Year in ascending order. Run the query. Save and close the query.	16
10	Save the database. Close the database, and then exit Access. Submit the database as directed.	0

Total Points

100