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

please help asap and show step by step

Stouerreisk Leam Mere Neservation: Reservition \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & 1. - Guent Fust Iiam : & Guest Last Nan . & Room & Room Typ: & Anival Da . & Departure Da - & No di Gues. - & Daly Ral - & Click to Add \\ \hline & 7) Bairy & Liond & Hayes & Bay-window & 121/2015 & 12/4/2015 & 2 & $150.00 & \\ \hline & 2 Michael & Lunstord & Cleveland & Ocean & 12/12015 & 12/9/2015 & 3 & $11250 & \\ \hline & 3Km & Kyuong & Coolidge & Bay-window & 12/4/2015 & 12/2015 & i & $15000 & \\ \hline & 4 Edward & Hot & Wastington & Ocean & 1211/2015 & 12/3/2015 & 4 & $32500 & \\ \hline & 5 Thomas & Colins: & Lincoln & Ocean & 129/2015 & 12/132015 & 2 & $300.00 & \\ \hline & 6 Pad & Bodkn & Cooldge & Bay-window & 12/1/2015 & 12/3/2015 & 2 & $150.00 & \\ \hline & 7 Ranidal & Bactenburg & Washington & Ocean & 12/4/2015 & 12/12/2015 & 2 & $29250 & \\ \hline & 8 Catvin & Nowotney & Uncoln & Ocean & 12/2/2015 & 12/4/2015 & 1 & $30000 & \\ \hline & 9 Homer & Ganzalez & Lncoln & Ocean & 12/5/2015 & 127/2015 & 5 & 5$32000 & \\ \hline & 10 Dand & Sanchex & Jetterson & Gizy window. & 12/5/2015 & 12/7/2015 & 2 & $175,00 & \\ \hline & 11 Buster & Whisler & Jackson & Ocean & 1255/2015 & 128/2015 & 2 & $25000 & \\ \hline & 12 Jula & Martines & Reagan & Bay-window & 12/10/2015 & 12/15/2016 & 1 & $15000 & \\ \hline & 13 Samued & Kim & Truman. & Side & 12/2012015 & 12302015 & 3 & $11250 & \\ \hline & 14. Nthus & Gottined & Garlied & Side & 12/3/2015 & 12/15/2015 & 2 & $12500 & \\ \hline & 15 Darlene & Shore & Avthur & Ocean & 12/24/2015 & 12/31/2015 & 5 & 519800 & \\ \hline & 16 Carbe & Charkeston & Quncy Adams & t Bsy-window & 12/3/2015 & 12/6/2015 & 2 & 315000 & \\ \hline & 17. Abent & Goldstone & Johrison & Ocean & 12/5/2015 & 12/7/2015 & 3 & $25000 & \\ \hline & 18 Charlene & Tilson & Van Buren & Bay-Window & 12/5/2015 & 12/7/2015 & 1 & $15000 & \\ \hline & 19 Everett & Chad & Madison & Ocean & 12/10/2015 & 12/14/2015 & 2 & 2$275.00 & \\ \hline & 20 Gerald & Petsfield & Rooseveit & Ocean & 12/5/2015 & 12/72015 & 2 & 2$27500 & \\ \hline & 21 Jamal & Smeh & Tyler & Bay-window & 12/20/2015 & 12/23/2015 & 2 & $15000 & \\ \hline & 22 Louis & Pans & Jackison & Ocean & 12/10/2015 & 12/14/2015 & 1 & $25000 & \\ \hline & 23 Negel. & Stratford & Eisenhower & Ocean & 12/14/2015 & 12/16/2015 & 2 & $20000 & \\ \hline & 24 Peter & Wilington & Grant & Ocean & 12/192015 & 12/21/2015 & 1 & $200.00 & \\ \hline & 25 Ronald & Cartier & Jeflerson & Elay window & 12/24/2015 & 12/292015 & 4 & $17500 & \\ \hline & 26 Trusta & Leven & Eiserhower & Ocean & 12/17/2015 & 12/202015 & i & $200.00 & \\ \hline & 27 Valene & Snel & Adams & Bay-window & 12/32015 & 120/2015 & 1 & $15000 & \\ \hline & 28 Waller & Acton & Polk & Side & 12242015 & 1231/2015 & 6 & 514050 & \\ \hline & 20 Xaver & Trezza & Mckoniey & Side & 12/4/2015 & 12/17/2015 & 2 & $12500 & \\ \hline & 30 Zachary & Miter. & Wastingtion & Ocean & 12/132015 & 12/6i2015 & 3 & $32500 & \\ \hline * & - (m) & & & & & & 0 & $0.00 & \\ \hline \end{tabular}