hotel reservation system database using Access
Posted in Uncategorized on June 29, 2008
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.
