Employee/Supervisor Schedule Assignment

[Jrazkall]

Hello Access Experts,

I am seeking to create a database that matches an employee's schedule to a Supervisor's schedule. Basically the employee and the Supervisor need to have 10 hours in common to be matched. The file containing each scheduled information would be in a Excel or CSV file.

Any advice or help on how to achieve such a database would be excellent!

 

[Uncle Gizmo]

It seems likely that you are already performing this task manually, and there is your answer, use the manual system as the basis for creating the Computer system.

From your brief description I make the following assumptions:
1) There are several shifts, let's assume that there are three, A, B, C
2) each shift needs a supervisor,
3) each shift needs several employees, let's assume 30

So from these assumptions I would assign a supervisor to a shift, then I would assign employees to that same shift under that same supervisor.

Obviously my assumptions probably bear no resemblance to what is actually happening, but I hope you can see the general gist of it, you need to describe the real life situation before you can even contemplate building a database system, unless of course you are talking about a very simple system.

 

[Jrazkall]

Thanks for the clarification Uncle Gizmo. Your ideas are correct.

Currently the process is very manual and in an Excel spreadsheet that calculates the hours in common and then I manually assign the employee to the Supervisor who has the hours in common keeping in mind the number of FT employees on their team as well as number of overall employees.

Is it possible to create an Access Database that would be able to have:-Supervisors Schedules loaded (over 50 Supervisors)
-Employees schedules loaded (over 1700)
-Compare the two schedules to determine if there are a minimum number of hours (10 hours) in common
-Determine if the employee has been on the Supervisor's team for a set amount of time (1 year)
-Stop assigning Employees to a team after the set number of employees has been reached
-Somehow return a report that contains this information.

I am just looking for some sort of direction as to the possibilities of this and/or what direction I should head in to begin the process.