Work Order Management System

Customer Profile

Sector: Research
Industry: Business
Sales: $1 million

This information research firm offers custom knowledge services to help answer specific business, science and/or technology questions in the form of summarized reports. Their primary focus is to locate and make sense of the intelligence buried deep in large commercial databases, web sites, online scientific libraries, patent data, SEC and other government filings, market research reports and various sources of public information. Their clients range from Fortune 500 companies to individual consultants, laboratory scientists, market researchers and attorneys.

Business Situation

The company’s current system to track their customers and work orders featured data access pages that connected to a shared Microsoft Access back-end database. The system lacked in functionality, versatility and in ease-of-use. In addition, the response time their remote users were experiencing was unacceptable. The company also required enhancements to track billing calculation details. It was important that they maintain the querying and reporting functionality they had come to rely upon within Microsoft Access and that the system be internet based so that their staff could access the information quickly from anywhere at any time.

Solution

Work Order Management System

The web-based solution created by SQL Server Programmers enables the information research staff to easily connect and manage their customers, costs and work orders via the World Wide Web. Microsoft Active Server Pages on the .NET platform was used to design the new web browser-based application. Additional cost options and customized pricing was added in addition to capturing work order percent complete details. This additional information now allows management to monitor work orders more efficiently and produce billing quickly and accurately. In addition, remote staff members can now quickly connect to the database to perform their jobs just by using the web.

Specification Management System

The Wrigley Company is a recognized leader in the confectionery field…

Conference Registration

The organization is an international evangelical student organization…

  • 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.