Heritage Album

How do I create a hotel booking system in Microsoft Excel?

Ok, my family own these units, and we are using old school booking books to record the bookings. We only have 3 units and already have a computerized invoicing program, but I really want to create something in Excel that does the same as our booking book. I need to include the dates of the booking, the person's name, the price that we are charging them, the number of people, where we got the booking from (roamfree, our local visitors centre etc.) and whether they are staying in a 2 bedroom or studio apartment. It would be great if you gave me some ideas!! Thanks a heap! ok thanks, so is access easy to adapt to?

Public Comments

1. For this sort of thing you should be really using Microsoft Access instead of Microsoft Excel. Excel isn't really a database program for storing this kind of information, but this is exactly the sort of thing that Access is designed to do. Access also has a booking system template that you can adapt to help you get started.