Help with creating a training tracker database.

[lewis1682]

Hi all,



It's been a while since I last created a Access DB, so I am a little rusty. My current project is to create a training tracker DB for some volunteers (workers). I have already created the following tables:

tbl_workers:
ID (PK)
txt_name
txt_units
txt_course

tbl_Units:
unit_ID (PK)
txt_unitName
txt_desc

tbl_course:
course_ID (PK)
txt_courseName
txt_courseUnits
txt_desc

What I am trying to achieve is to be able to assign a list of unit codes to a course, once a worker has completed all the units associated with that course they will have that course be assigned to their profile with their completion date. I am very stuck when it comes to being able to create the correct queries and relationships to make this work. Also the end user should be able to create the courses and assign the units needed to pass.

Any help is appreciated.

Thanks.

Using Windows 10, Access 2016

[ranman256]

Workers table would not have Units. Only Worker info.
You need a worker unit taken.
tWorkerUnits table:
workerID
unitID
DateTaken
Complete

you should t need course on the worker. the workerunits can roll up a course on the tCourse table.

[ssanfu]

Also the end user should be able to create the courses and assign the units needed to pass.

Would you describe the relationship between courses and units? And maybe some examples?