The Presidents Inn is a three-story hotel on the Atlantic Ocean in Cape May, NJ, a popular Northeastern U.S. resort. Ten rooms overlook side streets, ten rooms have bay windows that offer limited views of the ocean, and the remaining ten 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 day. Guests staying for seven days or more receive a 10% discount on their daily room rates.
Business has grown steadily over the past ten years. Now totally renovated, the hotel uses a romantic weekend package to attract couples, a vacation package to attract young families, and a weekday discount package to attract business travelers. The owners currently use a manual reservation and bookkeeping system, which has caused many problems. Sometimes two families have been booked in the same room at the same time. Management does not have immediate data about the bed and breakfasts daily operations and income.

Use the information provided in this description and in the database tables on the Laudon Web site for Chapter 3 below to develop reports that would provide information to help management make the business more competitive and profitable. The database and related queries should be designed to make it easy to identify the information, such as the average length of stay per room type, the average number of visitors per room type, and the base income per room (i.e., length of visit multiplied by the daily rate) during a specified period of time.

After identifying the above information, write a brief report describing what your database information tells you about your current business situation. For example, what is your strongest customer base? What specific business strategies might you pursue to increase room occupancy and revenue?

Tags: access database withadonet web services samples, business, create access tables, create access tables xml, creating access tables, extract ole object access tables, guests, information, newsagent delivery access tables, package, per, project description provided detail enough, room, rooms, script access tables, send access html report web, update access tables script