9 replies to this topic

[Suzie B]

I'm looking for templates for recording NCRs and CARs.  Anybody have a good one to share?

 

Thanks

[MCIAN]

Hi Suzie!

 

What template are you looking for? A CAR which you will issue to concerned parties or just a database for tracking the issued CARs/ NCRs?

 

 

Best regards,

 

 

[Joe Gillespie]

This is what we use, hope it helps.

Attached Files

•  Corrective Action form.docx   366.34KB   1405 downloads
•  Non Conformance Log (Template).docx   43.49KB   1213 downloads

[it_rains_inside]

Here is our Corrective Action / Preventative Action form - There are places in the header for Document Control features (I just deleted mine) and Company logo. Also attached is the log for overall recording / trending.

Hope it helps!

Attached Files

•  CAPA Report.doc   64.5KB   1141 downloads
•  Corrective Action Log.xls   30KB   1027 downloads

Edited by it_rains_inside, 23 October 2014 - 07:22 PM.

[tery]

Can you share a procedure that describes CAPA report and Corrective action LOG above?

 

Thank you

[teaks]

Hi Tery,

 

I recently created a CAPA database in MS Access.  I used a template (Desktop Issue Tracking) and customized it for CAPA - adding categories like HACCP deviation, labeling error, audit finding, etc.  That way I can run reports based on the type of problem, see what issues are open/closed, etc.

 

There is a built-in form for logging issues, and built-in reports.  It was not difficult to customize -- I'm no pro in Access for sure!

 

The attachment shows the log form I'm using as part of the database.  CAPA database.docx   185.65KB   1041 downloads

[gfdoucette07]

Here is an example of what I have created for a log.  I like it because I can sort by where the problem arose from, if they are still open or close and other possible options.  I enter all GMP audits, Program audits, customer audits, customer compliaints and so on.  Screen shots are taken and printed/emailed to those reponsible for completeion.  Follow up is then review at out business strategy meetings.  I have filled in example entries.

 

G

Attached Files

•  Corrective Action Log 2.xlsx   11.09KB   884 downloads

[Suzie B]

Hi Tery,

 

I recently created a CAPA database in MS Access.  I used a template (Desktop Issue Tracking) and customized it for CAPA - adding categories like HACCP deviation, labeling error, audit finding, etc.  That way I can run reports based on the type of problem, see what issues are open/closed, etc.

 

There is a built-in form for logging issues, and built-in reports.  It was not difficult to customize -- I'm no pro in Access for sure!

 

The attachment shows the log form I'm using as part of the database.CAPA database.docx

 

Thank you so much for this!  I love this format.  I'm going to give it a shot for my own database.  Do you print the form from the directly database?  Wish me luck.

[teaks]

Hi suzieq0112,

 

 

 

Thank you so much for this!  I love this format.  I'm going to give it a shot for my own database.  Do you print the form from the directly database?  Wish me luck.

I fill in the form electronically (haven't yet figured out how to print a blank form), then have different reports:  one for any issues that remain open, one for any issues that are closed, one for all issues, etc.

I used a pre-loaded template from Microsoft Access 2013 called "Desktop Issue Tracking," then customized from there, rather than building the entire thing from scratch. 

Good luck!

[Suzie B]

Hi suzieq0112,

 

I fill in the form electronically (haven't yet figured out how to print a blank form), then have different reports:  one for any issues that remain open, one for any issues that are closed, one for all issues, etc.

I used a pre-loaded template from Microsoft Access 2013 called "Desktop Issue Tracking," then customized from there, rather than building the entire thing from scratch. 

Good luck!

 

It's awesome if I can just figure out how to get started.  I've never built my own database, but I have managed plenty.  I might be smart enough to figure it out ;-)