Hello all and thank you in advance,
I usually try to stick to excel although I have worked with access before on simple projects. I came upon a business problem that I could not solve easily with excel so I thought I would have a go with access.
I am laying out the basic scenario for a training management database and could use some input for not only what's possible but also best practice. I thought I was doing okay until my relationships ended up in a big circle.
As a basic summary:
All active employees need training:
Each employee belongs to one department
Each employee could have multiple job titles
Each job title could have multiple employees
Training Material is assigned by job title:
Each training material could be assigned to multiple job titles
Each job title could have multiple training materials
The thought was to create a record for each training completion and then also be able to report on what has not been completed through a query.
Perhaps the record does not need the direct relationships...
I am open to any thoughts because I fear I have overcomplicated this. If there is any other info I can provide please let me know.
best regards,
Matthew McKenna