Client Management System – Social Welfare Association

Industry: Non-Profits, Associations and Organizations
Solution: Client Management System
Technologies: Microsoft Access
Solution Type: Custom Database Application

social welfare association logo
The social welfare association was formed over 100 years ago. The organization serves over 60,000 people at over 50 sites. The social welfare association improves social conditions for underserved people by providing creative, innovative programs and working for public policy reforms.

Challenge Challenge - Mountain without Flag

The association was growing and required a system to more efficiently manage their clients. Their current method of managing clients was very time consuming and didn’t capture all of the necessary information. A new electronic system was needed to enable the association to efficiently capture additional information about their clients.

Solution Solution - Mountain with Flag

The Microsoft Access application enabled the association to efficiently and effectively track their clients. The association is able to easily provide the figures needed to apply for grants and other funding sources.
The Client Management System was developed using Microsoft Access. It provided the association with an efficient means to capture the necessary client information. Data such as gender, age, demographics, education levels, needs assessment, abuse history, and legal history is captured.
The system provides several reports which assist management to make better decisions. For example, the Staff Report provides summary and detail level figures on staff productivity. Other reports provide summarized figures on the types of demographics which the association serves.
Additional Reporting Developed
The association contacted alligatortek a few years after the initial system was delivered. New funding was now available to the association. However, in order to get the additional funding, more information about the clientele served was needed. As a result, the association needed additional information captured so that enhanced reports could be produced to assist in the funding application process. The system now provides reporting on clientele grouped in various ways. This enhanced reporting now provides the funding sources with all the information they require to allocate future grants.

latest news


How to Use ADFS to Implement Single Sign-On for an ASP.NET MVC Application

Without using any complex code logic, I leveraged Microsoft’s Single Sign-On (SSO) on my existing ASP.NET MVC web application.


10 Ways to Save Money By Hosting On Microsoft Azure

Many companies move to the Cloud to lower costs and offload the management of their IT infrastructure. Once you create resources in the Cloud, there is still more work to do. By considering the list below, you can ensure you are getting the performance you need while keeping your monthly spend in check.


Is AI Making Me Lazy?

Over the course of the last month, I logged the different ways my family used AI-powered devices in my home. Does artificial intelligence mean I can't think for myself? Read what I think in my latest blog – Nate Pave.

Copyright © 2018 alligatortek. All rights reserved.