If you are wanting to create a simple reservations database (such as hotel database), you will need to have a query to determine which rooms can be booked for a range of days, this is an example of a simple hotel database created in Microsoft Access
Studying an IT/Computing course and looking how to do a hotel database? A few years ago, i created such a system. Basically, its a relational database that uses forms, SQL and some visual basic. This was created for an AVCE ICT project, but it can easily be adapted/modified to suite your specification (it includes the [...]
A hotel reservation database that uses SQL to query rooms available and prevents double booking. Made using Microsoft Access, visual basic and SQL queries, you can check for room availablitiy, print reports, prevent double bookimg and has a simple to use GUI.
