Posted By Steven John Nelson
Can anyone point me towards (or share) a simple peice of software - probably MS Access driven- which will:
1. help me to schedule & manage the inspection of premises (or anythng else for that matter)for the purposes of -among other things- (i) general safety or (ii) fire risk assessment etc etc
2. keep track of whether the inspection has ben done
3. record the [remedial] actions required as a result of the inspection
4. record the delivery (or not) of each [remeial] action

Posted By Jane Pack
Hi,

If you have Lotus notes & an able IT person I would recommend devleoping your database in Notes. At my previous company we started putting a database together in Access and it can work to a degree but at my current company we have been developing it using Notes and it is far more powerful. I am developing a EHSMS & database and incorporating the QMS to create an IMS (plenty of acronyms)and I can do so much with it.
So far IT has not disappointed in implementing what I want to achieve with it. As it is in notes you are able to make use of the email function so you can autoemail actions coming out assessment/investigations, autoemail reminders etc. We are also going to make it available to all employees and the security is dictated by their email addresses.
Through using crystal reports we are able to produce report based on the information in the database.
I've not looked at any commercially available packages so I can't comment on how good or bad they are.

I hope you find this useful.

Regards,
Jane