6. (12 points) In this exercise, you will use database to analyze the reservation transactions for a hotel and use that information to fine-tune the hotel's business strategy and marketing activities. This exercise encourages you to develop queries and reports in a database software to help you make better use of transaction data to understand your business. The attached file Hotel contains information about The President's Inn hotel in Cape May, NJ. At the Inn, 10 rooms overlook side streets, 10 rooms have bay windows with limited views of the ocean, and the remaining 10 rooms in the front of the hotel face the ocean. Room rates are based on room choice, length of stay, and number of guests per room. Room rates are the same for one to four guests. Fifth and sixth guests must pay an additional $20 per person per day. Guests staying for seven days or more receive a 10 percent discount on their daily room rates. Use the database to develop three reports on average length of stay per room type, average visitors per room type, and base revenue per room (i.e., length of visit multiplied by the daily rate) during the period of time in the database. You may use the query wizard and report wizard capabilities of Access. From analyzing these data, you should be able to find ways of generating more revenue. After completing your database work, write one-paragraph report about the Inn's current business situation and suggest future strategies in your Word document. Tables Reservations BEB Il Guest First Nam Guest Last Nam. 1 Barry Lloyd Lunsford 2 Michael 3 Kim Kyuong Holt 4 Edward 5 Thomas Collins 6 Paul Bodkin 7 Randall Battenburg 8 Calvin Nowotney 9 Homer Gonzalez Sanchez Whisler Martines Kim Gottfried Shore Charleston Goldstone Tilson Chad Pittsfield Smith Paris Stratford Willington Cartier Leven Snell Acton Trezza Miller 10 David 11 Buster 12 Julia 13 Samuel 14 Arthur 15 Darlene Carlyle 17 Albert 18 Charlene 19 Everett 20 Gerald 21 Jamal 22 Louis 23 Nigel 24 Peter 25 Ronald 26 Trista 27 Valerie 28 Walter 29 Xavier 30 Zachary Record: H 1 of 30 HA No Filter Reservations Room Room Typ Arrival Da Departure Da No of Gues Daily Ral Clic Bay-window 12/1/2015 12/4/2015 2 $150.00 Ocean 12/1/2015 12/9/2015 3 $112.50 Hayes Cleveland Coolidge Washington Bay-window 12/4/2015 12/7/2015 1 Ocean 12/1/2015 12/3/2015 Lincoln Ocean 12/9/2015 12/13/2015 $150.00 4 $325.00 2 $300.00 2 $150.00 $292.50 $300.00 12/3/2015 Coolidge Washington Bay-window 12/1/2015 Ocean 12/4/2015 12/12/2015 2 Lincoln Ocean 12/2/2015 12/4/2015 1 Lincoln Ocean 12/5/2015 12/7/2015 Jefferson Bay-window 12/5/2015 12/7/2015 Jackson 12/5/2015 12/8/2015 Reagan Ocean Bay-window Side 12/10/2015 12/15/2015 Truman 12/20/2015 12/30/2015 Garfield Side 12/13/2015 12/15/2015 5 $320.00 2 $175.00 2 $250.00 1 $150.00 3 $112.50 2 $125.00 5 $198.00 2 $150.00 3 $250.00 1 $150.00 2 $275.00 Arthur Ocean 12/24/2015 12/31/2015 Quincy Adams Bay-window 12/3/2015 12/6/2015 Johnson 12/5/2015 Ocean Bay-window 12/7/2015 12/7/2015 Van Buren 12/5/2015 Madison Ocean 12/10/2015 12/14/2015 Roosevelt Ocean 12/5/2015 12/7/2015 Bay-window 12/20/2015 12/23/2015 2 Tyler Jackson Eisenhower 12/10/2015 12/14/2015 Ocean Ocean Ocean 2 $275.00 $150.00 1 $250.00 2 $200.00 1 $200.00 12/14/2015 12/16/2015 Grant 12/19/2015 12/21/2015 Jefferson Bay-window 12/24/2015 12/28/2015 4 Eisenhower Ocean 12/17/2015 12/20/2015 1 $175.00 $200.00 $150.00 Adams Bay-window 12/3/2015 12/6/2015 1 Polk Side 12/24/2015 12/31/2015 6 $148.50 McKinley Side 12/14/2015 12/17/2015 2 $125.00 Washington Ocean 12/13/2015 12/16/2015 2 $325.00 Search