The SBS Training Database Features Benefits Set-up Using the Training Database
Background 4 Managing employee training is critical to ensuring product quality and Customer satisfaction 4 Effective training ensures quality product and happy customers 4 Training is a key component of Quality Management Systems mandated by = = = = ISO 9001: 2015 ISO 13485 AS 9100 TS 16949 OHSAS 18001 ISO 14001 API Q 1 www. Sunday. Biz. Sys. com Sunday Business Systems
ISO 9001: 2015 Human Resource Requirements 7. 2 Competence The organization shall: a) determine the necessary competence of person(s) doing work under its control that affects its quality performance, and b) ensure that these persons are competent on the basis of appropriate education, training, or experience; c) where applicable, take actions to acquire the necessary competence, and evaluate the effectiveness of the actions taken, and d) retain appropriate documented information as evidence of competence. www. Sunday. Biz. Sys. com Sunday Business Systems
SBS Training Database Overview 4 Easy to use, menu driven 4 Defines employee Positions 8 Prerequisites, Previous qualifications 8 Roles and Responsibilities 8 Training required for the position 4 Tracks training requirements 8 By department 8 By individual employee 4 Record training classes, class rosters, and effectiveness measurements 4 Tracks re-certification requirements 4 Identifies delinquent training 4 Measures the effectiveness of your training management system 4 Built using Microsoft Access 8 Runtime version of Access is included 8 A Free runtime version may also be downloaded from Microsoft 8 No need to purchase Microsoft Access separately www. Sunday. Biz. Sys. com Sunday Business Systems
Easy Installation 4 Download the demo database 4 Unzip and Save or copy the Training DB. accde file to a designated folder on your Network File Server 4 Once purchased, register the demo database (enter the Product Key) 4 Ensure all Workstations have 8 Microsoft Access or the free Runtime version of Microsoft Access 8 Read and write privileges to the designated folder on the Network File Server Note: The above graphic is for stand alone Access databases - SQL configurations are different www. Sunday. Biz. Sys. com Sunday Business Systems
Terminology 4 Training class 8 A structured set of topics for training employees on a particular subject 4 Training Event 8 An event in time where training was performed and attended by specific employees 4 Training for Non-Critical Tasks 8 For tasks that do not directly effect product quality 8 Training for Non-critical tasks may happen one time 8 Training is recorded but does not require re-certification 4 Training for Critical Tasks 8 For tasks that directly effect product quality 8 Requires certification and re-certification on a periodic basis 8 Re-certification dates are tracked and reported 8 Management determines critical vs. non-critical tasks / training 4 Skill 8 A group of required training classes www. Sunday. Biz. Sys. com Sunday Business Systems
Terminology 4 Training Requirements 8 Are defined by Position 8 May also be uniquely defined for each Employee 8 Total Training Requirements are the sum of Position and Employee Requirements Position Requirements Required Training for Position + Position Skills + www. Sunday. Biz. Sys. com Employee Requirements Unique Employee Training Requirements + Employee Skills = Training Requirements Sunday Business Systems
How the Training Database Works 4 Training Requirements are compared to historical Training Events to determine Training Needs or Gaps 4 Management must take action to schedule and execute training events to close the gaps Historical Training Events Training Requirements Gaps www. Sunday. Biz. Sys. com Take Action to eliminate Gaps Sunday Business Systems
Set Up and Configuration Preparation Log in and Basic Navigation Set Up and Configuration
Preparation 4 Develop a concise Org Chart 8 Employee Names 8 Job Titles or Positions 8 Who reports to who (reporting structure) 8 Departments 4 Formalize positions 8 Create a detailed job description for each Position 8 Define any prerequisites for each Position 8 List all required training for each position 8 Group training into Skills and define the skill set for each position 4 Note any employee specific training for each employee 4 List any documents that require re-training when new revisions are released www. Sunday. Biz. Sys. com Sunday Business Systems
Login Screen 4 The login process limits access to specific database features based on the employee and password entered 4 The Demo version includes dummy data and employees 8 Admin is the default login for demo versions and has full Database privileges 8 Admin credentials: = = = Employee: Admin Password: admin All other employees password = pw www. Sunday. Biz. Sys. com Sunday Business Systems
Navigation Or, use the Quick Navigation Links 4 The main menu represents the Training process 8 Schedule Training 8 Hold Training Events 8 Analyze performance 4 Click on each item to open a form for data entry or reporting Click on an item to open a form www. Sunday. Biz. Sys. com Sunday Business Systems
Training Database Set-up – Process Flow www. Sunday. Biz. Sys. com Sunday Business Systems
Database Set-up - General Set-up parameters are organized into multiple tabs www. Sunday. Biz. Sys. com Sunday Business Systems
Setup - Add Departments 4 Add the functional departments that exist within your organization 8 Department numbers or codes are optional 4 After employees have been defined, add the department managers Use www. Sunday. Biz. Sys. com Sunday Business Systems
Setup - Add Employee Types 4 Define employee types 8 Such as Temporary, contractor, exempt, non-exempt Use www. Sunday. Biz. Sys. com Sunday Business Systems
Setup - Add Class Types and Categories Use www. Sunday. Biz. Sys. com Sunday Business Systems
Setup - Add Document Categories 4 Define categories to group document types 8 Used only if training is tied to document revisions 8 Is not required Use www. Sunday. Biz. Sys. com Sunday Business Systems
Other 4 Define “Near Due” warning limit for reports 4“Near Due” reports will include delinquent training events and events that are due within this warning limit www. Sunday. Biz. Sys. com Sunday Business Systems
Database Set-up (Continued) 4 Create Training Classes 8 Non-critical tasks – no re-certification 8 Critical Tasks – Certification Required 8 Create critical Documents that require Training when new revisions are released 4 Create Documents 8 Create training classes associated with the document 4 Create Skills 8 Skills are a group of related training classes assigned to one or more Positions 4 Create Positions 8 Enter roles and Responsibilities 8 Define Position Requirements = Define Training Requirements specifically for that position 8 Define Skills for the position 4 Enter Employees 8 Employees may have more than one position 8 Define Employee specific training requirements www. Sunday. Biz. Sys. com Sunday Business Systems
Create Training Classes 4 Enter Training Class Name (Title) 4 What training Category is appropriate? 8 This field helps organize the training classes 4 What is the Type of training? 4 Is Recertification required? 8 If so, when does the Certification expire? 4 Define when the training class is scheduled to be completed 4 The duration 8 How long does the class take? 4 Prerequisites 8 What training is required before this class may be taken? 4 Define training materials used in the class 4 Set-up links to training material for easy reference 8 Use Ctrl-K to add a link to a file www. Sunday. Biz. Sys. com Sunday Business Systems
Setup - Add / Edit Training Classes Fields with yellow background are mandatory. Training Class requires recertification How long is the certification valid? www. Sunday. Biz. Sys. com Sunday Business Systems
Training Class Delinquencies Position start date is set on the Employee Information form # of days to complete class after position start date www. Sunday. Biz. Sys. com Reports show date on which training must be completed Sunday Business Systems
Create Documents 4 Create a document 8 Open the Documents form and enter the document details 8 Note: Document ID and Title must be unique (no duplicates) 4 Make a new revision of the document Click to create the new revision Click to make a new revision 4 Check to require Training for this release www. Sunday. Biz. Sys. com Sunday Business Systems
Create a Training Class linked to the document To reset training requirements when a new document is released 1. 2. Create a new document or navigate to an existing document On the Training Requirements tab, 8 Click the Create Training Class button = = 8 Complete the training class set-up = = = 3. This will create a training class linked to the document Do not create a new training class from the training class form – this will not be linked to the document Complete the training class details (type, duration, etc. ) If re-certification is required if the document is not revised, check the re-cert required box and enter the number of days for expiration If recertification is only required when a document is revised, check the re-cert required box and enter 99999 days for expiration Add the new training class to the position requirements, employee requirements, or skills requirements www. Sunday. Biz. Sys. com Sunday Business Systems
Create a Training Class Based on a Document Edit linked Training Class details Create a special training class based on this document www. Sunday. Biz. Sys. com Sunday Business Systems
Create a Training Class Based on a Document 4 There are 2 options for re-certification: 8 Re-certify only when new revisions are released = Set the “Cert Expiration” = 99999 (a large number) 8 Certify annually or when new revisions are released (whichever comes first) = Set the “Cert Expiration” = 365 (for annual re-cert. ) www. Sunday. Biz. Sys. com Sunday Business Systems
Create Skills 4 Skills are A group of training classes or training requirements 4 May be assigned to one or many positions 4 May be assigned to individual employees (regardless of position) Enter the skill Name Select the set of training classes that are required for each skill www. Sunday. Biz. Sys. com Sunday Business Systems
Create Positions www. Sunday. Biz. Sys. com Sunday Business Systems
Create a New Employee Enter Detailed information (yellow is required) Filters to display active/inactive employees www. Sunday. Biz. Sys. com Sunday Business Systems
Create a New Employee – Assign Positions Employee may hold more than one position www. Sunday. Biz. Sys. com Sunday Business Systems
New Employee – Assign Training Requirements Employee may have unique training requirements (beyond those defined by the position) www. Sunday. Biz. Sys. com Sunday Business Systems
New Employee – Assign Skills Employee may be assigned unique Skills (beyond those defined by the position) www. Sunday. Biz. Sys. com Sunday Business Systems
New Employee – Privileges and Password 4 If employee is to log in to and use the database, 8 Assign a password = = Password must not be blank Password may be from 1 to 15 characters (including numbers and special characters) 8 Define which privileges apply 8 Only active employees may log in to the database 4 To prevent an active employee from logging in to the database 8 Click the Delete Privileges button www. Sunday. Biz. Sys. com Sunday Business Systems
New Employee – Linked Files Scan and link documents such as resumes / CV’s, prior certifications, licenses, etc www. Sunday. Biz. Sys. com Sunday Business Systems
Using the Training Database
www. Sunday. Biz. Sys. com Sunday Business Systems
Add a New Training Event www. Sunday. Biz. Sys. com Sunday Business Systems
Add a New Training Event 4 Select the Class Name from the list 4 Enter the Instructor Name 4 The training roster 8 Have employees sign a roster proving they attended the event 8 Scan the document and create an electronic file (. pdf) 8 Link the electronic file to the training event 4 Enter a Class Date 8 A date range may also be entered, but the single date is required 8 Duration is either calculated from the date range or entered manually 4 If recertification is required enter the Recertification Date 8 Then enter each attendee with Pass/fail = Pass/fail is important for the subsequent reports = If a test was taken, it may be scanned and linked to each employee name www. Sunday. Biz. Sys. com Sunday Business Systems
Record a Training Event Scan and link electronic roster Define date when recertification is required Enter measures of training effectiveness www. Sunday. Biz. Sys. com Scan and link electronic test results Generate a summary report Print a certificate Sunday Business Systems
Schedule a Future Training Event Enter event information Enter employees scheduled to attend www. Sunday. Biz. Sys. com Or, click to add all employees with the specified training class as a gap Sunday Business Systems
Schedule a Future Training Event Review the entire training schedule Click to print a Class Roster (may be used as a “sign-in sheet”, scan and link to event) www. Sunday. Biz. Sys. com Sunday Business Systems
Hold a Scheduled Training Event 4 Use the Edit Existing Event button to convert a Scheduled eventform a to for Filter the Scheduled Events Completed event Mark the event as Complete Scan and link the training roster Enter Pass/Fail and evaluation details www. Sunday. Biz. Sys. com Sunday Business Systems
Reports and Analysis Historical Reports Training Requirements Gaps
Different Report Types 4 Historical reports 8 Complete training history 8 Shows all employees (active or inactive) 4 Requirements reports 8 Training Requirements for active employees 8 Shows all required training = = Needed training (training that has not yet been performed) Needed and Scheduled training Delinquent re-certifications Completed training 4 Gaps reports 8 Required training for active employees including = = = Needed training Needed and Scheduled Delinquent re-certifications www. Sunday. Biz. Sys. com Sunday Business Systems
Configurable Reports Report Filters (different filters apply to different reports) www. Sunday. Biz. Sys. com Sunday Business Systems
Key Reports – Training History www. Sunday. Biz. Sys. com Sunday Business Systems
Key Reports – Gaps By Department Date In Red indicates recertification is delinquent Need indicates class has not been taken Scheduled indicates class has not been taken, but is scheduled www. Sunday. Biz. Sys. com Sunday Business Systems
Key Reports – Requirements By Department Key performance indicators Date In Red indicates recertification is delinquent Need indicates class has not been taken Date In Red indicates training is past due Scheduled indicates class has not been taken, but is scheduled www. Sunday. Biz. Sys. com Sunday Business Systems
Click & Email reports to all delinquent employees www. Sunday. Biz. Sys. com Sunday Business Systems
Analyze Employee Turn Over 4 Analyze employee turn over 8 Head Count reports 8 Ratio of Employees hired to Terminated 8 Turn Over Rate = (# Employees Terminated) / (Total head Count) www. Sunday. Biz. Sys. com Sunday Business Systems
Deleting Demo Data The demo is a full featured demonstration Database Customers will purchase an activation code and activate the demo
Deleting Demo Data 4 The demo data may be deleted once you purchase a License key 8 You may activate the actual file you downloaded and evaluated 4 To delete a single employee www. Sunday. Biz. Sys. com Sunday Business Systems
Deleting Demo Data – Deleting multiple records 4 Right click on the top of a form, 4 select datasheet view, Press Delete on the Keyboard www. Sunday. Biz. Sys. com Sunday Business Systems
Summary 4 The SBS training database is a cost effective tool to 8 Ensure effective training compliance with = ISO 9001: 2015 = AS 9100 = TS 16949 = OHSAS 18001 = ISO 14001 = API Q 1 8 Develop and execute training plans 8 Maintain paperless quality records 8 Analyze performance and develop improvement strategies 8 Save time and effort 4 Ask us about our T-Med Database for employee training management in FDA regulated industries www. Sunday. Biz. Sys. com Sunday Business Systems
Additional Services 4 Data Import Service 8 Import legacy data from excel spreadsheets into your Database 4 Training Services 8 SBS offers instructor led, Webex based, interactive training sessions 8 We cover the following subjects: = = = Vendor Management Database features and benefits General set-up and configuration Creating Qual plans / requirements Creating Qualifying Vendors Using reports to manage the qualification process Microsoft Access tips and tricks 4 Customization 8 Talk to us about customizing the software to meet your needs! 4 Contact Sales@Sunday. Biz. Sys. com for additional details www. Sunday. Biz. Sys. com Sunday Business Systems
About SBS 4 Sunday Business Systems is engaged in software sales and consulting services. 4 Applies Lean Manufacturing principles to Quality Management Systems 4 Sells software solutions to small businesses which help them implement ISO 9001: 2015 compliant systems for 8 Document Control 8 Corrective and Preventive Actions 8 Risk Management (FMEA) 8 Employee Training 8 Control of calibrated equipment 8 Preventive Maintenance 8 Vendor Management 8 Customer Satisfaction Surveys 8 Statistical Process Control 8 Shop Floor Control 4 SBS will customize the software for a particular Customer 4 Offers full Training services customized to individual needs www. Sunday. Biz. Sys. com Sunday Business Systems
Fueling Small Business Efficiency Visit www. sundaybizsys. com for: • Additional information • Free product demos • Pricing • Links to purchase software © 2016 Sunday Business Systems. All rights reserved. This presentation is for informational purposes only. Sunday Business Systems MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY. Microsoft is a registered trademark of Microsoft Corporation in the United States and/or other countries.
Скачать презентацию The SBS Training Database Features Benefits Set-up Using
e18111a659356b371618575cddcac021.ppt