Employee Training Database wanted

A

AirdrieQPA

#51
Re: Employee Training Database

Here's a database that I've developed over a period of years. It addresses not only the competence of employees, but responsibilities and authorities as well.

It's currently formatted for Access 2003.
Thanks for supplying that Training database, It is a little bit more than I need but may I shuffle some things around for our company? If not I understand, but why reinvent the wheel when you have done such an incredible job. Bravo Zulu on this project.
 
Elsmar Forum Sponsor

Stijloor

Staff member
Super Moderator
#53
how do i look at ur table n etc??
Welcome to The Cove Forums! :bigwave: :bigwave:

Can you translate your question by removing the textspeak?
Many of our members can only read English.
That will help you to get prompt responses.

Thank you! :agree1:


Stijloor, Forum Moderator.
 
E

ericajv

#55
Howste,

Great database! Quick question: how can I change the zip code parameters in order to input letters as well and not just numbers?

Thank you!
 
J

jimdiggity

#57
Howste - I scoured the internet for some templates for training databases and it seems like they don't exist. Finally I stumbled upon this forum and it's just what I was looking for. I'm in the process of tailoring it to our training program, but I had a few questions to see if you might be able to help out. Right now I'm running Access 2010 (and I realize that some of these questions might be impacted from that), but here we go:

1. I can't attach pictures using the Ole function on the employee...in fact, when I click the photo box, it crashes the DB and exits me out of Access without giving me any information. Any idea why that would be? I've also tried attaching the photo directly into the table, but I can't open it, it shows no thumbnail (just a blank image placeholder), and it doesn't show in the reports.

2. I'm having major issues with generating the Training Matrices - when I try to generate any of them, the DB tries to open Excel (also 2010), but it gets locked up because Excel tries to protect the worksheet and the confirmation passwords do not match - completely unsure on this one.

