Free Hotel Reservation Database & Prevent double booking using simple SQL

Hotel reservation database. Uses SQL to query rooms available / room availability & prevents double booking

Background: Created in Microsoft Access this is a relational database
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

  • 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) – 3.6MB

Download Hotel Database (Full)

Download the Full Hotel Database (.zip) – FREE! sorry, but I can’t offer any support for it as I no-longer have enough free time.


[flickr-gallery mode=”photoset” photoset=”72157608790967813″]

If you can’t see the images in the gallery above, please see:

, , , , ,

25 Responses to Free Hotel Reservation Database & Prevent double booking using simple SQL

  1. Tom December 27, 2008 at 5:51 pm #

    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.

    • che October 7, 2010 at 12:42 pm #

      kindly pass the codes for these hotel reservation . thnx

  2. Joe June 2, 2009 at 5:06 am #

    I would like to buy the full version. Please email me and let me know the cost and where to paypal the amount.

  3. Juan Valdez June 27, 2009 at 10:03 pm #

    I want to get the full version. What Do we need to do? How to pay for it?

    • admin June 28, 2009 at 4:46 pm #

      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



  4. Tatiana Soares July 20, 2010 at 2:54 am #

    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

    • alex August 20, 2010 at 8:01 am #

      The documentation in the ‘full’ version is what I produced for my A-level course work, which describes how I created the database…

      • Debra November 5, 2010 at 3:52 am #

        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

  5. james robinson August 13, 2010 at 3:40 am #

    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

  6. najaf sadiq August 24, 2010 at 10:23 pm #

    please could you tell me how I can purchase the full version as soon as possible
    Many thanks

  7. najaf sadiq August 24, 2010 at 10:24 pm #

    Please could you tell me how I can purchase the full copy as soon as possible.

  8. natalie November 8, 2010 at 10:06 pm #

    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 :((((

    • alex November 23, 2010 at 4:22 pm #

      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!)

  9. Speed January 4, 2012 at 1:55 pm #

    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!

  10. McNeal January 24, 2012 at 1:26 pm #

    can I please have the source code?

    • Alex Cooper April 19, 2012 at 10:15 am #

      Hi McNeal, Yes! :-) I’ve fixed the download link

  11. Marthissa May 11, 2012 at 12:05 pm #

    Hey! I am working on an assignment and would need the source codes, as I use a Mac, I cannot open it..

  12. sharon May 17, 2012 at 1:07 pm #

    pls i am doing a project on hotel booking using microsoft access, I need the query codings on how to show that a room is available or not at a particular time.

  13. William Hall October 11, 2012 at 9:23 am #

    I am also work in hotel reservation database using Access. Thanks for giving me the information.

  14. student31296 November 29, 2012 at 2:43 am #

    Hi. So we were tasked to make a laboratory reservation system (using Access Database and Visual Basic) for our project. I have two problems:
    1. We’re supposed to include the classes that are scheduled in each laboratory in our database. How do we make the class schedules repeat for each week?
    2. How do we avoid data redundancy? Like in situations where a user would make a reservation on a particular date and a particular laboratory room where there are classes already scheduled in it. How do we warn the user that that particular date and room is not available?
    We REALLY need your help. thankyou. :)

  15. Paul December 11, 2012 at 3:10 pm #

    Hi, i am working on a task about hotel databases and I would appreciate if i could get the full version as the link on the page would only give me a view-only version and cannot add or delete any records


  16. monica April 8, 2013 at 2:52 am #

    HI, thank you very much for sharing this! As a spanish speaker with english skills and always trying to selfteaching a bunch of different things, I’m trying to translate the db into spanish. It worked ok until i found an error on the “Booking” table, datasheet view, “bookingID” column; when i click on the “+” symbol at the left. It says that there is a lost registry… thnx

  17. Nisha August 1, 2013 at 9:20 am #

    Hi Alex,

    Thanks for the database, for i do not know about much creating hotel system and the components included!. :)

  18. Peter Jones December 23, 2013 at 8:17 pm #

    Can I get a full working version and how can I pay for it. I would like to help a lady who is running a small resort (6 apartments) in Port Vila Vanuatu. Her husband died a few months ago and she is struggling to complete the building of the resort and open up for business. She need a Hotel Booking system which is basic and not to expensive. I think your program is just what she needs.

    Thank you

    Peter Jones

Leave a Reply