A Simple CA (Corrective Action) Database

M

mshell

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.
 
R

Randy Stewart

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

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:
 
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

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

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
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

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:

https://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:

https://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
 
Top Bottom