1. In MyLab MIS, you will find a database for hotel reservation transactions developed in Microsoft Access with information about the Presidents Inn in Cape May, New Jersey. At the Inn, 10 rooms overlook side streets, 10 rooms have bay windows that offer 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 charge each per person per day. Guests staying for seven days or more receive a 10 percent discount on their daily room rates. The owners currently use a manual reservation and bookkeeping system, which has caused many problems. Use the database to develop reports on average length of stay, average visitors per room, base revenue per room (i.e., length of visit multiplied by the daily rate), and strongest customer base. After answering these questions, write a brief report about the Inns current business situation and suggest future strategies.

E Reservations ID Click to Add - Guest First Name - Guest Last Name - 1 Barry Lloyd 2 Michael Lunsford 3 Km 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 (New) Room - Room Type - Arrival Date - Departure Date - No of Guests Hayes Bay-window 12/1/2014 12/4/2014 Cleveland Ocean 12/1/2014 12/9/2014 Coolidge Bay-window 12/4/2014 12/7/2014 Washington Ocean 12/1/2014 12/3/2014 Lincoln Ocean 12/9/2014 12/13/2014 Coolidge Bay-window 12/1/2014 12/3/2014 Washington Ocean 12/4/2014 12/12/2014 Lincoln Ocean 12/2/2014 12/4/2014 Lincoln Ocean 12/5/2014 12/7/2014 Jefferson Bay-window 12/5/2014 12/7/2014 Jackson Ocean 12/5/2014 12/8/2014 Reagan Bay-window 12/10/2014 12/15/2014 Truman Side 12/20/2014 12/30/2014 Garfield Side 12/13/2014 12/15/2014 Arthur Ocean 12/24/2014 12/31/2014 Quincy Adams Bay-window 12/3/2014 12/6/2014 Johnson Ocean 12/5/2014 12/7/2014 Van Buren Bay-window 12/5/2014 12/7/2014 Madison Ocean 12/10/2014 12/14/2014 Roosevelt Ocean 12/5/2014 12/7/2014 Tyler Bay-window 12/20/2014 12/23/2014 Jack Ocean 12/10/2014 12/14/2014 Eisenhower Ocean 12/14/2014 12/16/2014 Grant Ocean 12/19/2014 12/21/2014 Jefferson Bay-window 12/24/2014 12/28/2014 Eisenhower Ocean 12/17/2014 12/20/2014 Adams Bay-window 12/3/2014 12/6/2014 Polk Side 12/24/2014 12/31/2014 McKinley Side 12/14/2014 12/17/2014 Washington Ocean 12/13/2014 12/16/2014 2 3 1 4 2 2 2 1 5 2 2 1 3 2 5 2 3 1 2 2 2 1 2 1 4 1 1 6 2 2 0 Daily Rate $150.00 $112.50 $150.00 $325.00 $300.00 $150.00 $292.50 $300.00 $320.00 $175.00 $250.00 $150.00 $112.50 $125.00 $198.00 $150.00 $250.00 $150.00 $275.00 $275.00 $150.00 50.00 $200.00 $200.00 $175.00 $200.00 $150.00 $148.50 $125.00 $325.00 $0.00 E Reservations ID Click to Add - Guest First Name - Guest Last Name - 1 Barry Lloyd 2 Michael Lunsford 3 Km 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 (New) Room - Room Type - Arrival Date - Departure Date - No of Guests Hayes Bay-window 12/1/2014 12/4/2014 Cleveland Ocean 12/1/2014 12/9/2014 Coolidge Bay-window 12/4/2014 12/7/2014 Washington Ocean 12/1/2014 12/3/2014 Lincoln Ocean 12/9/2014 12/13/2014 Coolidge Bay-window 12/1/2014 12/3/2014 Washington Ocean 12/4/2014 12/12/2014 Lincoln Ocean 12/2/2014 12/4/2014 Lincoln Ocean 12/5/2014 12/7/2014 Jefferson Bay-window 12/5/2014 12/7/2014 Jackson Ocean 12/5/2014 12/8/2014 Reagan Bay-window 12/10/2014 12/15/2014 Truman Side 12/20/2014 12/30/2014 Garfield Side 12/13/2014 12/15/2014 Arthur Ocean 12/24/2014 12/31/2014 Quincy Adams Bay-window 12/3/2014 12/6/2014 Johnson Ocean 12/5/2014 12/7/2014 Van Buren Bay-window 12/5/2014 12/7/2014 Madison Ocean 12/10/2014 12/14/2014 Roosevelt Ocean 12/5/2014 12/7/2014 Tyler Bay-window 12/20/2014 12/23/2014 Jack Ocean 12/10/2014 12/14/2014 Eisenhower Ocean 12/14/2014 12/16/2014 Grant Ocean 12/19/2014 12/21/2014 Jefferson Bay-window 12/24/2014 12/28/2014 Eisenhower Ocean 12/17/2014 12/20/2014 Adams Bay-window 12/3/2014 12/6/2014 Polk Side 12/24/2014 12/31/2014 McKinley Side 12/14/2014 12/17/2014 Washington Ocean 12/13/2014 12/16/2014 2 3 1 4 2 2 2 1 5 2 2 1 3 2 5 2 3 1 2 2 2 1 2 1 4 1 1 6 2 2 0 Daily Rate $150.00 $112.50 $150.00 $325.00 $300.00 $150.00 $292.50 $300.00 $320.00 $175.00 $250.00 $150.00 $112.50 $125.00 $198.00 $150.00 $250.00 $150.00 $275.00 $275.00 $150.00 50.00 $200.00 $200.00 $175.00 $200.00 $150.00 $148.50 $125.00 $325.00 $0.00