Table Structure for Training Matrix

[thmsjlmnt3953]

Hi,

I am starting out creating a training database to track training needs and expiring training etc.

I'm just looking for some tips as to how to structure the tables and relationships

I have an employee table, department table and training type table.

However im wondering how i can set up requirments and then match these to check if the person is trained up to date on all required skills?

 

[spikepl]

1. Prior to posting such a question you ought to have searched the site - 90 % of issues are not yours alone but have been tackled by others

2. See this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=241712 , and see jdraw's attachmnet in particular

Update: Now I recall that there exists an entire ready-made training database. That is one of the benefits of thorough searches.

 

[thmsjlmnt3953]

Hi,

I have searched however i cant find anything that matches what im looking to do. I already have a db set up on table level for most of what i want

tblemp
tbldepartments
tbltrainingtype (core, additional etc)
tbltrainingskills
tbltraining_records

im struggling now as i need to set up when i input an employee what training they require, then input training they have completed as and when then evaluate the 2 tables to see what is still required if anything?

 

[kenneth1975]

For a ready-made database, we found "Training Manager" from Kaizen Software. You can find it on Google if interested.

It sure beats a spreadsheet or trying to make one from scratch!

 

[jdraw]

Nice link Ken and they offer a free trial.

@thmsjlmnt3953,
Got to be worth the effort to download and get some appreciation of what a commercial product does, the kinds of tables, reports etc. Then see what you need that they don't have and support.