Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / The Prestige Hotel chain caters to upscale business travellers and provides state-of-the-art conference, meeting, and reception facilities

The Prestige Hotel chain caters to upscale business travellers and provides state-of-the-art conference, meeting, and reception facilities

MS Access

The Prestige Hotel chain caters to upscale business travellers and provides state-of-the-art conference, meeting, and reception facilities. It prides itself on its international, four-star cuisine. Last year, it began a member reward club to help the marketing department track the purchasing patterns of its most loyal customers. All of the hotel transactions are stored in the database. Your task is to help the managers of the Prestige Hotels in Denver and Chicago identify their customers who stayed in a room last year and who had three persons in their party.

a. Open a02m2Hotel and save the file us a02m2Hotel_LastFirst. Review the data contained in the three tables. Specifically study the tables and fields containing the data you need to analyze: dates of stays in Denver and Chicago suites, the members’ names, and the numbers in the parties.

b. Import the location data from the Excel file a02m21Location into your database as a new table. The first row of the worksheet contains headings. Set the LocationID Indexed Property to Yes (No Duplicates) and set the Data Type to Long Integer. Select the LocationID field 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 ServiceID 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 with your name. Close the table.

e. Create a query using the following fields: ServiceDate (Orders tables), City (location tables), NoInParty (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 NoInParty criterion to 3. Sort the result in ascending order by the ServiceDate.

f. Run the query and examine the number at records in the status bar at the bottom of the query. It should display 155. If your number of records is different, examine the criteria and make corrections.

g. Change the order of the query fields so that they display as FirstName, LastName, ServiceDate, City, NoInParty, and ServiceName. Save the query as Denver Rooms 3 Guests. Close 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.

J. 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 records returned in the results should equal the sum of the records in the two individual queries (334 records). Run, save, and close the query.

k. Close the database and exit Access. Based on your instructor's directions, submit a02m2Hotel_LastFirst.

Option 1

Low Cost Option
Download this past answer in few clicks

19.99 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

Related Questions