Need help tracking training for my business

B

brianusn

#1
Hello all,
My company that I just started working for uses an Access program to track all the different training for each individual employee.(OSHA, NAVSEA, NASSCO) Basically things like first aid, confined space, Fork lift, etc. They have the individuals name and the date that he had the training. The thing is, with all the requirements(yearly, quarterly, etc.) the DB doesn't show the expiration date to get these guys re-certified. We only have about 25 employees and I didn't want to go spend a thousand bucks on some software that I didn't need all the bells and whistles. I was wondering if any of you have an excel or DB that I can use that is simple to configure. I can just add the individuals name, the date he completed the training and when I enter that in, it automatically can calculate the expiration date so we can prepare to get him re-certified. I would greatly appreciate it. Thanks for your time and help.
 
Elsmar Forum Sponsor
K

kgott

#2
A 25 person does not need a training software. Perhaps you can learn MS Access make use of its capabilities to work with what you have or you can use a spread sheet.

In a spread sheet, list names down the left hand side and the training topics along the top from left to right. Enter in dates when competences or training expires where the name and competency meet and enter in the expiry date.

Go and talk to the people concerned to find out what training they have and when and enter it in the spreadsheet.

Entering the expiry or renewal date can be the best way to go as its apparent at a glance when it has to be done again. Some people choose to use the date when the competency was gained and by using conditional formatting, the cell changes colour when it due for renewal.

Sometimes, keeping it simple is best.
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#3
Welcome to the Cove!

Your training could be tracked using a matrix that lists names on the Y axis and training needs on the X axis. Due dates can be written in the blocks, which can be colored or shaded in when the training is completed. The matrix can be on Excel, or on a piece of paper. It does not need to be awfully complex.

If you want to show 2-stage learning (review process/take class, then do OJT for final signoff) you can color the cell diagonally for one, then completely when both stages are done.

Competency recording is another matter. I would keep notes, OJT booklets and/or test results for competency recording. I would additionally find a way to record the employee affirming he/she feels ready to perform the task without direct supervision.
 
Thread starter Similar threads Forum Replies Date
L Developing an Access ECO Tracking Database - Need help Document Control Systems, Procedures, Forms and Templates 8
K Need help in Setting up a Process for Tracking RMAs with Traceability Manufacturing and Related Processes 11
C Need help to create tracking tool Excel .xls Spreadsheet Templates and Tools 4
R Need help on calibration result analysis Measurement Uncertainty (MU) 14
G Need Help with Run @ Rate for Medical Devices ISO 13485:2016 - Medical Device Quality Management Systems 0
F Need help in IMS management review Management Review Meetings and related Processes 3
S I need help in corrective action plan Nonconformance and Corrective Action 15
D Weird spec sheet - need help Measurement Uncertainty (MU) 3
K Need Help With Auditing Suppliers Against ISO 9001 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 50
R Lead auditor scenario (Need help) is this non conforming to ISO13485 Manufacturing and Related Processes 2
U Need Help With API Q2 Quality Manual Oil and Gas Industry Standards and Regulations 8
D Need some Help on 8D fault tree analysis Problem Solving, Root Cause Fault and Failure Analysis 6
K Screen printing ink and machine selection_ Need help Manufacturing and Related Processes 6
J Need Help with FPY Data in Assembly Process Manufacturing and Related Processes 7
S Need help on "Country of Origin" Medical Device and FDA Regulations and Standards News 0
M Need Help With Information Security Asset Risk Register IEC 27001 - Information Security Management Systems (ISMS) 2
C ISO/ IEC 17021 Resource requirement (need help) Document Control Systems, Procedures, Forms and Templates 5
SocalSurfer AS9100 new certificate, but need QMS software, help Quality Assurance and Compliance Software Tools and Solutions 2
S Need help with analysing a survey on minitab Using Minitab Software 1
K A proposal for the model Quality Management - I need help for the project ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
R Probability - Need a help to solve the below question Statistical Analysis Tools, Techniques and SPC 5
8 Need Help - Runout - Function Gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
S New to FAIR, need help in filling it out AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 8
R Pls help --- Need expert advice on Video Measurement Measurement Uncertainty (MU) 0
Ajit Basrur Need help to understand HIPAA requirements ISO 13485:2016 - Medical Device Quality Management Systems 17
Z I need help with getting a CFS in China Manufacturing and Related Processes 2
S Need help wrapping my head around confidence vs beta error Statistical Analysis Tools, Techniques and SPC 2
P Received a minor for not having good measureables/goals. Need help with KPIs. IATF 16949 - Automotive Quality Systems Standard 52
A Failed the AS9120B Exam Twice.....Need Help AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 11
Ajit Basrur Need help in Conditional Formatting for the entire row Excel .xls Spreadsheet Templates and Tools 3
H Need help on Quality Improvement Plan (QIP) Quality Tools, Improvement and Analysis 5
S Help: Need Control Self Assessment Questionnaire for HR Departmental Functions Process Audits and Layered Process Audits 0
M Need help in Calibration of Directional Coupler General Measurement Device and Calibration Topics 2
L Need HELP with Internal Audit Program ISO 13485.2003 Quality Management System (QMS) Manuals 3
J Supporting Processes - Internal Audits - Need help settling a debate IATF 16949 - Automotive Quality Systems Standard 4
A Cpk Formula seems off, need help!? Capability, Accuracy and Stability - Processes, Machines, etc. 11
A Need Help With AEA Auditor Related Situational Questions AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
E Transformer Overload Test - Need help IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
C I Need Help with Drafting Conventions!!! Design and Development of Products and Processes 4
M Need help on QMS Development in an AS9100C certified organization AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 10
R Need Help on Analysis: How to know potential causality model from historical data Problem Solving, Root Cause Fault and Failure Analysis 5
B Need help with a Control Plan for Encapsulation Mold / Trimming / Forming Tooling FMEA and Control Plans 9
S I need help from all of you bros Oil and Gas Industry Standards and Regulations 1
LRE67 Need help identifying this "thing" Coffee Break and Water Cooler Discussions 9
G Need help on Device Description in the Acceptance Checklist for Traditional 510(k) Other US Medical Device Regulations 2
K Need help finding a book on Documentation Book, Video, Blog and Web Site Reviews and Recommendations 8
J Need help/advice on video editing software etc..... Coffee Break and Water Cooler Discussions 8
L Need Help with Case Study Questions Manufacturing and Related Processes 16
W Help explaining the need for the Process Approach AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
Ron Rompen Unusual problem with Excel - Need some help Excel .xls Spreadsheet Templates and Tools 7

Similar threads

Top Bottom