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.

Sundar · Answer

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.