How Do I Create a Database to Track Reservations?

[rogern]

I'm trying to create a cabin rental reservation system in Access. I'm not sure how to keep track of dates reserved and dates available for each rental unit. There are only four rental units and availability dates start on Memorial Day and end on Labor Day. So far I have identified a need for at least 3 tables: Reservation, Guest, Unit. Do I need to create a table that contains all available dates for each rental? If so, how do I easily populate that table? How could I generate a report of available dates by unit? I would appreciate any hints or tips on how I could implement this rental tracking system.

Thanks

 

[jebry]

Hi!

Access comes with several sample Db's which you can use. One is a resource tracker which you can probably modify to your needs.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[Junior1544]

Let me think here...

AHH, I smell smoke!!!

ok, all joking aside...

I would suggest with what you have said so far, add two fields to your unit table. Both of which will be date fields. One is the available startdate, and the other the end date...(just keep in mind, that these will need to be updated every year.)

then, when some one tries to make a reservation, first check to make sure the dates the people want, are between those dates, then check to make sure that no one else is in the unit at that time...(this would be by making a query of the guests table to show the dates they want and unit's... so it will show any unit not being used on the dates...)

Just some thoughts for you.

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.