Tagged: hotel database RSS

  • alex 7:32 pm on June 29, 2008 Permalink | Reply
    Tags: access 2000, access 2002, , code checks, database, double booking, hotel database, hotel reservatation system, , , relational database, , , sql code, system database, technical documentation   

    hotel reservation system database using Access 

    Studying an IT/Computing course and looking how to do a hotel database?

    A few years ago, 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 easily be adapted/modified to suite your specification (it includes the technical documentation).

    The hotel reservation system was created using Microsoft Access 2002, but it can be opened in Access 2000, as well as Access 2002/XP,2003, and 2007. The SQL code checks room availability by queering which rooms are not booked – thus preventing double booking.

    More information on the hotel reservation system

     

  • alex 2:05 am on January 24, 2006 Permalink | Reply
    Tags: , database system, database template, hotel booking database, hotel database, , hotel reservation system, , , query rooms available,   

    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)

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

     

    • 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

c
compose new post
j
next post/next comment
k
previous post/previous comment
r
reply
e
edit
o
show/hide comments
t
go to top
l
go to login
h
show/hide help
esc
cancel