Ask a new question

MS Access template for a guest house room booking system

Hi, is there an MS Access template for a guest house room booking system -

or, crucially, how to translate a booking of say from 5th to 9th March into a Form that meaningfully shows particular rooms are booked for each of these days such that double-booking is avoided?

Answer
Answer

Please am also looking for a MS Access Project for travel booking system that has the following features: 

• Have a user interface and menu system


• Book airline flights for customers


• Book hotels for customers


• Add new customers


• Have a range of reports that can be printed out


• Have a search option to find a specific flight or customer


• Show that flights are fully booked


• Show the hotels are fully booked


• Calculate the total cost of a booking for a flight or hotel

4 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer
You might like to take a look at Reservations.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to amend the form design accordingly.  

If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar.

This little demo file illustrates the basic methodology for a room reservations database.  In addition to showing room availability for any specified data range it also prevents double booking by omitting any rooms from the available list when a booking is entered if the range booked intersects with a range previously booked for the room.
_____________________
Ken Sheridan,
Newport, Shropshire, England

"Don't write it down until you understand it!" - Richard Feynman

19 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 1, 2024 Views 7,987 Applies to: