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

I still did not find a reason and a solution for this problem. Any ideas????