A Simple CA (Corrective Action) Database

M

mshell

#11
I also use MS Access to track CA/PA, Complaints, Nonconforming Product, Training Records, Training Requirements and Calibration (to name a few). It takes a little programming but you can set it up to notify when certain items are due. i.e document review, calibration, corrective or preventive action review. In the end it is worth the time as it makes accessing the information, identifying trends and reporting for management review much easier. You can also automate some of the process by programming the software to perform certain actions based on user input.
 
Elsmar Forum Sponsor
R

Randy Stewart

#12
I use Access also, have for a few years now. The one caution you should know is - go easy on the macros. We have a couple databases in use now that were written in the '95 version and can not be upgraded to the newer versions of Access due to some of the macros used. Our CA database has been upgraded with no issues.
Access is a powerful tool and with a little time investment you stand to save the company some $$$ by not going the commercial software route.
 
B

Bigfoot

#14
Thank you all for the great inputs and advice. :) I have some experience with MS access but it wasn't real good. Mostly due to the predecessors extensive use of macros & modules that made working with it (de-bugging issues) very difficult. If you aren't the guy who sets it up then trouble shooting it becomes a big headache :frust:

Joe: I sent you an e-mail. I couldn't download the .zip file from the thread.

Anyhow this site has been a real blessing to me in generating ideas to incorporate & revise documents for our TS 16949 system. Thanks again!!! :bigwave:
 
#15
Bigfoot said:
Anyhow this site has been a real blessing to me in generating ideas to incorporate & revise documents for our TS 16949 system. Thanks again!!! :bigwave:
You're right there, Bigfoot. I've said it before and will say it again: The information here is second to none, and no matter how much I contribute myself, I alway feel that I get more in return.

Well done Cove Dwellers. :agree:

As for Joe's database, I had a good long look at it earlier and it looks like a great tool. You could do a lot worse than trying it out. It's really neat. I have put a number of Access databases together myself, but unfortunately (for you ;) ) they are all in Swedish, and translating them would be worse than creating new ones.

/Claes
 
B

Bigfoot

#17
Claes,
Sorry about that. I've read many of the posts that you and others have made here and feel very thankful that this forum exists. There is so much valuable information and the free exchange of thoughts and concepts between the members is great. I thank you all again.

I am beginning to think that I know why Marc is the "wizard" but struggle figuring out the cheech part :vfunny:
 
G

Greg B

#18
JRKH said:
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
James,

The DB is rather large as it also does Continuous Improvement Suggestions, Master Documents Records and Changes, Training Attendance and a few other bits and pieces. It is my one stop shop for QA.

Greg B
 

Douglas E. Purdy

Quite Involved in Discussions
#19
Sounds Neat! Wish I had One! Can't Wait!

Greg B.:
The DB is rather large as it also does Continuous Improvement Suggestions, Master Documents Records and Changes, Training Attendance and a few other bits and pieces. It is my one stop shop for QA.
Sounds Neat! Would you be willing to send me the shell of your Access database. or have you already done so elsewhere in the Forum?

Thanks,
Doug
 
J

Joe Cruse

#20
This is for any of you folks that are using MS Access to make a database for Corrective/Preventive Action, or track non-conformances, or anything else in your professional/personal lives.

I came across a GREAT website just a week or two ago:

http://www.simply-access.com/microsoftaccessforum.html

I've looked over several Access-oriented sites, but this one takes the cake. Lots of traffic, lots of users with a wide and varied background, and lots of different applications of Access. There is a LOT of good info on not only the basic things, but also on using VBA to make you database do very nice things for you. Like this great place, it is encouraged to support the site, if you can.

Another good website is:

http://applecore99.com/

I started web-hunting for help a couple of weeks ago, when I started on a new project for our Safety Dept, to make an application for keeping up with industrial hygiene testing. Some good stuff at both places.

Joe
 
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
M Nice and simple invitation email to an audit kickoff meeting Internal Auditing 1
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
K 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

Similar threads

Top Bottom