create a schedule for 50 teachers

[adam480]

I am new to access and have little to no existing training. My question is; is it possible to use access to create a weekly schedule for 50 teachers who teach approximately 7 classes mon-fri, where classes will be of a different type? our current method is extremely tedious and old fashioned. I hope there is a way that access can generate this schedule more efficiently.

Thanks for any help.

 

[CJ_London]

it is certainly possible - how you achieve it depends on what type of schedule - is it the same every week? i.e. based on Mon, Tue, Wed etc? or based on the actual date? - i.e. you want to set the schedule for a whole term or year?

In principle you would have 4 tables, one each for teachers, subjects and your 'day' structure. (You might also have another table for room or location). and a final one to relate them all together - 'this' teacher, teaching 'that' subject on 'this' day in 'that' room.

class scheduling is a common subject, you should be able to find some examples or templates on this forum or elsewhere - take a look at the bottom of this thread as a starting point



e.g.

 

[JLCantara]

CJ forgot one possibility: a 6 day schedule, to avoid the same class falling on holidays...
I have made an app for a college here (30+ years ago on a HP250) and it is very tricky: one must constantly check for possible conflicts with already assigned records.