Hello,
My name is Christopher. I am a fire fighter here in Texas and I have been put in charge of our PPE maintenance program. This consists of monthly routine and yearly advanced inspections for our bunkers (coat, trousers, helmet, gloves, hood, and boots). I need to maintain records for 20 years for all of these items for our fire department.
I started out five years ago saving a hard copy of these forms. Within three years I had several 5" binders and knew I couldn't continue that way. I moved to storing my forms on Word documents with an Excel form containing the equipment serial numbers and important data linked to each inspection. This way of storing the data isn't the best for my hard drive but it works. The only thing I would really like is the ability to extract good information from it and for it to be less tedious to maintain.
I have watched a few hours of videos learning the ins and outs of Access but as I was trying to learn how to make a checklist I realized I was in way over my head. Although, I was able to follow along somewhat I was unable to accomplish what Mr. Hine was teaching. https://youtu.be/r1y_Zl3uLkM
I also found some help on this forum here, here and here.
If you have read this far, thanks. My question is this: Is there an easy way to do this? I am a quick learner but I guess I just need some direction. Thanks for your time.