Exp19_Access_Ch05_ML1 – Hotel Chain 1.2 Grader – Instructions Access 2019 Project Exp19_Access_Ch05_ML1 – Hotel Chain 1.2 Project Description: You are

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Grader – Instructions Access 2019 Project

Exp19_Access_Ch05_ML1 – Hotel Chain 1.2

Project Description:

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 Exp19_Access_Ch05_ML1_Hotel.accdb. Grader has automatically added your last name to the beginning of the filename.

0

2

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.

10

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.

20

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.

15

5

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.

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.

15

6

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.

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

Now that you know what the average party size is month over month, you would like to include the year as well. You’ll add this information to a new query by extracting the year from the ServiceDate field via the Year function.

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

Created On: 07/11/2019 1 Exp19_Access_Ch05_ML1 – Hotel Chain 1.2

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality