Document Control for Databases

Hi Everyone,

I'm looking for some help / guidance on document control for recent excel databases I've introduced in my current work place. I have created a database for document control, training and also approved suppliers. My question is do these databases have to be given a document reference and still be controlled in the same way as paper based alternatives?. This becomes very messy with many updates throughout the year, does any one have any experience with auditors who have questioned or queried databases? 

The databases have been designed to help control documents within the business to avoid non conformance's come the BRC audit, which I can only assume would be welcomed by an auditor?

I'm a recent graduate and have only been working in the industry for a couple of years so please ignore my lack of knowledge. 

Thanks in advance.

This is how I do it.

I have an excel spreadsheet, which I have controlled as a FORM, with a version number. Don't confuse spreadsheets with databases

I type in my document control information. I don't change the form version , unless I'm changing the design of the form.

Caz x

Brilliant!!

That's the idea I've been playing around with but needed some reassurance it would be acceptable, many thanks. 

Rob

This is how I do it.

 

I have an excel spreadsheet, which I have controlled as a FORM, with a version number. Don't confuse spreadsheets with databases

 

I type in my document control information. I don't change the form version , unless I'm changing the design of the form.

 

Caz x

This is exactly how I control documents as well. 

Excellent. Thanks

I make a separate worksheet in Excel to track changes. This helps keep the actual content of the document from being cluttered.

And this is (generally) what the change log looks like for excel based documents. Someday, they'll all be EXACTLY the same...

And, this is pretty important to remember too:

 I don't change the form version , unless I'm changing the design of the form.

So, if I have to change something in the document updated it with new information I should keep the same version ... I'm confused now!

Barbara Serra

Hi Barbara

The form that you use to capture the data remains the same version, unless you make changes to its design

You wouldn't need to change the version number on this form every time you added information. It is in all essence a form

Caz x