Order Now

Exp19_Access_Ch02_ML2 – Prestige Hotel 1.0

11 min read
Posted on 
November 10th, 2022
Home Exp19_Access_Ch02_ML2 - Prestige Hotel 1.0

hady_

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

EX19_AC_CH02_GRADER_ML2_HW

1.zip
  

Exp19_Access_Ch02_ML2 – Prestige Hotel 1.0

EX19_AC_CH02_GRADER_ML2_HW
  

Project Description:

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 help 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 help 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.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

     

Start Access. Open the downloaded   Access file named Exp19_Access_Ch02_ML2_Hotel. 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 Location.xlsx   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 Location   and do not save the import steps.

 

View   the Location table in Design view and change the field size for the   LocationID field to Long Integer.   Save the table. Click Yes in the   dialog box indicating that some data may be lost. Close the table.

 

Add   the Location, Orders, Members, and Service tables 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 Location,   Members, Orders, and Service tables.   Add the following fields to the query (in this order): ServiceDate from the Orders table; City from the Location table, NoInParty from Orders table; ServiceName   from the Service table; and FirstName   and LastName from the Members   table. Set the criteria in city field to limit the output to Denver.

 

Display   only service dates from 7/1/2017   to 6/30/2018 (Hint:   Use the Between   command).

 

Set   the NoInParty criterion to 2.   Sort the results in ascending order by the ServiceDate. Run and save the   query with the name Denver Rooms 2 Guests.

 

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 Denver Rooms 2 Guests query   and paste it in the Navigation pane, renaming the new query Chicago Rooms 2 Guests.

 

Open   the Chicago Rooms 2 Guests query   in Design view, and change the City criterion from Denver to Chicago.   Run the query and save the changes. Close the query.

 

Close   the database and exit Access. Submit the database as directed.

EX19_AC_CH02_GRADER_ML2_HW_Instructions x
Grader – Instructions Access 2019 Project

Exp19_Access_Ch02_ML2 – Prestige Hotel 1.0

Project Description:

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 help 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 help 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.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access file named Exp19_Access_Ch02_ML2_Hotel. 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.

0

2

Import the location data from the Excel file Location.xlsx 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 Location and do not save the import steps.

13

3

View the Location table in Design view and change the field size for the LocationID field to Long Integer. Save the table. Click Yes in the dialog box indicating that some data may be lost. Close the table.

6

4

Add the Location, Orders, Members, and Service tables 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.

13

5

Create a relationship between the Members and Orders tables using the MemNumber field, ensuring that you enforce referential integrity and cascade update related fields.

9

6

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.

9

7

Create a new query in Design view using Location, Members, Orders, and Service tables. Add the following fields to the query (in this order): ServiceDate from the Orders table; City from the Location table, NoInParty from Orders table; ServiceName from the Service table; and FirstName and LastName from the Members table. Set the criteria in city field to limit the output to Denver.

9

8

Display only service dates from 7/1/2017 to 6/30/2018 (Hint: Use the Between command).

7

9

Set the NoInParty criterion to 2. Sort the results in ascending order by the ServiceDate. Run and save the query with the name Denver Rooms 2 Guests.

13

10

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.

6

11

Copy the Denver Rooms 2 Guests query and paste it in the Navigation pane, renaming the new query Chicago Rooms 2 Guests.

8

12

Open the Chicago Rooms 2 Guests query in Design view, and change the City criterion from Denver to Chicago. Run the query and save the changes. Close the query.

7

13

Close the database and exit Access. Submit the database as directed.

0

Total Points

100

Created On: 07/11/2019 1 Exp19_Access_Ch02_ML2 – Prestige Hotel 1.0

hady_Exp19_Access_Ch02_ML2_Hotel.accdb

MemNumber LastName FirstName JoinDate Address City State Zip Phone email mSysRowId

3109 Gurganus Leigh 2/8/04 1019 BROWNING RD. FISHERS IN 46038-8360 PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

4310 Joyner Deborah 3/20/03 159 PATRICK LN CHARLOTTE NC 28226 9.198441189E9 DJoyner@earthlink.net. PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

5067 Little Joe 2/12/03 217 MCCRAE LN APT A SWANSBORO NC 28584 3.362970425E9 PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

5101 Loeffler Diana 12/13/03 2202 SOUTHERN HILLS DR STOKESDALE NC 27357-7405 3.366438276E9 DLoeffler@juno.com PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

5579 McKay John 12/14/03 2708 MOORSFIELD CT PINEHURST NC 28374-8105 3.362888493E9 PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

6634 Pence Glenda 2/7/04 3921 LAWNDALE PLACE CHAPEL HILL NC 27517-5663 GPence@mymailstation.com PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

6918 Powell Fred 7/1/04 4201 N. MAIN ST APT #206 CERES VA 24318-0010 PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

7109 Ransdell Denise 6/25/04 4411 HALSTEAD DRIVE CANTON GA 30114-4509 7.044363037E9 PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

