Free Hotel Reservation Database & Prevent double booking using SQL
Posted in Database, Microsoft Access on January 24, 2006
Hotel reservation database. Uses SQL to query rooms available / room 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 was a project for my AVCE ICT Course (Unit 6) which I completed in 2006. For this project I achieved an A.
This hotel reservation 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 (SQL queries )
- 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!
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)
Download the Full Hotel Database (.zip) – FREE! sorry, but I can’t offer any support for it as I nolonger have enough free time.
Screenshots
[flickr-gallery mode="photoset" photoset="72157608790967813"]
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!
kindly pass the codes for these hotel reservation . thnx
I would like to buy the full version. Please email me and let me know the cost and where to paypal the amount.
I want to get the full version. What Do we need to do? How to pay for it?
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
Hello dear,
I am having great difficulty designing a hotel database for one of my courses. I have’t used Access much and am completely clueless.
Please, if you could send me how to design one or a copy of your template I appreaciate.
Thank you
The documentation in the ‘full’ version is what I produced for my A-level course work, which describes how I created the database…
Am working on a database for a summer bunkhouse, I am a true believer of not recreating the wheel. If the program is not working could you at least let me purchase the documentation that might help me save hours of work.
Thanks in advance
I would like to download database, I have one but I cannot dump the information or I wish I was able to use it from year to year as many of the attendees would transfer from year to year
please could you tell me how I can purchase the full version as soon as possible
Many thanks
Please could you tell me how I can purchase the full copy as soon as possible.
Thankyou
WOW amazing work !!!!! i was thinking of making a hotel reservation db like this bt the problem is i have to use oracle as a back end ….. does your project supports that ??? and please please can u snd me the database design PLEEEAAASSSEEEE
(((
sadly not, it uses access as a backend – you may be able to convert access databases to oracle database but that is a lot of work! (It may be better to build from scratch if you’re wanting to use oracle as backend!)
You are wonderful person. I just need the Idea of your work because my database if for another system, but you can modify as for Hotel’s. Now i know how to make look an hotel system because of your unselfish work. Thank you!
can I please have the source code?