[Solved]Terns Loyal Customers O Help Th Stayed Room Last Year Three Persons Party E Managers Prest Q37243330

terns of its most loyal customers. is o to help th stayed in a room last year and who had three persons in their party e managers of the Prestige Hotels in Denver and Chicago identify their customers who el LastFirst. Review the data contained in eed to ana Open a02m2Hotel and save the file as a02m2Hot a. the three tables. Specifically, study the tables and fields containing the data you n on lyze: dates of stays in Denver and Chicago suites, the members’ names. and the nu parties b. Import the location data from the Excel file a02m2Location into your database as a new tabl xed property The first row of the worksheet contains column headings. Set the LocationID Inde to Yes (No Duplicates) and set the Data Type to Long Integer. Select the Locationll as the primary key. Name the table Location. Do not save the import steps. c. Open the Relationships window and create a relationship between the Location table and the Orders table using the LocationID field. Enforce referential integrity and cascade update related fields. Create a relationship between the Orders and Members tables using the MemNumber field, ensuring that you enforce referential integrity and cascade update related fields. Create a relationship between the Orders and Service tables using the ServicelD field, ensuring that you enforce referential integrity and cascade update related fields. Save and close the Relationships window d. Open the Members table and use the Find command to locate Bryan Gray’s name. Replace his name with your own first and last names. Locate Nicole Lee’s name and replace it with your name. Close the table e. Create a query using the following fields: ServiceDate (Orders table), City (Location table) NolnParty (Orders table). ServiceName (Service table). FirstName (Members table), and LastName (Members table). Set the criteria to limit the output to Denver. Use the Between operator to show services only from 7/1/2017 to 6/30/2018. Set the NolnParty criterion to 3. Sort the results in ascending order by the ServiceDate Run the query and examine the number of records in the status bar at the bottom of the query. It should display i 55. If your number of records is different, examine the criteria and make corrections f. Mid-Level Exercises·Access 2016 Change the order of the query fields so that they display as FirstName, Last Name, Service City. NolnParty, and ServiceName. Save the query as Denver Rooms 3 Guests. Close g. e the query h. Copy the Denver Rooms 3 Guests query and paste it, renaming the new query Chicago Rooms 3 Guests. i. Open the Chicago Rooms 3 Guests query in Design view and change the criterion for City to Chicago. Run the query and save the changes. It should display 179 results. Close the query i. Review the criteria of the two previous queries and then create a third query named Denver and Chicago Rooms 3 Guests. Use the criteria from the two individual queries as a basis to create a combination AND-OR condition. The results will display guests in Denver or Chicago with 3 guests and service dates between 7/1/2013 and 6/30/2018. The reco returned in the results should equal the sum of the records in the two individual queries (334 rds records). Run, save, and close the query k. Close the database and exit Access. Based on your instructor’s directions, submit a02m2Hotel_LastFirst Show transcribed image text terns of its most loyal customers. is o to help th stayed in a room last year and who had three persons in their party e managers of the Prestige Hotels in Denver and Chicago identify their customers who el LastFirst. Review the data contained in eed to ana Open a02m2Hotel and save the file as a02m2Hot a. the three tables. Specifically, study the tables and fields containing the data you n on lyze: dates of stays in Denver and Chicago suites, the members’ names. and the nu parties b. Import the location data from the Excel file a02m2Location into your database as a new tabl xed property The first row of the worksheet contains column headings. Set the LocationID Inde to Yes (No Duplicates) and set the Data Type to Long Integer. Select the Locationll as the primary key. Name the table Location. Do not save the import steps. c. Open the Relationships window and create a relationship between the Location table and the Orders table using the LocationID field. Enforce referential integrity and cascade update related fields. Create a relationship between the Orders and Members tables using the MemNumber field, ensuring that you enforce referential integrity and cascade update related fields. Create a relationship between the Orders and Service tables using the ServicelD field, ensuring that you enforce referential integrity and cascade update related fields. Save and close the Relationships window d. Open the Members table and use the Find command to locate Bryan Gray’s name. Replace his name with your own first and last names. Locate Nicole Lee’s name and replace it with your name. Close the table e. Create a query using the following fields: ServiceDate (Orders table), City (Location table) NolnParty (Orders table). ServiceName (Service table). FirstName (Members table), and LastName (Members table). Set the criteria to limit the output to Denver. Use the Between operator to show services only from 7/1/2017 to 6/30/2018. Set the NolnParty criterion to 3. Sort the results in ascending order by the ServiceDate Run the query and examine the number of records in the status bar at the bottom of the query. It should display i 55. If your number of records is different, examine the criteria and make corrections f. Mid-Level Exercises·Access 2016
Change the order of the query fields so that they display as FirstName, Last Name, Service City. NolnParty, and ServiceName. Save the query as Denver Rooms 3 Guests. Close g. e the query h. Copy the Denver Rooms 3 Guests query and paste it, renaming the new query Chicago Rooms 3 Guests. i. Open the Chicago Rooms 3 Guests query in Design view and change the criterion for City to Chicago. Run the query and save the changes. It should display 179 results. Close the query i. Review the criteria of the two previous queries and then create a third query named Denver and Chicago Rooms 3 Guests. Use the criteria from the two individual queries as a basis to create a combination AND-OR condition. The results will display guests in Denver or Chicago with 3 guests and service dates between 7/1/2013 and 6/30/2018. The reco returned in the results should equal the sum of the records in the two individual queries (334 rds records). Run, save, and close the query k. Close the database and exit Access. Based on your instructor’s directions, submit a02m2Hotel_LastFirst

Expert Answer

---

Answer to terns of its most loyal customers. is o to help th stayed in a room last year and who had three persons in their party e… . . .