client/index.html#/desktop Mailings EX19 AC CH05 GRADER ML1 HW Instructions (Protected View) - Word Review View Help Tell me what you want to do Enable Editing viruses. Unless you need to edit, it's safer to stay in Protected View. 1 2 Start Access. Open the file named Exp 19 Access Ch05 ML1 Hotel.accdb. Grader has automatically added your last name to the beginning of the filename. The first thing that you would like to ensure is that members' phone numbers are entered into. the database accurately in the common format for phone numbers. To do this you will add an input mask that will show the user the desired format as they are entering phone numbers. 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. 3 Next you would like to ensure that the City and Address fields must be filled out for each location in the Location table. Open the Location table in Design view. Change the Required property for the City and Address fields to Yes. 4 You'd like to next make it easier for users to add information on the last time a location was renovated. You will convert the LastRenovation field in the Location table to a lookup field, using the Renovation table as the source for the values in the lookup field. Convert the LastRenovation field to a Lookup Wizard. Look the values up in the Renovation table Save and close the Location table 5 6 7 Possible 0 10 20 20 15 The hotel can only host parties of no more than 70 people at a time. You would like to ensure that parties of more than 70 people are not permitted in the Order table. To do this you will add a data validation rule to the NuminParty field of the Orders table. 15 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 70. Set validation text to Party sizes cannot exceed 70. (include the period) Save and close the Orders table. It would be useful for you to know what the average party size is month over month. You'll find this information by creating a query and extracting the month from the ServiceDate field via the DatePart function then using the MonthName function to display the month name rather than the month number. Create a copy of the Average By Day query. Name the new query Average By Month. Open the query in Design view. 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 2 20 cted View) Balance for w06523... EX19 AC CH05 GR... Access-Bush Exp1... MerBonic An