Over time, our client had built multiple Access databases for their Pesticide Licensing Compliance System. The Access database handled different features of licensing manufacturers, distributors, and applicators for pesticides. From training to licensing fees to recertifications, four databases were created and became unmanageable. The Pesticide Licensing Compliance software generated licenses for those who passed the courses, class scheduling, rosters, grading, printed certifications, rejections, failures as well as lists of manufacturers that made or stored chemicals.
A custom Access database solution was needed to track all aspects of licensing individuals in the state who handled pesticides in any way, shape, or form.
Merge four existing databases with duplicate information into one centralized and easy-to-use system. The Pesticide Licensing Compliance system needed to track all aspects of licensing individuals, manufacturers, and distributors in the state who handled pesticides.
Working with this client for many years, we knew the project required a clear understanding of the process of pesticide licensing and management. Phoenix stepped up, accurately merged the data with zero data loss. We built a robust Microsoft Access database front end that tied to a security-laden SQL Server back end database. We enhanced the licensing compliance software by streamlining and automating processes, instituting notifications to the management of problem areas, and refining the interface to eliminate nonfunctional data. Payments and renewal fee accounting were added to the system to provide for a single application to manage the various facets of the Pesticide Licensing Compliance program.
State Government – 15+ staff