At my new job I am revamping my HACCP risk assessment. To make my life easier I made an Access database for it so I can easily add and change things.
Because I see a lot of questions about risk assessments here on the forum I thought, why not make an template for others as well.
Now that my database is Alpha stage I would like someone who has some knowledge of Access to take a look at it and maybe have some advice to improve.
Now something about the database itself; the theory behind the database is based on a much used system in the Netherlands and approved by over 50 audits at my previous job.
· Per process step list all possible hazards (even the ones that are PRP’s)
· Determine the chance and effect of the possible hazard
· If there is an significant risk apply an extra control measure
· Use the decision tree to determine if the control measure stays a PRP or will needs to be a CCP
This is not very spectacular but why my database is easy to is the following, a potential hazard (and a control measure) can occur at several process steps so I created a separate database with hazards in this database per hazard you note the following:
· What the potential hazard is
· The category
· The chance of occurrence
· The motivation for the chance occurrence
· The effect on the public health
· The motivation for the effect
· And the risk
So when something changes, say like new studies show that Salmonella is not lethal anymore (sorry could not come up with an realistic example) you just need to change it in the hazard overview and at all process steps this will change. (the control measures work the same)
This makes yearly reviews of the HACCP plan a lot easier.
Furthermore let say you have had an audit and a the audit wants you to add a new hazard for 5 different process steps, you can instantly add these hazards without a problem.
So if this has peaked you interest and you have some experience with MS Access, leave a message down below and I will send you an PM when the database is ready for its first test, probably next week.