The commission that is granted the authority to monitor and review new and used automobile dealerships 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 who 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 replaced and upgraded several add-ins. In turn, we modified all tables, forms, and reports. While developing the solution, we recommended and were given the approval to separate the data. We made all recommendations based upon discovery, documentation, and design prior to development efforts.