How can I produce a booking system or a form that displayed the availability of each room for a hotel?

Question

If I created an Excel spreadsheet. Would I just input each date across the top & each room down the side? Also, what is the difference between excel & access?

Answer 1

That depends on where your data is coming from.

The simplest way would be to create an Excel spreadsheet that would list each room. The hotel employees would then fill in the spreadsheet if the room was booked, and clear the cell if it became available.

Answer 2

You'll need to connect your existing booking system to the internet, add interaction to your website with ASP.NET, ColdFusion, or another brand of software, work out some procedures, possibly remodel your database to accommodate the new procedures, and resolve some security issues. This isn't a DIY job. It should take an experienced programmer about two weeks.
On the other hand, if it's a new system, only intended for use by the front desk, and not integrated with a billing or other systems, you could whip something up in MS Access in a day or two.

Answer 3

Use Excel to create a table with a column for the rooms, a column for the availability, and rows depending on how many rooms are there. Print it out or save before doing that, for later use, if you have a computer.

Answer 4

I think MS Access would be perfect, since you probably could set a reverse-query type of protocal to minimize keystrokes for updating data.

Answer 5

www.expedia.com