Estimate and Invoice System

Customer Profile

Sector: Construction
Industry: Building Materials

The company specializes in custom stone work for both residential and commercial construction. They offer over 100 natural stone products and their work is hand crafted or machine cut by talented stone cutting experts.

Business Situation

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 the Windows XP operating system. The FoxPro database was critical to their operations; however it would not work on the new Windows XP platform. The system needed to be re-written on a contemporary database platform.

Solution

Estimate and Invoicing System

The system developed by SQL Server Programmers was specifically designed to work very similar to the FoxPro system. The new system was readily accepted by the company’s employees since the two systems were very similar. Employees were able to use the new system immediately with minimal re-training.

The company required the database 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 2005 database platform. The system provides the power and scalability of SQL Server with the cost effectiveness of developing on the Microsoft Access 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.

Healthcare Database

The community wellness center is a not-for profit community health ce…

Customer Broker Database

The developer is an urban real estate development company. They striv…

Title Management Database

The book supplier is a full service resource for customers. The compa…

  • Large Manufacturing Plant

    Open quoteEvery major project has gone live by the desired target date, and runs problem-free.Close quote

    - Vice President

  • Plant Museum

    Open quoteSQL Programmers upgraded our Plant Records database and Plant Production database. The new systems provide access to a scalable, reliable and user-friendly system for any user within our networks.Close quote

    - Director of Information Systems

  • A Regional Philanthropy Foundation

    Open quoteYou continually translate our business needs into successful projects within budget. Thank you!Close quote

    - Manager of Information Technology

  • A Meat Distributor

    Open quoteSQL Programmers did an outstanding job translating our needs and wants into a workable program. After the development, we have been very pleased with the support. We are currently working on Phase Two!Close quote

    - Operations and Process Support

About us

SQL Server Programmers is a database consulting firm specializing in Microsoft technologies. For over twenty years, we have assisted hundreds of companies nationwide. Our staff has extensive experience working in various industries to develop systems that manage business information. We develop desktop database solutions and integrate these solutions with the web to create data-driven websites. Our firm is a Microsoft Certified Partner, and our developers are Microsoft Certified Professionals.