I gang

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?

Færdigheder: Microsoft Access

Se mere: average length stay per room type access, base income per room specified period time, access average stay, average length visit per room access report, additional charge per day guests staying, what is bookkeeping, what bookkeeping, web site strategies, type of accounting system, time management strategies, the atlantic, problems in accounting, popular 20 discount, manual bookkeeping, management accounting web, increase web visitors, increase web site visitors, income in accounting, hotel management couples, help write daily, daily finance, daily access, choice strategies, choice hotel, business owners database

Om arbejdsgiveren:
( 1 bedømmelse ) Fort McMurray, Canada

Projekt-ID: #947534

Tildelt til:

italinobz

Data Management experienced professional and experienced database programmer. Please see PMB for more details. You should not pay more than $100 for this work.

$50 USD in 0 dage
(2 bedømmelser)
1.8

8 freelancers are bidding on average $257 for this job

winghei

Hi, Please see my pm

$250 USD in 15 dage
(28 bedømmelser)
5.3
frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Looking forward to your prompt reply. Kindest regards. Farrukh R Mere

$250 USD in 3 dage
(14 bedømmelser)
4.4
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]

$540 USD in 30 dage
(3 bedømmelser)
4.1
eperfections

Please see PMB

$225 USD in 7 dage
(12 bedømmelser)
4.0
PerfectSquare

please see the PM

$210 USD in 3 dage
(11 bedømmelser)
3.2
jake8207

Hello, I'm ready to start developing right away. My price is for a full software solution and not just reports. I have experience in creating large scale access databases for businesses. Please see my personal message.

$250 USD in 14 dage
(0 bedømmelser)
3.1
kamran321

Sir, Plz see your pmb for more detail.

$280 USD in 15 dage
(0 bedømmelser)
0.0