Case Studies
Project Profile for the Maternal Child Healthcare Database
Executive Summary
Company
The community wellness center has been providing healthcare to people in need for over 25 years.
Solution Description
The Microsoft Access Data Project along with SQL Server 2005 enabled the staff to efficiently track all of their maternal healthcare patients.
Benefits
Using SQL Server 2005 enables all staff to access the system via an internet connection. As a result, additional patient data can be tracked in a more efficient manner.
Software and Services
- Microsoft Access 2003
- Microsoft Access 2007
- SQL Server 2005
- Microsoft Windows XP
- Microsoft Windows Vista
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 sites. A new system was needed to solve these issues and to expand the system’s functionality and accessibility.
Solution
Maternal Child Healthcare Database
The alligatortek 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.