To create a organization specific database it advised that the person who is trying to create it should look for all the important aspects related to it.Constructing a hotel room booking scenario is a bit easier one should look after following aspects :

  1. Customers
  2. Guests
  3. Rooms
  4. Bookings
  5. Payments
  6. Room Types
  7. Price Bands
  8. Room Facilities

Here  is a complete tutorial available in pdf
Here is a ebook in pdf format that will help you understand how to create a perfect dbase for your hotel or motel. You will be able to customize things according to your need. It is always better to understand things instead of copying them but only if you have enough time, in this book you will learn how to set up a dbase transform the data model into a database in MS-access along with using the lookup fields to input foreign keys and other enumeration types.Every point is illustrated in this file along with Shortcut keys for data entry,creating more tables,relationship building,dealing with trees and networks. Adding forms and other access based user interfaces,how to use fields,adjusting controls etc. All in all the perfect set of tutorial that you will ever need for constructing your own hotel dbase.

Tutorial hotel ms access

If nothing works and you need a software in hurry here is the solution

Here is the software : for free hotel reservation system created in Visual Basic, its basic feature includes Guest reservation,billing,changing room,multiple account per room comes quite handy sometimes,guest report and other fines.
It is a exe file and one should scan it carefully before using it and also don’t ever run complied files. Run only source code.


If you want to have a look at sample dbase for reservation here is a example from where you can download it though it is not a full solution but you can understand things,as these downloads are from third party we do not guarantee safety. Make sure you run a virus check and use precautions.Sample dbase exe are available for Access 2013 32bit,64 2010 (32 and 64 bit),2007

Download the stuff here