hotel reservation system database using Access
Categories: Database, Microsoft 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
Link to this post!
Is there any chance that you could mail the acces database to me? it looks like it was what i was looking for, but for some reason the link doesn’t work.
I could really use it as an example for a school project iam currently working on.
Evert
Hi Evert, the download link should work – please let me know if you’re still having problems.