Business Challenge:
A Virginia Drivers’ Education Company wanted to incept a web site that offered its course online. The site; however, had to abide by restrictions and guidelines set forth by the Virginia DMV. These included time minimums for chapter reading, dynamic quizzes that graded the quiz instantaneously in order to make the student re-read the chapter and re-take the quiz, and a simplified way to allow the owner to change the content including the complicated back-end test portion. Customized reporting on each user, final test qualifier and test site was also needed.

Business Challenge:
The ACC’s web site was not performing up to expectations and work that was contracted out, namely programming for credit card acceptance and database integration, was not working correctly. The staff was wasting hours, manually inputting transactions, and completing repetitive tasks. And the annual auditing experience was complicated by the web site under-performance, and subsequent documentation nightmare.

Web Emerse Solution:
Web Emerse automated the bill collection practices of the ACC. Credit card purchases were programmed to be instantly processed, and updated in the office database without administration or manual input. To save the ACC staff time, invoicing was automated, and clients were allowed to check, and pay account balances online.

To guard against future lapses an “email scraper” program was conceived to check the inbox (of order confirmations) against the database. To aid with auditing compliance a transaction match formula was incepted to help the staff document transactions to the auditor.

ACC also relied on our advice after internal circumstances forced 3 site transfers within 12 months from their internal office to outside shared hosting, dedicated hosting, and back again.

Business Challenge:
The NDA, which represents over 10,000 dentists worldwide, wanted to expand its contact and communication with current members, and expand its membership to further its mission without necessarily increasing the size of its staff. It felt its web site was out of date, and did not reflect the caliber of the organization nor the brand image it is trying to portray Many of NDA’s tools were also out of date and under performing. The old web site was also confusing to visitors and hard to navigate. They also needed guidance as to what to do about their ongoing hosting and maintenance. They had limited in-office technical staff and no guidance on technology issues.

Web Emerse Solution:
Web Emerse totally redesigned the NDA web site and in the meantime fixed all of the associated programming problems of the applications. Upon analysis Web Emerse specialists recognized the necessity for the NDA to upgrade their current database to allow for greater functionality and options. Henceforth; the NDA Access database was migrated to a MySQL database with expanded data collection and reporting capacities they needed to accomplish their objectives.

Normalized the database to remove duplicate tables
Cleaned up data to remove old, data like partial searches that had been saved.
Added support for multiple addresses and phone numbers
Added ability to easily run mail merge reports as opposed to the long process required in the past.
Added ability to support multiple users without having to copy access files multiple times
Removed need for new reports each year for year based data custom report work
Configured Access to serve as a report generation tool due to the low skill level of the NDA staff.