please help me -microsoft access help reqired

[donis]

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.

[Pieter Linden]

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?