I have minimal experience in using a few existing Access databases, and no experience in building them. However, I have taken on a task at work and I think Access database would be the best solution.
I need a system to track lock outs and tag outs in an industrial plant. It's a system of hanging a tag and locking device to prevent operation of equipment like valves, breakers, pumps, motors, etc... to ensure personnel and equipment safety during maintenance.
What I want to build is a database that has every component in the plant with it's associated information already stored. Then when an item needs to be tagged, you can just populate all the info in the tagout form from the database. I would also need some kind of cross check to see if that same item is already tagged out on a different work order.
I could go on about the details but I'm really only looking for a good starting point here. I know it's going to be a lot of work. I just want some expert advice on getting started. Also, if you know of a similarly set up database (even if it's purpose is different) I'd like to have some kind of template to go off of that I could modify.
Thanks in advance!