Access Help!!!

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 breakfast's 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?

I need this database built. I'm pretty poor when it comes to Access.....

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 breakfast's 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? For example, would you add, modify, or delete discount packages? Why or why not?

Microsoft Access

Nº del proyecto: #947534

Sobre el proyecto