Access database replaced with a web application
- The situation
A fire district tracks hoses, air packs, radios and other equipment in a desktop database on one office computer. Only one person can use it at a time. Crews at the other stations call the office to find out when an item is due for inspection.
- What was built
A web application that every station can open in a browser. Staff search and filter the equipment list, open an item to see its inspection history and record a new inspection. An overdue list shows each station what to inspect first and prints for the crew.
- The result
Before: one desktop database file with 2,672 inspection rows, including 23 duplicates.
334 equipment records and 2,646 inspections moved, 23 duplicate rows removed, counts matched.
- What the client received
The web application, the cleaned data, the program that moved it and a log that accounts for every record.
Try it Search the list, then record an inspection.
Describe your project and we will send you a fixed-price quote.