8056 Sigler JR 2/12/03 5914 SHADY GROVE CIRCLE CRYSTAL LAKE IL 60014-8410 7.045969744E9 JSigler@msn.com PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

8528 Straight Karen 7/31/03 6914 VALHALLA CT. SCOTIA NY 12302 PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

9722 Wise Madeline 7/9/04 PO BOX 2505 HIGH POINT NC 27260-2519 3.366335215E9 MWise@yahoo.com PA5amqRkZHZy+O5TUL1QWOreI1szCb8mw7Oqu3GIQ7M=-~IvhWY1PEV8/acsKpv3BqPQ==

ID mSysRowId

1 Y6pwW2zoKK1srztwarV+5t9xNZ9rPtHKBA26S319HVU=-~Bcu6djJRMWsQIG98uhpDBQ==

OrderID MemNumber ServiceDate ServiceID NoInParty LocationID mSysRowId

1 5067 4/19/17 4 3.0 16 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

2 5067 4/19/17 1 1.0 20 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

3 5067 4/19/17 3 1.0 1 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

4 5067 4/19/17 1 1.0 6 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

5 5067 4/19/17 4 1.0 19 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

6 5067 4/19/17 1 2.0 18 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

7 8056 4/30/17 6 2.0 5 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

8 8056 4/30/17 5 1.0 6 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

9 8056 4/30/17 2 1.0 13 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

10 8056 4/30/17 5 1.0 3 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

11 8056 4/30/17 3 2.0 7 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

12 8056 4/30/17 6 1.0 4 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

13 8528 5/23/17 4 1.0 12 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

14 8528 5/23/17 1 1.0 7 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

15 8528 5/23/17 4 3.0 10 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

16 8528 5/23/17 3 3.0 8 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

17 8528 5/23/17 3 3.0 14 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

18 8528 5/23/17 2 2.0 4 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

19 5579 6/30/17 6 2.0 17 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

20 5579 6/30/17 5 1.0 9 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

21 5579 6/30/17 6 1.0 5 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

22 5579 6/30/17 5 3.0 13 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

23 5579 6/30/17 1 2.0 10 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

24 5579 6/30/17 4 2.0 8 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

25 9722 7/15/17 3 3.0 17 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

26 9722 7/15/17 4 2.0 13 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

27 9722 7/15/18 3 1.0 4 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

28 9722 7/15/18 5 2.0 4 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

29 9722 7/15/18 5 1.0 9 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

30 9722 7/15/18 2 1.0 5 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

31 5101 7/18/18 1 2.0 15 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

32 5101 7/18/18 5 1.0 12 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

33 5101 7/18/18 3 2.0 6 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

34 5101 7/18/18 5 1.0 11 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

35 5101 7/18/18 3 3.0 3 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

36 5101 7/18/18 5 1.0 16 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

37 7109 7/19/18 5 3.0 6 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

38 7109 7/19/17 3 2.0 8 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

39 7109 7/19/17 4 2.0 18 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

40 7109 7/19/17 2 1.0 4 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

41 7109 7/19/17 3 3.0 5 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

42 7109 7/19/17 4 1.0 19 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

43 3109 8/7/17 1 1.0 9 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

44 3109 8/7/17 6 2.0 3 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

45 3109 8/7/17 5 1.0 16 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

46 3109 8/7/17 4 2.0 9 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

47 3109 8/7/17 1 1.0 14 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

48 3109 8/7/17 3 2.0 8 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

57 4310 9/29/17 1 2.0 5 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

62 6918 9/30/17 5 2.0 5 MU1Iy7qYxXHAqUo3OVQTym5v+1lLBWOdVCI5yWDVji4=-~BlkxjuoeK8pJM8QrwlF51Q==

ServiceID ServiceName PerPersonCharge mSysRowId

1 Room 185.0

2 Conference Room 10.0

3 Suite 245.0

4 Banquette 35.0

5 Wedding 20.0

6 Event 30.0

Location.xlsx
Location

LocationID City Address

1 Miami Airport

2 Boston Downtown

3 Atlanta Downtown

4 New York Manhattan

5 Chicago Loop

6 Pittsburgh Point

7 St Paul Downtown

8 Los Angeles Airport

9 Cleveland Lake

10 St Louis Convention Center

11 Knoxville Convention Center

12 Houston Downtown

13 Los Angeles Downtown

14 Seattle Airport

15 Miami Downtown

16 Las Vegas Strip

17 San Francisco Downtown

18 Denver Downtown

19 Portland Downtown

20 New York JFK

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order
Calculate the price
Pages (275 words)
$0.00
Paper Answers
Company
Legal
How Our Service is Used:
Paper Answers essays are NOT intended to be forwarded as finalized work as it is only strictly meant to be used for research and study purposes. Paper Answers does not endorse or condone any type of plagiarism.
Subscribe
No Spam
© 2025 Paper Answers. All rights reserved.
Paper Answers will be listed as ‘Paper Answers’ on your bank statement.

Order your essay today and save 30% with the discount code ESSAYHELP

Order Now