OSHA Training & Certification System
Last updated: April 2026
A Fortune 500 oil and gas chemical processing facility needed to replace an outdated OSHA Training Management System with a platform that could track employee training, instructor credentials, class scheduling, certification testing, and compliance gaps across a highly regulated industrial environment. PCG built the system in Microsoft Access with VBA, integrating it with badge management so uncertified employees could not access restricted areas. The result was a 100% efficiency training rating, full OSHA compliance, and the elimination of one staff member's full-time engagement with a paper filing system.
Project requirements
Track trainer credentials and qualifications. Track class schedules and attendance. Ensure attendees were tested and passed. Guide the OSHA certification process. Manage classroom locations and facility utilization. Equipment inventory. Lesson plan certifications. Email notification system.
Languages and database
Microsoft Access, Visual Basic for Applications (VBA).
Company size
Fortune 500.
Industry
Industrial safety / oil and gas manufacturing.
❓ What problem did this project solve?
In a volatile oil and gas chemical processing environment, an employee who has not completed required OSHA training is a liability, not just a compliance gap. The facility was operating with an outdated training management system that could track attendance but could not reliably flag gaps, manage instructor qualifications, or produce the documentation government agencies and internal supervisory staff required.
The system also had to handle the complexity of a Fortune 500's internal policies on top of OSHA requirements: training curricula, secured testing, grading, certification hard copies, continuing education credits for instructors, and classroom scheduling across multiple facility locations. What made this particularly consequential was the badge management requirement. An employee whose certifications had lapsed needed to be physically prevented from entering restricted areas, which meant the training database had to connect directly to the facility's access control system.
🛠️ What PCG built
PCG built a unified training management platform in Microsoft Access with VBA, sectioned into the major functional areas that trainers and administrators needed to operate independently. The interface was designed for non-technical staff, which mattered in an environment where the people using it were safety professionals, not database administrators.
The system tracked every dimension of the training cycle: scheduled sessions against actual attendance, individual employee certification status, instructor credentials and continuing education requirements, classroom utilization, and equipment inventory. When a certification lapsed or a mandatory training session was missed, the system flagged it automatically and notified the relevant supervisors. That alert layer eliminated the manual monitoring that had required dedicated staff time under the old system.
The integration with the badge management system was the most operationally significant component. Employees whose certifications were not current were automatically blocked from accessing restricted areas of the facility. The training record and the physical access control were the same system. A paper filing operation that had consumed one full-time staff member was replaced by automated processes. The facility achieved a 100% efficiency training rating and brought its OSHA compliance posture to a level the previous system could not have documented.
🔍 Technology used
Managing OSHA training compliance, certification tracking, or industrial safety records in a system that cannot flag gaps before they become violations?
PCG has built industrial safety and compliance systems for Fortune 500 operators since the 1990s. The $2,500 diagnostic engagement scopes the work before any development begins.
Talk to PCG
PCG founded 1995. All project details drawn from PCG's internal documentation. Client identity withheld at client request.
Frequently Asked Questions
Yes. PCG built an OSHA Training Management System for a Fortune 50 multinational operating a gas and fluids processing plant. The system tracked employee training attendance, course completions, certification status, instructor credentials, class scheduling, equipment inventory, and lesson plan certifications. It achieved a 100% efficiency training rating and eliminated one full-time staff position previously dedicated to paper filing. If your industrial operation needs a custom OSHA compliance tracking system, the first step is a free 30-minute consultation.
The OSHA system PCG built integrated directly with the facility's badge management system. An employee whose certifications were expired or incomplete was flagged in the system and their badge access to restricted areas was automatically restricted. The link between certification status and physical access meant that compliance gaps could not be ignored or worked around. For a gas and fluids processing environment where a single regulatory breach carries serious liability, that integration was a core safety requirement, not an optional feature.
The system PCG built flagged any gap between scheduled mandatory training and actual attendance, expired certifications for both employees and instructors, failed tests requiring remediation, and upcoming recertification deadlines. Alerts were sent automatically by email to the relevant supervisors and management staff. The mass mailing capability also handled scheduling announcements and sign-off sheet distribution for attendance records. Supervisors did not need to audit the system manually to identify compliance gaps because the system surfaced them as they occurred.
Yes. Instructor credential tracking was a separate module in the system PCG built. It covered instructor qualifications to teach specific courses, continuing education credits, curriculum management, and class scheduling tied to instructor availability and certification level. An instructor whose credentials had lapsed could not be scheduled for a course they were no longer qualified to teach. For OSHA compliance purposes, the qualifications of the instructor delivering the training are part of the audit record, not just the attendance of the employees receiving it.
Yes. PCG migrates Access and VBA-based compliance systems to modern .NET platforms regularly. For an OSHA training database, the migration preserves the full history of employee training records, certifications, test results, and instructor credentials. That historical record is what an OSHA audit examines, and it cannot be lost or altered during a platform transition. PCG validates the migrated data against the source system before the old platform is retired.