A Simple CA (Corrective Action) Database

Bigfoot

Involved - Posts
#1
:( I am in need of a simple easy to use database for Corrective Action that can be used without much IT support (staff reduction). Help!!
 
Elsmar Forum Sponsor
#2
We also are looking for some simple system to document our CA system. We have not done any research yet on this so any suggestions out there would be greatly appreciated. Preferably something with automatic notification each way (to dept that needs to respond and when response is entered back to requestor)
 
D

D.Scott

#3
Welcome to the Cove Bigfoot.

Do you have to have something as sophisticated as a database? I use a log for C/A created as a table in Word. By adding it to my Start-up Menu it pops up first thing every day for review. By designating columns you can sort the table any way you want for analysis. I have used this method for years and never had it questioned by an auditor. The thing I like most is that it works for me and I don't need any IT support.

It looks like Sean is looking for something a little more IT oriented and this would appear too simple for his purpose. Maybe others here have some good feedback that will help you Sean.

Dave
 

Bigfoot

Involved - Posts
#4
Dave,
The log would likely serve my needs currently, but I was trying to think ahead :bonk: , hoping to get some ideas to use for electronic notification, reminders, due dates, etc. I remember seeing a thread here, where someone had made reference to using MS Outlook to do Corrective Action tracking but can't find it again. :mad:
 
J
#5
Recommend MS Access

Years ago I created a tracking system in Access. I liked it mostly for the ability to create reports etc.

I currently am using Access for External rejections and Corrective Actions. Our internal NC's and CA's are handled through a Shop database that will interact with MS Access so I can download any information I need and run analysis on it.

Access is more complex than excel, but is pretty straight forward. (I know just enough to be dangerous)

Plus it gives a lot of flexibility and allow you to grow the system.

James

PS I also created a calibration database, also in Access. Works very well.
 

Kevin Mader

One of THE Original Covers!
Staff member
Admin
#7
Currently, we use an Access db to track CAPA activities, generate forms, reports, and queries for specific analysis. As far as prompts and notifications, weekly reporting uses on screen prompts helps the administrator to quickly assess what's currently going on while the reporting uses conditional formats to highlight areas needing attention. The nice thing about using Access is the availability of snapshot files which can be sent to most anyone (as long as you have a Microsoft platform). Even if a person doesn't have Acces as an installed application, they can open the reports through the Snapshot viewer. It's pretty slick.

As a means of reminders, I use Microsoft Outlook in conjunction with Access. I enter due dates to prompt myself of required activities. You may want to give this a shot. Otherwise, there's a host of software out there you can buy, but personally, it hasn't worked very well with CAPA systems I've designed. I found myself throwing it out and building our own system. Word and Excel are equally effective in getting the job done as Dave points out. Keep it simple.

Regards,

Kevin
 
J
#8
Tips for Access

Are you already familiar with Access?

Basically take a little time to decide what kind of reports you want to get, what foms will be useful etc. Then decide what information you need to put in and create our table(s).

When you create a table It will ask you if you want to create a Primary key. I have always said no because I have had some trouble with it in the past. (but that just may be me)

I also like to have seperate tables for things like customer names, root cause, disposition etc. then I plug these into the appropriate form using a drop down menu. That way things are kept consistant and helps when your are doing reports etc.

Most of all (if your new to Access) be patient. It took me about 3 months playing with it in the evenings to get it working the way I wanted it.

Hope this helps

James
 
G

Greg B

#9
Bigfoot said:
Thanks for the feedback. Any tips that I should watch out for as I attempt to set up an access database?
Bigfoot,

I agree with James. Take your time to map out what you want (I literally wrote it all our on A3 sheets (Tables, Queries, Forms, Reports, Macros etc). For instance: The Major table (I have 40 Tables) has 60 fields (many of these are taken directly from the CA form). In this way, we can record ALL of the data entered on the form. I have many Sub-Tables designed to be used as drop down menus (makes things easier when entering data) like Managers titles, Departments, Type of Event (Contamination, Damaged packaging etc).

When I make a Table I always make a master query based on the table. In this way you can make forms (for data entry) easier. As James stated, this could take you many months to complete. I am still playing around with my DB after three years. It is a WIP.

I did a few VERY basic courses but as with all MS Software I learned more by using the program and playing around with it.
Greg B
 
J
#10
Greg - 40 tables????

Wow Greg I didn't wind up with more than maybe a half dozen tables.

But your right. Taking the time up front to map what you want is critical.
I also Like the Idea of creating a master Query for each table.

MS Access should have some sample DB's in it. Also some prebuilt ones (like inventory control) I would reocmmend taking a look at these to help learn how the systems work. Set up one of the prebuilt Databases and look at how it functions.

James
 
Thread starter Similar threads Forum Replies Date
J Simple Corrective Action Flow Chart example needed Problem Solving, Root Cause Fault and Failure Analysis 4
C Tracking Corrective Action - Preventive Action - Simple Product/Documentation Change Nonconformance and Corrective Action 1
I Example(s) of simple CAPA (Corrective and Preventive Action) forms Nonconformance and Corrective Action 11
S Simple CAPA (Corrective Action and Preventive Action) Example for Training? Nonconformance and Corrective Action 8
G Rework, Reprocess, or Correction - A simple blurred letter on the legible etching ISO 13485:2016 - Medical Device Quality Management Systems 4
C Looking for simple Software Validation IQ templates. Qualification and Validation (including 21 CFR Part 11) 4
C Micrometer and Vernier Caliper simple calibration process General Measurement Device and Calibration Topics 8
I Tracking Protoype Changes; 8D or simple document revision? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
Q Simple and effective way to maintain Training Matrix ISO 13485:2016 - Medical Device Quality Management Systems 16
J Simple supplier evaluation qualification process form that includes Risk Assessment Document Control Systems, Procedures, Forms and Templates 2
L Simple Example for PFMEA / Control Plan Training Training - Internal, External, Online and Distance Learning 1
kmyers Simple ISO 9001:2015 Overview Presentation wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 20
V Acceptance Criteria Gage R&R - Simple vs Complex Techniques Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
V Making a choice of Simple vs Comprehensiveness of Procedure/System of any Process Document Control Systems, Procedures, Forms and Templates 4
K Simple ISO 9001 Compliant Document Control Quality Manager and Management Related Issues 24
R Determining the feasibility/scope for FDA IQ/OQ against a very simple application US Food and Drug Administration (FDA) 2
R Root Cause for "Simple" External Audit Findings ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
Marc What Airlines Really Charge (In 1 Simple Table) Travel - Hotels, Motels, Planes and Trains 6
E Simple Calibration Procedures for Surftest SJ-400 General Measurement Device and Calibration Topics 6
K Too Simple an Internal Audit Check Sheet? Internal Auditing 10
S Can you help with a simple SPC sheet to judge if inspection is Good / No Good ? Capability, Accuracy and Stability - Processes, Machines, etc. 8
T Microsoft Access Database to create a Simple Calibration Certificate General Measurement Device and Calibration Topics 6
S Destructive Attribute MSA for Simple Water Leak Check in Trailers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
V Best CAPA for slip in simple-yet-persistent oversight-review mechanism Nonconformance and Corrective Action 7
A Simple 125 piece part Capabilty Excel .xls sheet to calculate Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 3
R A simple electronic (software) document control question ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
A QSM documents for Simple Designs Quality Manager and Management Related Issues 12
M Looking for a simple procedure on section 7.5.2 for Validation of Processes ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
Proud Liberal Making a simple Sampling Plan by Variables Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
W Simple SPC Software recommendations Quality Assurance and Compliance Software Tools and Solutions 8
Z IEC 60601-1-2 for very simple Medical Device Accessory IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
P Monitoring Production Defects - Three simple questions Six Sigma 3
C Simple explanation of Uncertainty in Calibration Measurement Uncertainty (MU) 2
V External power supply with reinforced insulation as a simple secondary circuit? IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
M Conducting Limited Internal Audits of QMS Elements - Simple question I hope ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
K How to set up a simple Complaint and CAPA workflow Nonconformance and Corrective Action 9
V Simple Representation for Scope of DFMEA and PFMEA FMEA and Control Plans 4
Stijloor Simple Navigation Guide for the MSA 4th Edition Manual Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
S Simple Cartoons needed Coffee Break and Water Cooler Discussions 4
X FDA Approval Process - Simple Explanation requested US Food and Drug Administration (FDA) 4
K Definition Box Plot - Simple Explaination of what a Box Plot is Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 3
M Simple Field Pipeline Demagnetization Procedure needed Document Control Systems, Procedures, Forms and Templates 5
6 Simple Flow Diagram with CCPs for Processing of Raw Fish Food Safety - ISO 22000, HACCP (21 CFR 120) 1
V Can Anyone Give a Simple Explanation on ndc (number of distinct categories)? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
T Export "Simple Notification" required by the FDA under Section 802 of the Act Other US Medical Device Regulations 3
Ajit Basrur EAC, Simple Code and NACE Code ISO 13485:2016 - Medical Device Quality Management Systems 5
1 Simple Dock Audit Form Document Control Systems, Procedures, Forms and Templates 1
Colin Simple Home Remedies Funny Stuff - Jokes and Humour 6
B Overall Process Capability - Simple question if you know how to answer it! Statistical Analysis Tools, Techniques and SPC 3
Colin Simple Preventive Action Procedure - Service Company (Please Review) Preventive Action and Continuous Improvement 20

Similar threads

Top Bottom