Hi all,

I am an Access novice and need to create a database which will help me
assign rooms, with host families, to international exchange students. I also
need to be able to check availability of rooms etc. at any given date.

At the moment I have a table with Family ID, Name, Address, Number of Rooms
(typically 1,2 or 3 rooms per family).

When a student arrives I need to be able to assign him/her to an available
room (which then needs to be blocked out to avoid double booking) for the
duration of their stay.

I guess it would work something like a hotel booking system.

As I have mentioned, I am an Access novice and would like some clear
instructions/guidelines on what other Tables and Queries etc. I would need to
set up.

As a more advanced feature, would it be possible to assign available rooms
to groups of students, who all arrive as part of the same visit? (If this
part of my request becomes too complex I apologise and would be sincerely
grateful for just the answer to the first part of my issue). For example, if
I had a group of 12 students arriving from a particular country, could i set
up a Table containing their information and then cross-reference it to the
available rooms to block out those bookings?

I'm sorry if my question is a bit 'wordy' I'm finding it difficult to
explain in better terms.

I hope someone might be able to help.

Kind regards!