471,062 Members | 1,963 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,062 software developers and data experts.

please help me -microsoft access help reqired

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
1 1261
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.

Similar topics

1 post views Thread by Numberwhun | last post: by
1 post views Thread by HolaGoogle | last post: by
4 posts views Thread by dave | last post: by
17 posts views Thread by Amy | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.