Estimate and Invoice System – A Stone Supplier
Solution: Estimate and Invoice System
Technologies: SQL Server, Microsoft Access
Solution Type: Custom Database Application
The company is a family-owned stone construction company located in Lansing, IL. The supplier has been in business for over 45 years, and specializes in custom stonework for both residential and commercial construction. The company offers over 100 natural stone products. Its work is handcrafted or machine-cut by talented stone-cutting experts.
The company was using a DOS-based FoxPro database for creating estimates and invoices. They needed to replace their outdated computer equipment by purchasing new computers with an updated Windows operating system.
The FoxPro database was critical to their operations; however it would not work on the new Windows platform. The system needed to be re-written on a contemporary database platform.
The Microsoft Access application developed by alligatortek is used for generating estimates, invoices and reports. The system was specifically designed to work very similar to the FoxPro system. Employees were able to use the new system immediately with minimal re-training.
The company required the database to be robust and able to handle a large amount of transactions. A Microsoft Access Data Project was selected as the front-end platform that would connect to the robust SQL Server database platform.
The system was designed to handle invoice payments so customer receivables can be easily tracked and managed along with their invoices. The system also features robust reporting functionality that provides the company the information they need in order to manage their accounting books.
How to Use ADFS to Implement Single Sign-On for an ASP.NET MVC Application
Without using any complex code logic, I leveraged Microsoft’s Single Sign-On (SSO) on my existing ASP.NET MVC web application.
10 Ways to Save Money By Hosting On Microsoft Azure
Many companies move to the Cloud to lower costs and offload the management of their IT infrastructure. Once you create resources in the Cloud, there is still more work to do. By considering the list below, you can ensure you are getting the performance you need while keeping your monthly spend in check.