Administration staff designed a central filing system to track every file folder within every department, including fire and public works. New files are continually created while old files need purging. By law, certain files must be destroyed after a specific period of time: some have a life of only two years, four years, or seven years, while others are permanently available.

Challenge: Work with an existing database to streamline data entry and retrieval. Create reports to accurately reflect the exact status of each file.

Solution: Add functionality and components to simplify data entry and procedures and to create reports that provide reminders and directions for file tracking and destruction handling.