The commission that is granted the authority to monitor and review new and used automobile dealership for false and misleading advertising needed to upgrade the schema, forms, and reports within their " departmentally developed and grown" Microsoft Access database application..The commission used the database to maintain dealership and consumer related information including complaints and follow up details. They needed to add fields to several tables, modify the forms and, in turn, modify the related reports. The staff member that had developed the current solution had left the commission several years earlier.
We upgraded the Access database to a current version using FMS tools. We also had to replace and upgrade several add-ins. In turn, we modified all tables, forms and reports. While developing the solution, we recommend and was given the approval to separate the data . We made all recommendations based on discovery, documentation and design meeting prior to development efforts.