For my college project I am attempting to create a reservation system (in Access) which could be used in a hotel for booking rooms.

I have so far created the following tables:

Bookings:
BookingID
CustomerID
ArrivalDate
DepartureDate
RoomReserved
etc

Customers:
CustomerID
Surname
Address
etc

Rooms:
RoomID
RoomName

I have had no trouble creating the form/subform for entering the customer and booking information.

However, I am really struggling to find a way of stopping rooms from being double booked, or for being able to find vacant rooms on a specific day.

Does anyone know how I could go about doing this?

Thanks very much.