Hotel Chain Project

Description: You are assisting the general manager of a large hotel chain. You perform several tasks for the general manager, including calculating the total revenue for each service for each city where the chain has a hotel. You will also find duplicate names in the Location table. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions 1. Start Access. Open the downloaded access database named exploring_a06_Grader_h3. Save the database as exploring_a06_Grader_h3_LastFirst. 2. Create a crosstab query based on the Revenue query. Hint: On the Create tab, in the Queries group, click Query Wizard. Click Crosstab Query Wizard. 3. Use the ServiceName field for the row headings, the City field for the column headings, and the Revenue field for the row and column intersection. Sum the Revenue field. Save the query as Revenue_Crosstab. 4. Format the Revenue and Total of Revenue crosstab values as Currency. Run the query. Save and close the Revenue_Crosstab query. Hint: On the Home tab, in the Views group, click View. Right-click each field name, and from the shortcut menu, click Properties. 5. Create a copy of the Revenue_Crosstab query and save it as Revenue_Crosstab2. 6. Modify the query so that the City field is used for the row headings and the ServiceName field is used for the column headings. Run the query, save the query, and then close it. 7. Create a find unmatched query that displays repeat members from Raleigh who have no matching orders. Records from the Repeat Members Club table should display in the results. Include all fields from the table. Run the query and save it as Raleigh Members Without Matching Orders. 8. Create a copy of the Raleigh Members Without Matching Orders query and save it as Charlotte Members Without Matching Orders. 9. Modify the query so that Charlotte members who have no matching orders are displayed in the results. Run, save, and then close the query. 10. Create a find duplicates query that displays any locations that have the same city and address. Display the LocationID field as an additional field in the third column of the query. Run the query and save it as Find Duplicate Locations. 11. Change the Address for LocationID 15 to Downtown in the query results. Close the query. 12. Save the database. Close the database, and then exit Access. Submit the database as directed.  Hotel Chain EX16_AC_CH06_GRADER_ML2_HW