Continual Improvement, Preventive Action and Corrective Action Database

#1
Hello Covers,
I had reason to strip down my home rolled Continual Improvement, Preventive Action and Corrective Action (Measure) database per request. I thought I would share it with all my friends at Elsmar Cove.

Hopefully, when you open it up it will be self-explanatory. There are a few things you need to know:

Requires Microsoft Access 2007. Rename the extension from .mdb to .accdb. Elsmar upload filters do not recognize the .accdb extension.

The first entries are "seeds" for the automatic "Initiative Numbering System" that creates a unique number for each entry. Don't delete them or the numbering system won't work. They are samples that list what goes in each entry box. You can print them as "blank forms" for your system documentation.

If you mistakenly click on a "Create New..." button, do not enter a date below the Log # and exit the form. Access will not save the record without this date.

Entering a date in the "Date Implemented" field in the "Actions Taken" section will move the record from "Open" to "Closed" for the purposes of the "View/Edit Open..." and "Preview Open..." buttons.

Enjoy!
 

Attachments

Elsmar Forum Sponsor
#3
You're welcome, Marc. Another note: If you don't like your first entry in each category to be a "sample", you can edit the existing entry data to whatever your first CI, PA, or CA turns out to be.
 
1

1winnyAK

#5
I would like to use this at my work but if someone doesn't have Microsoft Access how they fill out the form and somehow link or save it where it automatically saved into that database?
 
Q

QCAce

#6
I would like to use this at my work but if someone doesn't have Microsoft Access how they fill out the form and somehow link or save it where it automatically saved into that database?
There is a read-only version of MS Access called Runtime that is a free download from Microsoft:
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

This will allow users to run and enter data into your database. It will not allow them to enter the design view or create tables, forms, queries, etc.
 
1

1winnyAK

#8
How did you create this database? I'm just curious if I wanted to change up a form or would like to create a database for my other quality inspection type.
 

howste

Thaumaturge
Super Moderator
#10
How did you create this database? I'm just curious if I wanted to change up a form or would like to create a database for my other quality inspection type.
If you want to change a form or modify/update the database, you'll need a full version of Access.
 
Thread starter Similar threads Forum Replies Date
K Continual Improvement & Preventive Action Differences ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
B Four Key Performance Indicators for Continual Improvement (Dec. 3 2019) [Deleted] Training - Internal, External, Online and Distance Learning 2
R Linking the Processes of Continual Improvement, Change Management, Risk Management, Action Planning, etc? Preventive Action and Continuous Improvement 5
A A Question about Continual improvement process in AS9100 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
B Ranking Continual Improvement Projects Quality Tools, Improvement and Analysis 5
J Understanding ISO 9001:2015 - 10.3 Continual Improvement ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
P CA,PA, Continual Improvement - How to start in a Service Company Quality Tools, Improvement and Analysis 1
Marc How will "continual improvement" be audited? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
B Internal Audit Question - 8.5.1 Continual Improvement ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 23
M Continual Improvement Procedure - Please review Document Control Systems, Procedures, Forms and Templates 1
P Document Control vs Continual Improvement Document Control Systems, Procedures, Forms and Templates 11
C Continual Improvement in the context of ISO 22000:2005 Preventive Action and Continuous Improvement 2
Q Process Approach & Continual Improvement Clauses and Evidence of its Effective Use ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
S Continual Improvement vs. Ineffective Actions AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
A Definition Continual Improvement vs. Kaizen - Differences Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 6
T TS 16949 Continual Improvement Requirements vs. QS-9000 Requirements IATF 16949 - Automotive Quality Systems Standard 16
somashekar Environmental and OH&S Management Continual Improvement Miscellaneous Environmental Standards and EMS Related Discussions 7
V Continual Improvement of the Organization - TS 16949 Clause 8.5.1.1 IATF 16949 - Automotive Quality Systems Standard 10
S Continual (Continuous) Improvement - Different Standards, different requirements Occupational Health & Safety Management Standards 12
I Process Improvement/Continual Improvement "Idea Stage-gate" process? Misc. Quality Assurance and Business Systems Related Topics 3
N Continual Improvement Tools Preventive Action and Continuous Improvement 3
R Definition Continuous Improvement and Continual Improvement - Differences Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 21
A Clause 8.5 Continual Improvement - What is intended by the standard? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
B Quality Policy - Need to include "Customer Satisfaction & Continual Improvement? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
somashekar Temperature Cycling Process - Continual Improvement and ISO 13485 ISO 13485:2016 - Medical Device Quality Management Systems 6
M Continual Improvement & KPI's (Key Performance Indicators) - ISO 14001 REACH and RoHS Conversations 23
V Gearing up GMP based systems for continual improvement. US Food and Drug Administration (FDA) 4
Anerol C What can I show as evidence of Continual (Continuous) Improvement? Preventive Action and Continuous Improvement 81
B 8.5.1 Continual Improvement - What Quality Objectives can I add? Construction ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
Z Continual Improvement based on a Company's Characteristics Preventive Action and Continuous Improvement 6
L Introduce Continual Improvement in a Mining Equipment Service Company ? HOW? Quality Tools, Improvement and Analysis 5
R Jump Start Continual Improvement Process - What works? Preventive Action and Continuous Improvement 9
V TQM - Implementing Continual Improvement of Product, Processes and System Misc. Quality Assurance and Business Systems Related Topics 1
B Continual Improvement Requirements - No expected completion date listed - 8.5.1 IATF 16949 - Automotive Quality Systems Standard 10
B Continual Improvement form - Does anyone have a CI form they will share? Preventive Action and Continuous Improvement 2
C Process Goals - Stretch or "Do-able": Corrective Actions or Continual Improvement Preventive Action and Continuous Improvement 6
M Setting Objectives and Targets for the EMS - Is continual improvement required? Miscellaneous Environmental Standards and EMS Related Discussions 23
J Continual Improvement - Service Company - Carpool, manpower, purchasing, logistics Service Industry Specific Topics 1
P Continuous vs. Continual Improvement - The Differences Preventive Action and Continuous Improvement 9
L Records of continual improvement - How do you keep auditors happy on this topic? Records and Data - Quality, Legal and Other Evidence 11
J Continual Improvement - What is CI and what is CI not? Preventive Action and Continuous Improvement 32
Marc The Continual Improvement Process (vs. Continuous Improvement?) Book, Video, Blog and Web Site Reviews and Recommendations 6
C Continual Improvement Book Book, Video, Blog and Web Site Reviews and Recommendations 14
Q Difference between Continuous and Continual Improvement IATF 16949 - Automotive Quality Systems Standard 8
C Evidence of Continual Improvement ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
R Anyone have a procedure to share for TS 16949 - 8.5.1 Continual Improvement? IATF 16949 - Automotive Quality Systems Standard 3
A Is reduction of scrap a valid Continual Improvement Project? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
L ISO 14001 - Environmental Management Program - To govern continual improvement? ISO 14001:2015 Specific Discussions 6
A Continual Improvement of Production Processes - TS 16949 IATF 16949 - Automotive Quality Systems Standard 11
J Continual Improvement vs. Continuous Improvement - Terminology Semantics ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 16

Similar threads

Top Bottom