In this exercise, you will use database to analyze the reservation transactions for a hotel and use that information to fine-tune the hotels 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 Presidents 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 Inns current business situation and suggest future strategies in your Word document.

Reservations [ - Guest First Name - Guest Last Nam 1 Barry Lloyd 2 Michael Lunsford 3Kim Kyuong 4 Edward Holt 5 Thomas Collins 6 Paul Bodkin 7 Randall Battenburg 8 Calvin Nowotney 9 Homer Gonzalez 10 David Sanchez 11 Buster Whisler 12 Julia Martines 13 Samuel Kim 14 Arthur Gottfried 15 Darlene Shore 16 Carlyle Charleston 17 Albert Goldstone 18 Charlene Tilson 19 Everett Chad 20 Gerald Pittsfield 21 Jamal Smith 22 Louis Paris 23 Nigel Stratford 24 Peter Willington 25 Ronald Cartier 26 Trista Leven 27 Valerie Snell 28 Walter Acton 29 Xavier Trezza 30 Zachary Miller Room - Room Type - Arrival Dat - Departure Dat - No of Gues - Daily Rat - Click to Add . Hayes Bay-window 12/1/2015 12/4/2015 2 $150.00 Cleveland Ocean 12/1/2015 12/9/2015 3 $112.50 Coolidge Bay-window 12/4/2015 12/7/2015 1 $150.00 Washington Ocean 12/1/2015 12/3/2015 4 $325.00 Lincoln Ocean 12/9/2015 12/13/2015 $300.00 Coolidge Bay-window 12/1/2015 12/3/2015 2 $150.00 Washington Ocean 12/4/2015 12/12/2015 $292.50 Lincoln Ocean 12/2/2015 12/4/2015 1 $300.00 Lincoln Ocean 12/5/2015 12/7/2015 5 $320.00 Jefferson Bay-window 12/5/2015 12/7/2015 2 $175.00 Jackson Ocean 12/5/2015 12/8/2015 2 $250.00 Reagan Bay-window 12/10/2015 12/15/2015 1 $150.00 Truman Side 12/20/2015 12/30/2015 3 $112.50 Garfield Side 12/13/2015 12/15/2015 2 $125.00 Arthur Ocean 12/24/2015 12/31/2015 5 $198.00 Quincy Adams Bay-window 12/3/2015 12/6/2015 2 $150.00 Johnson Ocean 12/5/2015 12/7/2015 $250.00 Van Buren Bay-window 12/5/2015 12/7/2015 $150.00 Madison Ocean 12/10/2015 12/14/2015 $275.00 Roosevelt Ocean 12/5/2015 12/7/2015 $275.00 Tyler Bay-window 12/20/2015 12/23/2015 2 $150.00 Jackson Ocean 12/10/2015 12/14/2015 1 $250.00 Eisenhower Ocean 12/14/2015 12/16/2015 2 $200.00 Grant Ocean 12/19/2015 12/21/2015 1 $200.00 Jefferson Bay-window 12/24/2015 12/28/2015 4 $175.00 Eisenhower Ocean 12/17/2015 12/20/2015 1 $200.00 Adams Bay-window 12/3/2015 12/6/2015 1 $150.00 Polk Side 12/24/2015 12/31/2015 $148.50 McKinley Side 12/14/2015 12/17/2015 $125.00 Washington Ocean 12/13/2015 12/16/2015 $325.00 $0.00 ONNO DANN NNWN UNWANN NNN AWN * ew)