View Poll Results: How does your department track assets
- 12. You may not vote on this poll
Pencil and Paper
We don't bother with it.
09-22-2010, 01:32 AM #1
- Join Date
- Sep 2010
Databases and Spreadsheets for Vol FDs
Having just retired from the military and joining a local volunteer FD I have discovered a lack of accountability and maintenance for equipment and personnel.
I have several spreadsheets and databases that I used to manage my Soldiers records for things such as Name, Address Info, Physicals, Training, and Equipment Assigned. I also used a database to log all gear they were assigned including serial numbers, who it was assigned to, maintenance schedules, etc.
Currently, our department has no accountability even for radios that were given out. We have people in our community that have had radios for several years but have never made a run in the same amount of time. We also have gear that is well over fifteen years old but is still in service.
In this tight economic times I am 100% for accountability. Not only does it make a department more efficient it also makes it safer.
I guess what I am asking the community is, "What do you guys use." Remember we are a small vol department in rural Ohio so we have zero funds to invest in this. I am really hoping that someone out there has something we can use. Thanks and I look forward to your input.
12-29-2010, 11:21 AM #2
I don't know if you ever created a database for this, but if you did, I would be very interested in seeing it. I am trying to build one, but as this is my first foray into Access, any assistance would be greatly appreciated.
12-29-2010, 11:34 AM #3
Think hierarchies of assets and set realistic goals about how granular you really want to make your asset tracking. (This applies to tracking things like training as well, BTW.) Don't forget that some assets will also want to be attached to (multiple) maintenance records.
All the time you spend up front designing your database and really determining what you want it to do will pay off in the end. Part of the process should be in determining what reports you want to get out of your database and making sure all the information needed to generate them is present in the system
Good luck!"Nemo Plus Voluptatis Quam Nos Habant"
The Code is more what you'd call "guidelines" than actual rules.
09-12-2012, 12:52 AM #4
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)