The Prestige Hotel chain caters to upscale business travelers 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

The Prestige Hotel chain caters to upscale business travelers 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 the marketing department track the purchasing patterns of its most loyal customers. All of the hotel transactions are stored in a database. Your task is to the managers of the Prestige Hotels in Denver and Chicago identify their customers who stayed in a room last year and who had two persons in their party. Start Access. Open the downloaded   Access file named . Grader has automatically added   your last name to the beginning of the filename. Save the file to the   location where you are storing your files. Import   the location data from the Excel file as a new table in the current database. Using the wizard, specify that the   first row contains column headings, set the LocationID field to be indexed   with no duplicates, and set the LocationID field as the primary key. Import   the table with the default name and do not save the import steps. View   the Location table in Design view and change the field size for the   LocationID field to .   Save the table. Click in the   dialog box indicating that some data may be lost. Close the table. Add   the , , , and to the Relationships window to begin establishing   relationships in the database. Close the Show Table dialog box. Create a   one-to-many relationship between the Location table and the Orders table   using the LocationID field. Enforce Referential Integrity. Select the option   to cascade update the related fields. Create   a relationship between the Members and Orders tables using the MemNumber   field, ensuring that you enforce referential integrity and cascade update   related fields. Create   a relationship between the Service and Orders tables using the ServiceID   field, ensuring that you enforce referential integrity and cascade update   related fields. Save and close the Relationships window. Create   a new query in Design view using , , , and .   Add the following fields to the query (in this order): from the Orders table; from the Location table, from Orders table; from the Service table; and and from the Members   table. Set the criteria in city field to limit the output to . Display   only service dates from to (nt:   Use the command). Set   the NoInParty criterion to .   Sort the results in ascending order by the ServiceDate. Run and save the   query with the name . Use   Design view to change the order of the query fields so that they display as   FirstName, LastName, ServiceDate, City, NoInParty, and ServiceName. Run, save   the changes to the query, and close the query. Copy   the and paste it in the Navigation pane, renaming the new query . Open   the in Design view, and change the City criterion from to .   Run the query and save the changes. Close the query. Close   the database and exit Access. Submit the database as directed.

Do you need us to help you on this or any other assignment?


Make an Order Now