3. When I generate a Full Size Phone List (via the employee form), I'd like to make some adjustments to the info listed on the generated report, but I can't seem to find the report template that is being generated (so I can tailor it to what fields I'd like)...any idea where that is or where I can adjust that?

4. This would be nice to have, and I've got some basic workarounds utilizing some tables imported into the form, but is there any way to import certificates into the employee form? I'm trying to have a tab that would list the training classes accomplished (sort of like the employee training list on the tab within the Submit Employee Records form) with an attachment of the actual cert that the employee received.

Anyway, really appreciate the database and the price (!) - it really is a good DB and I'm impressed with the functionality. My Access experience is alright, and I'm a quick learner on most things CS - I'm terrible with VBA, though.

Any help would be greatly appreciated.

J
 

howste

Thaumaturge
Super Moderator
#58
Hi Jim. :bigwave: All of the issues you're talking about have to do with the version of Access you're using. The latest version of Access that I have is 2003, so unfortunately I can't help you there. Sorry...
 
A

AirdrieQPA

#59
Re: Employee Training Database

Here's a database that I've developed over a period of years. It addresses not only the competence of employees, but responsibilities and authorities as well.

It's currently formatted for Access 2003.
I have used it and it is simply fan-dam-tastic. Thank you very much.:applause:
 
S

StorkSPA

#60
Howste,

I solved some of the problems by having the access 2003 runtime reaplced by a fully functional access 2003. I am now able to look under the hood.

I think one of the causes for problems / unreliable operation might be the "sendkeys" command to update the excel table. Sendkeys is not known for its safe operation. With me sometimes the table gets updated, and sometimes it doesn't.

However, I found a more serious bug within access itself. In my example file for the safety class, most of them have reached level 0 (meaning need to training indicated) on 6 jan 2011. However, when the retraining matrix is printed, all of them are up for retraining on 6 jan 2012. In this case, they should all be retrained on first available occasion as they do not comply with their job requirements.
The required training matrix indicates all my test persons correctly as "training need indicated": only those persons that reached level 0 or 1 are mentioned.
 
Thread starter Similar threads Forum Replies Date
R How to keep track of employee read-only training ISO 13485:2016 - Medical Device Quality Management Systems 13
S PPT for ISO13485:2016 Employee Training (Request) ISO 13485:2016 - Medical Device Quality Management Systems 0
SATHYABALARAMAN What are the topics to be covered for Training the employee as per IATF 16949:2016 IATF 16949 - Automotive Quality Systems Standard 2
S Employee Training Matrix - Keeping track of employee training on various SOPs ISO 13485:2016 - Medical Device Quality Management Systems 4
M Employee Motivation 7.3.2 & Training including Awareness 7.2.1 IATF 16949 - Automotive Quality Systems Standard 6
P Need a new video for employee training ISO 9001:2008 Training - Internal, External, Online and Distance Learning 6
F ISO 9001:2015 - Employee Training Powerpoint .ppt wanted Training - Internal, External, Online and Distance Learning 8
R Managing Employee Training Files - 21 CFR Part 820.25 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 4
K Online Employee Training Software Training - Internal, External, Online and Distance Learning 1
Q Employee Training - Company Transition 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
E Outstanding Employee Training Records Training - Internal, External, Online and Distance Learning 11
G Tracking Employee Training Software Training - Internal, External, Online and Distance Learning 7
S Employee Training Videos for employee ISO TS 16949 Audits IATF 16949 - Automotive Quality Systems Standard 2
P MDD position on Final Inspection/Release Employee Experience/Training EU Medical Device Regulations 1
M ISO 13485 and FDA QSR Employee Training Requirements when Procedures are Revised Manufacturing and Related Processes 5
C MSA for Employee Skill (Training) example wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 14
F CVs/Resumes & Competence, Training, and Awareness - Employee Confidentiality ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
M Employee Turnover vs. Keeping up with Training Training - Internal, External, Online and Distance Learning 7
T Employee Training and Qualification - Major Non-conformance - ISO 13485, Cl 6.2.2 Nonconformance and Corrective Action 8
S Excel Training Matrix wanted - Moving employee training info from Access to Excel Training - Internal, External, Online and Distance Learning 11
L Employee Training for the ISO 9001 and AS 9100 Standard AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
Q Competency and Training Verification - Review of employee resume/application ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
O Employee Training to Quality Documents Training - Internal, External, Online and Distance Learning 11
C Employee Improvement Training Materials - How to improve employees Training - Internal, External, Online and Distance Learning 11
L Understanding IS/TS 16949 - Employee Awareness Training .ppt powerpoint presentation Training - Internal, External, Online and Distance Learning 12
R Salaried Employee Training requirements in ISO9001 para 6.2.2 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
E Training Record - By Job or by Employee? Training - Internal, External, Online and Distance Learning 6
F Re-Training an Employee on the Use of Micrometers - Teaching Disaster Training - Internal, External, Online and Distance Learning 2
K Employee Training For Upcoming ISO 9001 Audit ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
H Establishing Employee Competencies and Training - Future Training Plan ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
C Training needs of employees - Consultant has idea of an employee evaluation form Training - Internal, External, Online and Distance Learning 1
Q Temporary Employees Training and Employee Retention suggestions needed Training - Internal, External, Online and Distance Learning 38
J Creating a TS 16949 Training Class for New Employee Orientation IATF 16949 - Automotive Quality Systems Standard 15
K Supporting Site Certification - Employee Training Records Retention Location IATF 16949 - Automotive Quality Systems Standard 2
A ISO 9001:2000 Employee Awareness Training Video in Spanish Training - Internal, External, Online and Distance Learning 2
W Employee Training Communication System (Process) Training - Internal, External, Online and Distance Learning 2
N ISO/TS 16949:2002 Employee Training IATF 16949 - Automotive Quality Systems Standard 1
Raffy How can I identify employee training needs? Training - Internal, External, Online and Distance Learning 1
Brizilla Employee Data Privacy Policy - ISO 9001:2015 requirement(s)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
G Internal Audits and Employee engagement Internal Auditing 16
T Question about Quality Department employee position titles Quality Manager and Management Related Issues 10
qualprod Non conformity, do nothing? Employee experiencing "hard times" ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 26
E Employee complaining about air quality Occupational Health & Safety Management Standards 12
S Testing (Evaluation of) and Verification of Employee Color Vision Human Factors and Ergonomics in Engineering 19
S Ways to demonstrate objective evidence that employee is trained and competent ISO 13485:2016 - Medical Device Quality Management Systems 28
C AS9100D 7.1.5.2 / Calibration of Employee Owned Measuring Equipment AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
J Hardness inspection Audit Finding Employee error Nonconformance and Corrective Action 6
R Employee diet to reduce absenteeism and increase productivity Hospitals, Clinics & other Health Care Providers 24
R Use of Employee Assessments for ISO 13485:2016 Training - Internal, External, Online and Distance Learning 1
R Defect Display Area for Employee Shift Change Information Misc. Quality Assurance and Business Systems Related Topics 1

Similar threads

Top Bottom