Schedule?

[bdb25]

Hey there

I'm currently doing an ICT project for some school work, in which we all have to make access databases. My database is based around a fictional company that provide driving lessons. I've set most of the tables up including clients employees, bookings etc, but i'm wondering if its possible to implement a schedule within access?

I would like to know if its possible for say if someone booked 2 hours of lesson, 2 blocks within the schedule table would be filled, or similar to a calender function, e.g. each day has 6 openings within it, and as these become booked the next day is filled.

i've searched around a bit and can't really find anything but i'm very new to access so any advice would be much appreciated, or just being told that it isnt possible to implement such a schedule or calender would also be useful as then i wont be wasting time looking

Hope i've posted this in the right place, sorry if i haven't.

Thanks in advance.

Ben

Just found this website: http://www.aislebyaisle.com/access/calendartool.htm
kinda similar to what i'm looking to do, just wanna know if theres anyway of doing this thats less complex? or free?

 

[namliam]

Let me just say that (near) anything can be done in Access including what you want to do... You found yourself a good example, offcourse you can make things more simple.... or even more complex...

 

[bdb25]

Thanks for the reply namliam. its good to know it is possible, is there anyone who could point me in the right direction of how to implement something like this?

Thanks again

 

[The_Doc_Man]

Search this forum for "Bookings" and "Schedules" - the search function in the forum's menu bar works great! This topic has been handled many times before. You will find many threads showing the right (and the wrong) way to approach this class of problem.

 

[bdb25]

Hey thanks for your help so far, i did do some searching, and after finding different explanations and so on, i came across a pre-made calender. I've messed about and adapted it a bit, basically, theres a table with Dates and Information in, pretty straightforward the Information is displayed in the Date area of the calender, however, if two objects have the same date, only the most recent to be inputted is displayed, is there any wya of getting these to be listed one below the other?

I'll attach a copy of the file that i've been messing about with.

thanks again