How to query a reservation database for room availability using Microsoft Access & SQL
Posted in Database, Microsoft Access on July 19, 2008
How to Query a Reservation Database (by Date) for Room Availability Microsoft Access & SQL
keywords:
- Query room availablity
- Hotel Reservation Database
- Microsoft Access
- check room availablity
- SQL
- How to query a reservation database
- Prevent Double booking
Studying an IT/Computing course and looking how to do a hotel database?
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 and prevent double booking…
A few years ago, for my AVCE 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 be adapted/modified to suite your specification (it includes the technical documentation).
The hotel reservation system was created using Microsoft Access 2002, but it also works in Microsoft Access 2000, as well as Access 2002/XP,2003, and 2007.
The SQL quey checks room availability by seeing which rooms are booked and inversing it thereby showing which rooms are available
read more on Hotel Reservation Database created in Microsoft Access (can also download a template and view a demo)
