How to create a hotel availability by using MS access as DB

Question

I am facing the Problem to create an availability checking to a few of hotel and my main problem was date things because if I created a database and how to track the room available in particular date which can be in the range.

Answer 1

In DB Column, You may have a column to specify the Room is booked on that date or not ?. For a range of dates, use between statement in sql.  If the rooms are booked between the date range, then do your action.