Case Studies

Case Studies


Case Studies


The Need:

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. 

The Solution:

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.

The Technology:

  • Microsoft Access
  • FMS tools
  • Microsoft SQL Server
  • Microsoft VBA
Since 1993, we've benefited from the trust, enthusiasm, and innovation of our partners. For small business and big business alike, we've provided out-of-the-box and custom Internet marketing solutions, as well as web-based, desktop, tablet, and phone applications—with all focused on results: increased revenue and cost-saving efficiency. Is it time to partner with Epoch Online?