MS Access: Hotel Reservation Database & Prevent double booking using SQL
Hotel Reservation Database
a simple hotel reservation database. Uses SQL to query rooms available (availability) & prevents double booking)
normalized to the third normal form. Hotel Reservation (booking)
Database system made in using some basic SQL and Visual Basic (VB).
This hotelreservation database could be useful for anyone studying an ICT course such as
- AVCE ICT
- A Level, A/S Level
- BTEC etc
- or anyone wanting to produce a hotel reservation database.
This database is a working example of a simple hotel reservation system and was made
using Microsoft Access. A relational database and sql for some of the queries. It
can used as a Hotel Database template, and easily be modified.
Originally, this was created for my AVCE ICT Unit 6 Database
coursework and the documentation for that is included.
Some of the Hotel Reservation Database features:
- Check for room availability for a range of days (uses SQL )
- Create, Edit & Delete Bookings / Customer / Card Details
- Print various reports for cleaners
- Prevent double booking
- Prevent rooms being booked when it is closed (if required)
- Graphical User Interface (GUI)
The Full version consists of the database file (.mdb), the original technical documentation produced for the AVCE ICT coursework.
This database can be adapted to suit your needs,you cannot however re-distribute (free or otherwise) it without my permission! IT /ICT students Please do not hand it in as if it was your own – it’s cheating!
why does it cost? i believe the price is reasonable to minimize advertising! the payment just goes towards the web hosting of this site – bandwidth costs! if you prefer to send a different amount or don’t want to use PayPal please contact me
Download the Hotel Database
Download Demo
The Demo (free version) is just a demonstration of what the database can do. There
is no access to the design view of the database, and cannot be edited. This is in an .mde
file, and requires Microsoft Access 2003
Download hotel database demo (.zip) – 1.4MB
Download Hotel Database (Full)
If you wish to purchase the full version please e-mail: order_database@digiwebbs.com
(i’ve taken down the shop for the time being till I can get the system working again!)
Rissah, 
Sarah and 5 others are discussing.
Tom 5:51 pm on December 27, 2008 Permalink
Could you send me an email with your full contact information so that I may get in touch with you? We are looking to gain access to a complete hotel database that contains both domestic and international hotels.
Thanks!
Joe 5:06 am on June 2, 2009 Permalink
I would like to buy the full version. Please email me and let me know the cost and where to paypal the amount.
Juan Valdez 10:03 pm on June 27, 2009 Permalink
I want to get the full version. What Do we need to do? How to pay for it?
admin 4:46 pm on June 28, 2009 Permalink
Hi Juan, You can download the full version of the database using the link at the bottom of the page, but please use a valid email because it gets sent to that address
cheers,
Alex
k.lesle@yahoo.com 2:17 pm on July 14, 2009 Permalink
I am a student.I am assigned to create a database for the hotel reservation system.
rotem 11:04 pm on August 14, 2009 Permalink
Hi,
I want to get the full version, and my paypal is not confirm yet,
I will thank you for help me ,
regards,
rotem.
admin 8:39 pm on August 15, 2009 Permalink
Hi there, PayPal should work fine but if you have any problems send me an e-mail
Cheers, Alex
Sarah 4:17 pm on September 3, 2009 Permalink
I just purchased the full version and did not get instructions on downloading.
Rissah 2:37 pm on September 9, 2009 Permalink
Dear alex,
I have purchase the database and it says that they will send me a link to download it. But I have been waiting and still did not get anything. Could you check this please since there is an urgency for me to use it.
Thank you!
admin 3:36 pm on September 9, 2009 Permalink
Hi Rissah,
the web server is currently experienceing issues sending emails at the moment, which i hope to resolve a.s.a.p, but i’ve emailed you your login details.
Cheers,
Alex