Question Meeting room booking database

[p2theb]

Hi,

I am trying to set up a database that allows a receptionist to book meeting rooms for staff in the office. I have created a table for the rooms and a table for the bookings (with a relationship so the rooms lookup) and in the table for bookings the date and timing is also chosen.

The problem is that I am fast reaching the extent on my knowledge. I want the bookings form to lookup the avaliability of the room for the date and time chosen, and also I want to display the bookings like a calendar for refrence and printing each week, months booking.

I'm sorry if this is too much to ask for help on but I am hoping I can learn from stuggling through this project.

Thanks for any help,

Peter

PS: Does it help if I post what I have done so far?

 

[GaryPanic]

Peter - if you post what you have done so far - this will show those on the site your train of thought and also whether this is a school/college project or real life

cos in real life - you would use Outlook for this type of thing

 

[p2theb]

Hi,

I have uploaded the database.
This is real life but I do not want to use Outlook - it is just for booking the meeting room not the participants and as we are a small office block in a huge organisation it is easier to use Access.

Many Thanks,

 

[p2theb]

Hi,

Is there anyone who can help with this?

 

[wazz]

i'm not familiar with these myself but maybe they'll help with some ideas. also be sure to search the forums as others have had questions about this type of thing.

http://office.microsoft.com/en-gb/templates/TC010184071033.aspx?pid=CT101426031033

http://office.microsoft.com/en-gb/templates/TC011801461033.aspx?pid=CT101426031033