Make-shift Work rota in Access

[jimmy2]

Here"s hoping i find you well guys!

RE: I have also posted this on mrexcel and excel forum

I intend to design a make-shift work rota with your wise guidance. a bit rusty in access but gradually finding my way!

Scenario:
I would like to design a work rota in which i eventually run reports to show what shift an individual is working. There is a fixed number of shifts and each shift also has a fixed number of individuals.

I currently have these tables

Name (ID, Individual)
Month (Day, shift1, shift2, shift3, shift4) x12(for all months)
Shift (ID, shiftName)
Rota (ID,Name_individual,Month_day, shift_shiftName)


My initial though was for every shift value in Month will refer to Rota that in turn shows the id"s of the individuals of the shift on that day. I had intially opted to remove the Shift table.
I am really open to constructive critism as i want to learn and understand this more.
I plan to add holidays but would like to understand how i can link and design the table structure initially

Thanks in advance

[Chezz]

Hello Jimmy, I'm new to the Access program...I'm a police officer attempting to create the same shift work database - please say you can help or maybe provide an example template v/r

[jimmy2]

Hello Jimmy, I'm new to the Access program...I'm a police officer attempting to create the same shift work database - please say you can help or maybe provide an example template v/r

Been a while and a bit rusty...what stage you on could try and help

[Chezz]

Well, I'm working from the floor up partner but anything that you have...would be great. Regardless, thanks for the reply

Hello Jimmy, I'm new to the Access program...I'm a police officer attempting to create the same shift work database - please say you can help or maybe provide an example template v/r

[ssanfu]

You might check out the data models at Data Base Answers
http://databaseanswers.com/data_models/index.htm

You might take a look at the upper right hand side of http://databaseanswers.com/data_mode...ters/index.htm

Also, be aware that "Name", "Day" and "Month" are reserved words and shouldn't be used as object names.
It is not good practice to have "ID" as a field name in every table. In queries and forms it is confusing...which ID field is being referred to?

Having repeating fields (shift1, shift2, shift3, shift4) is a sign of a non-normalized structure. It will cause you major headaches......