How can i do this ???

Hi, i have just started learning coldfusion and am extremely excited about the new possibilities data integration brings to a website!
My first project is to build a site for holiday villas which i would like to include a database for availability.
My initial idea was to build a database with 365 columns, one for each day of the year, then the availability checker would be a database query to see what values were in the columns (type thing!)
I would like to be able to add booking details to each date when they happen so as an administrator i can see whats happening on certain dates. Would this be a relational database, one for bookings and one for the dates?
Im using coldfusion on iis5 and microsoft access databases.
I have completed some tutorials and understand setting up the site with a remote folder and testing server and can set up data sources.

Can anyone help me figure out how to stucture the databases to handle this functionality, is the way im thinking somewhere right or is there a much better way??? Please help i cant wait to learn!

HI I AM DOING THE SAME PROJECT AS YOUR HOLIDAY VILLA ONES AND WOULD B REALLY GREATFUL IF YOU COULD PASS ON ANY ADVICE ON HOW U RECORDED YOUR BOOKINGS AND AVAILABILATY DATES!

(E-Mail address blocked: See forum rules)

Hi,

I think a better way of doing this would be have 2 tables where one would have fields like Day,Month,Year and BookingID and the other table would be for bookings which would have the booking details , then when the booking is made you would populate both the tables with respective data and when required create a join query & pull out the related records . Hope it helps !!!