Question Training Database

AGNewton5

Registered User.
Local time
Today, 00:32
Joined
Aug 20, 2019
Messages
28
I am very new to Access and am in the middle of trying to build a database to make my job a little easier. I have built the tables that I believe I need, but am having some logic issues in building the needed relationships to connect everything together. I need this database to have a few basic things and I am reading the Access 2016 Bible but am really struggling here. I have about 150 employees, of those employees I have several job positions. Each position has specific training that must be completed in order to be qualified. Some of the training is shared by many job positions. I think that I have a good beginning, but I could be wrong. If anyone could give me some pointers, I would appreciate it greatly.

Thanks in advance!
 

Attachments

I was thinking more along the lines of 1 table (not a dozen)for training type.

Operator
Material Handler
ILM Tech
Floater
Process Tech
PTT
Cleaner


each value in this list has training Reqmts.
PTT, Vol1
PTT, Vol2
Cleaner, Sec 1
Cleaner, Sec 3


all training together. Not separated into individual tables.
 
I am very new at this. If I were to have a Positions table that had all the various positions that I employ, how would I link the individual training classes to each specific position?

Thanks again
 
Any suggestions on this idea? I have about 150+ different training classes and 30-40 are shared between several positions, so any thoughts would be appreciated.

Thanks again
 

Attachments

  • ssdbidea.JPG
    ssdbidea.JPG
    99.6 KB · Views: 159
I agree with Ranman. There is something wrong in the design when you need multiple tables all with the same structure, just relating to different situations.

Can you clarify your requirements further. Can an employee act in more than one position type?

You wrote in #1 that each position has specific training. A cleaner might need training in work and safety, handling chemicals, health aspects. Do you want to record only that the overall training has been completed or record when individual competencies have been completed?
 
Employees can be qualified in more than one position and to be qualified they must complete between 20-45 different trainings. I want to document when the training is completed. I would also need each employee to be requalified after 5 years, or if the training is revised before the 5 year period.
 
Would this work better. I am really lost here and just want to make sure that I'm not wasting my time. I have the TrainingRevisionData table to allow me to update the TrainingData when necessary adjustments are made to our ever changing manufacturing environment. I am very new to this, but want to build this thing right and make my job a little easier than having to dig through paperwork every few weeks.

Thanks in advance!
 

Attachments

  • ssdb2.JPG
    ssdb2.JPG
    90.2 KB · Views: 145
You need to tell us the basics. Tell us how your business process works.

Put it another way, before you had MS Access, you probably used excel or paper, or most likely, a combination of the two. Explain how you worked with that.

You can't build a database to do something if you don't know how to do it already.

Sent from Barcelona!
 
Another thing you can do is draw a set of flowcharts, one flowchart for each process. Don't be tempted to do everything in one flow chart, use separate ones for each process and indicate where the next flowchart picks up from.

Draw.io is excellent, free and easy.
There are also other flowchart programs which can actually create your tables for you from the flowcharts I believe..

Sent from Barcelona!
 
Last edited:
I inherited a pretty archaic system of paperwork. The business has several positions (8), and about 140 different training courses. Each position can share several of the same training courses, but each position MUST complete the required courses before they are qualified to do the task. The training courses are revised when needed and the training courses must also be retaken after 5 years (refresh). I would like to be able to create a database that can maintain all the above things, as well as some forms that allow myself (maybe a secretary) to enter the training data into it. I would also like to have a few queries that can show me employees that are either not completed with the required training as well as employees that need refresh training. I have some other queries needs, but I can work on that stuff later. I have been reading some books when I have time, but my job is very demanding and this is a huge priority for my sanity so any help/ ideas would be greatly appreciated. My interest in learning about all things database is very high, and I am a fast learner in most things. Please let me know if anything I have here needs more clarification.


Thank you again!
 
From what I can glean from your requirements, the following table structure will cover everything except for training revision aspect which you can set aside for the moment until you get your head around how it works with joining tables (tblRequiredTraining and tblTrainingUndertaken).


tblEmployees
EmployeeID
LName
FName
PositionID
(other employee data - incorporate ShiftData, lose PositionData)


tblPostions
PositionID
Position

tblTrainingModules
TrainingModID
TrainingName

tblRequiredTraining
PositionTrainingID
TrainingID
PositionID

tblTrainingUndertaken
TrainingUndertakenID
TrainingModID
EmployeeID
DateCompleted
 
I had some time so I dusted off a sample I was working on. See if this makes sense to you.
attachment.php


The schema is slightly different from what was suggested. I also made it somewhat generic so it doesn't tie courses to positions when you add them. The assumption is that you might have courses that are general and everyone should take them or that some people might take a course before they officially were assigned the position. To overcome this, when a position is added to a person's record, the courses required by that position are added to that person's course list to ensure that you know what courses he needs to take.

I may do other work on this app to add a couple of reports and will post back if I get around to that.
 

Attachments

  • Training2.JPG
    Training2.JPG
    58 KB · Views: 212
  • Training.zip
    Training.zip
    101.4 KB · Views: 161

Users who are viewing this thread

Back
Top Bottom