Design of Tables for Rosters

[stretch66]

Hi,

We currently have all our work rosters in Excel and are looking at the possibility of moving them over to Access but am really not sure how to start with the design of the tables.Have been looking everywhere but cannot really find anything that will help me get started. The over view is we are in a 24 hr operation with over 1000 employees that can be broken down into 25 departments. We have the following types of rosters (days) :

On Off Start Types
6 4 Early's & Lates
4 2 Early's & Lates
5 3 Early's & Lates
4 4 Day's & Nights
6 4 Early's, Lates & Nights

Within each department there teams so say Dept1 would have Team1, Team2 and Team3 on a 6&4 Early's to Late Roster with the teams starting on different dates and Team's 4 & 5 doing 4&4 Day's and Nights also starting on different dates as well as part-timers and adhoc staff doing their own individual roster.

How can these rosters be stored in a number of tables?

 

[Velosai]

Sounds a bit like a 3 way Many to Many relationship. The only way I can think of doing it is the following:


Team Table

Periods Table (as in a period is between Date A and Date B)

Rosters Table

Then you would have a table in the middle of them all, with each record storing a Team, Period and Roster ....Hope that helps. You can of course build on that to include Depts, Individuals, etc, but that 3 way "hub" would be the middle of the structure