By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,890 Members | 1,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,890 IT Pros & Developers. It's quick & easy.

please help me -microsoft access help reqired

P: n/a
Hi i am doing a project for making a hotel management system in
Microsoft Access

I wantto make a hotel with 20 rooms
5 = suite
5= double
5= duobleo view
5 - rooms at single

4 types of room with 4 different prices
eg suite - 120
double 90-
double no view 70
single 50

it has a restaurant which serves 3 types of meals at 3 different
prices but guest can choose what meals they want

breakfast - 10
luch 12
dinner 14

i need to make sure there is information on bookings

list ofguests on each day

which rooms are occupied for the day or empty in the day

next weeks room availabilty

and a invoice for departing guest for both room and any meals they
have

please can anyone help as i am stuck on the tables required andthe
relationships and what queries are needed.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
do***********@yahoo.co.uk (donis) wrote in message news:<85**************************@posting.google. com>...
Hi i am doing a project for making a hotel management system in
Microsoft Access

I wantto make a hotel with 20 rooms
5 = suite
5= double
5= duobleo view
5 - rooms at single

4 types of room with 4 different prices
eg suite - 120
double 90-
double no view 70
single 50

it has a restaurant which serves 3 types of meals at 3 different
prices but guest can choose what meals they want

breakfast - 10
luch 12
dinner 14

i need to make sure there is information on bookings

list ofguests on each day

which rooms are occupied for the day or empty in the day

next weeks room availabilty

and a invoice for departing guest for both room and any meals they
have

please can anyone help as i am stuck on the tables required andthe
relationships and what queries are needed.


Whoa, wait a minute! This sounds an awful lot like a UML design class
I had!!! Sounds so much like a term project that it almost frightens
me. How are you supposed to learn if someone else does all the
thinking for you?
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.