Table design with time

[Andrew Smith]

Hey, I am new to databasing and I'm trying to design a database for a friend
of the family. He owns a small bed and breakfast and right now his whole
business is on paper. I told him that I would help him put it on the
computer. I have a good idea of what I want on the table, for example: Room
identification, etc. But I do not know how to incorporate the date. For
example, if someone wants to reserve Room A on December 12th. I don't know
how to put the date in the table. Each room needs its own calendar. Can
someone help point me in the right direction with this? Your help will be
very appreciated. Thanks

Andrew Smith

 

[John Vinson]

But I do not know how to incorporate the date. For
example, if someone wants to reserve Room A on December 12th. I don't know
how to put the date in the table.

There's a Date/Time datatype you can choose for a field. I'd suggest
having two Date/Time fields, StartDate and EndDate.

Room reservation systems are pretty common, and not trivial to
implement well; you may want to run a search of these newsgroups on
http://groups.google.com to find previous discussions of the issue.

 

[TC]

Understand that there will be a bit more to this than just "putting it on
the computer"!

For a start, you will need to learn about database design - a whole topic of
its own. Perhaps start here:
http://support.microsoft.com/support/kb/articles/Q100139.ASP

The exact issue of room reservation systems was discussed by me & others, a
few weeks ago. Do some googling, you should be able to find it.

HTH,
TC