I have been asked to devise a booking system in Access97, where 15 conference rooms can be booked. I am wondering how to go about this - what table structure etc I should be considering.
I would need to be able to uniquely identify each room. Be able to specify a date, start time and end time of the booking. Who the booking is assigned to would need to be included.
And probably the most interesting aspect - how to visually display the bookings. Something like the way Project displays jobs would be really good! ie, for each day, a line showing the currently booked periods...
Has anyone done this sort of thing before in access?
If you have any pointers to pass on would be good..
I have assigned 100 points, but will up them if someone can give me a pretty good explanation along the lines above.