Design to Create a Staff Work Schedule

  • Thread starter Thread starter JessiRight77
  • Start date Start date
J

JessiRight77

Hello. Does anyone know if Access can be used to create a rotating
work schedule for staff?

We want 3 teams, with 7 people on each team. Each person will work
standard hours (5 days on, then 2 days off), but their days will be
staggered so that staff will be here every day.

I have never seen a scheduling database in Access. Is this possible,
or would another software application be better?

Thanks,
Jessi
 
An addendum...

Well, I was confused... staff will NOT always work 5 days on, then 2
days off. There could be ANY combination of work days, as long as the
employee does not work more than 40 hours per week, and has *a*
Saturday and *a* Sunday off at least every 3 weeks.

Could Access help by automatically creating a work schedule for a table
of employees?

Thanks,
Jessi
 
When I worked at a major manufacturing facility I scheduled the entire
workforce using an Access database.
Every shift in every department.
This included 1,2,3 shift rotations as well as 7 day scheduling.

However, there is nothing "buiult-in" to Access to help you do this.
It required a lot of work to design and build that application.
But Access can do it with the right table design, queries, reports and code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for a Rotating Work Schedule? 2
How do I create staff scheduling in ACCESS 7
Recurring Appointment - 5 days on, 2 days off 2
count scheduled staff between hours 1
Work and staff schedule 1
Staff scheduling template in Access? 1
Appointment Scheduling 3
Adding up total hours worked on employee schedule using various criteria 0

Back
Top