Production Database System

Customer Profile

Sector: Museum
Industry: Horticulture

The botanical museum is managed by the Chicago Horticultural Society and is a 385-acre living plant museum featuring 23 distinct display gardens surrounded by lakes as well as a prairie and woodlands. The museum opened to the public in 1972 and offers a broad array of adult classes in plant science, landscape design and gardening arts.

Business Situation

The museum was using dBaseIII to track the progress of their plants from propagation to production. The database was out of date and was lacking in functionality, versatility and ease of use.Day to day operation was becoming inefficient and unorganized. Only one person could work on a specific record in the database at a time, preventing the staff from using their time efficiently. In addition, there was a need to expand functionality and reporting capabilities to reduce duplication of effort by staff members and provide the growers with up to date information they needed to perform their jobs. It was important that the application is user-friendly and intuitive while providing users quick and easy access to the information they needed.

Solution

Production Database System

SQL Server Programmers was selected to develop a customized solution that would help the museum replace its outdated dBaseIII database. The solution was a relational database application that can now be accessed by multiple users simultaneously in different departments. SQL Server 2000 was selected as the database platform with Microsoft Access 2003 as the front-end platform. The museum employees and volunteers now have simultaneous quick and easy access to plant production specifications and are able to perform their jobs more accurately and more efficiently.

Pallet Production System

The company is a manufacturer and distributor of quality wood pallets…

Dealer Reserve System

Illiana Financial is a cooperative financial institution with $154 mi…

Legal Fee Audit System

The Legal Bill Review and Legal Fee Auditing Group reviews legal fee …

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