A sample database for hotel reservation transactions developed in Microsoft Access is shown next, but the Web site may have a more recent version of this database for this exercise. Develop some reports that provide information to help management make the business more competitive and profitable. Your reports should answer the following questions:
- What is the average length of stay per room type? What is the average number of visitors per room type? What is the base income per room (i.e., length of visit multiplied by the daily rate) during a specified period of time? What is the strongest customer base?