How to query a reservation database for room availability using Microsoft Access & SQL
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)
Lauren, 
Massimo are discussing.
Massimo 10:36 am on November 30, 2008 Permalink
Hi, I would like to know something more about the hotel database in acces, do u have a demo online? Or maybe an email where I can contact you?
Thank you,
bye
Alex 10:42 am on November 30, 2008 Permalink
Hi there, yes theres a demo on http://www.digiwebbs.com/2006/access-reservation-booking-hotel-sql-database-prevent-double-booking-check-room-availability/ although, you’ll need Access 2003 to view it. hope this helps
Lauren 2:00 pm on January 9, 2009 Permalink
Hi I have been trying to get a database for a resort, nothing fancy but I am failing to do this. I really need some help.