I would like to create a database to schedule 20 workers for two shift daily Monday-Friday on a monthly bases and output to the calendar, considering US holidays as none working days, which should be an option to enter in the database. Also some of the workers are not working on Mondays and some are not working on Fridays (Also to be option to enter), Vacation and sick time to be entered as well, so workers can be excluded to be scheduled on those days. And finally each worker to have preference of the shift.
I need help on the approach to this project.
Thanks in advance
I need help on the approach to this project.
Thanks in advance