Access to SQL Server Database Migration
A logistics company had outgrown their Access-based system for data entry and reporting. A local company had the programming skills to handle the front-end development but needed assistance with the database. The new system used SQL Server and we created a more normalized database design to improve performance and reduce redundant information in the database. We also wrote the scripts to migrate the data from Access.
Web Form Calculator
A local eye care company needed a browser-based quote and invoicing system for a new product line.
For this solution, we used PHP to build a web form that refreshes when certain fields are modified and changes aspects of some fields depending on other options. For example, one field is read-only if some products are selected and the same field is editable if other products are selected. And these requirements are applied without the user having to keep hitting a submit button.
Results from the form are passed on to a report that generates a form for the customer to sign. Then the information is passed on to either a customer quote or an invoice.
This project is strictly PHP-based–a database was not necessary.
Web Site
A local IT business wanted a slick and easy to maintain site for its web presence. We built a Wordpress site using a customized theme and created copy and graphics.