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?

Færdigheder: Microsoft Access

Se mere: access average stay, what bookkeeping, web site strategies, type accounting system, time management strategies, the atlantic, problems accounting, popular discount, manual bookkeeping, management accounting web, increase web visitors, increase web site visitors, income accounting, hotel management couples, help write daily, daily finance, daily access, choice strategies, choice hotel, business owners database, business accounting system, bookkeeping information, accounting related data base, access information management, type story

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 freelancere byder i gennemsnit $257 for dette 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 B.Raghunath

$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