Maternal Child Healthcare Database

Customer Profile

Sector: Healthcare
Industry: Non-Profit Services

The community wellness center is a not-for profit community health center network whose mission is to improve health outcomes for the medically underserved community through the provision of high quality, affordable, and accessible primary health care and support services. Their medical centers serve the needs of men, women, and children while specializing in maternal and child health services.

Business Situation

The organization was using a Microsoft Access database to track their maternal healthcare patients. The database had evolved over time and was in need of re-organization. Tracking patients had become very time-consuming and inefficient. The design of the database no longer met the organization’s needs and the system was not accessible to all of the organization’s locations. A new system was needed to solve these issues and to expand the system’s functionality and accessibility.

Solution

Maternal Child Healthcare Database

The SQL Server Programmers team developed a new system utilizing an Access Data Project which relies on Microsoft Access for entering and reporting information and SQL Server 2005 to store the data. This platform enabled the development of a system that was cost effective while able to utilize the power and scalability of a SQL Server database.

Reorganization of Data Tables

With the exception of additional fields, most of the same information that was captured in the original system was needed in the new system. A major issue with the original system was that the data tables were only able to track one child per mother. Tracking mothers with multiple children became inefficient and made reporting difficult. The new system featured updated tables and new fields that allowed the tracking of multiple children per mother.

Access to All Staff

All staff and locations can now have access to the system. The use of SQL Server 2005 along with an internet connection enables all locations and staff access to the system and their patient’s medical records.

Production Database System

The botanical museum is managed by the Chicago Horticultural Society …

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…

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