Creating a Hotel Booking System for College

[Chris_A1]

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.

[KnooKie]

couple of things spring to mind. If you include the RoomID in the Bookings table and make it part of the primary key then.....

Each time someone wants to book a room you just have to check in the bookings table for a certain roomID and the corresponding dates to see if there is a clash i.e. it is/not available.

Have a look at the DatePart function in thehelp file for isolating a specific day from a date.

So, 1 to many > Rooms to Bookings