The purpose of this report is to analyze the Queen’s Inn current reservation system and propose a recommendation for management to move towards an automated system that will increase profit, transparency to management on daily operation and to introduce a solid tracking system of their customers promoting efficiency and accuracy by using Microsoft Access.
As a result of utilizing automated advanced database entry system like Microsoft Access, users will be able to generate queries and reports based on their own desires without going through circles or complex steps. Using a database querying system, anyone in management of Queen’s Inn will be able to find out how the business is doing on a daily basis, how many rooms…show more content… It shows every room category in the Inn is always booked, even with the more expensive ones - the Ocean and Bay-window rooms.
According to the query using MS Access, on average Queens Inn accommodates from 2 to 4 visitors a day. It seems that major percentage their visitors favors the Ocean rooms. It shows that visitors love to stay in the Ocean rooms because it offers the full view of the ocean, as opposed to the Bay-Window rooms which have limited view, and the Side rooms view doesn’t show much of the ocean. The report clearly shows that that visitors are willing to pay for more for the Ocean rooms.
Query | Room Type | Arrival Date | Departure Date | Sum Of No of Guests | Avg Of No of Guests | Min Of No of Guests | Avg Of Daily Rate | Min Of Daily Rate | Bay-window | 2004-12-01 | 2004-12-03 | 2 | 2 | 2 | $150.00 | $150.00 | Bay-window | 2004-12-01 | 2004-12-04 | 2 | 2 | 2 | $150.00 | $150.00 | Bay-window | 2004-12-03 | 2004-12-06 | 3 | 1.5 | 1 | $150.00 | $150.00 | Bay-window | 2004-12-04 | 2004-12-07 | 1 | 1 | 1 | $150.00 | $150.00 | Bay-window | 2004-12-05 | 2004-12-07 | 3 | 1.5 | 1 | $162.50 | $150.00 | Bay-window | 2004-12-10 | 2004-12-15 | 1 | 1 | 1 | $150.00 | $150.00 | Bay-window | 2004-12-20 | 2004-12-23 | 2 | 2 | 2 | $150.00 | $150.00 | Bay-window | 2004-12-24 | 2004-12-28 | 4 | 4 | 4 |