Hello all, I recently found these videos and website for MS Access and am excited to get started. I used Access YEARS AGO (like 20 or so) and trying to get back into it.  So far, I've successfully built several tables, queries and forms to get the bulk of what I want done, but now I'm stuck as to where to go from here.  

Here's my question...I work for a fire department that has to test our air packs on an annual basis.  We have about 150 packs that need preventative maintenance and testing done on them by an outside company.  So for a week in April, we have to track down every pack and give them to the testing company to inspect/repair/test.  I'd like to create a way to manage this operation during that week.  Right now we use a sheet of paper that has every pack listed on it and as they get tested, we just check them off.  My question is what is the best way to accomplish this? In my head I see a method where when a pack is completed, I search for it in the database, find the record and then hit a button that automatically puts in the information that that pack was tested for this current year.  I have already built the associated tables and forms similar to the vehicle maintenance video that keeps track of any repairs made outside of the annual service.  So, when a button is pushed, it would add a line in that pack's service history that said "Annual Service complete" with the date.  Along with that, I'd like a report that could be generated that showed all of the packs that still need to be located and tested.
I hope that all makes sense, but if not, I'd be happy to try to explain it further.  Thanks so much for everyone's time and thanks to Richard for making all of those great video's!!