Donor Tracking System – A Disease Research Foundation

Industry: Non-Profits, Associations and Organizations; Healthcare
Solution: Donor Tracking System
Technologies: Microsoft Access
Solution Type: Custom Database Application

disease research foundation logo

The disease research foundation is a non-profit corporation based in Chicago, IL, which provides leadership and  resources to find a cure for an incurable disease. The foundation collaborates with researchers in the United  States, Mexico, and Europe.

Challenge Challenge - Mountain without Flag

The foundation was using its Donor Tracking System on a Microsoft Access platform to manage all of the  donors and donations made to the foundation. The system satisfied the foundation’s needs for a few years until the foundation grew and the volume of donors increased significantly. When the number of donors increased, their staff had a substantial amount of additional work to perform. The foundation required that the tracking system be updated with additional functionality to handle their increased workload.

In order to create reports, users would have to export data from the Access database to Excel and then sort and select the data within Excel. For example, to send out thank you letters to donors, users would have to export data to Excel, delete the records that didn’t apply to the letter being sent, and then manually run a mail merge.  This example is only one of many that made performing daily operations very time consuming.

Solution Solution - Mountain with Flag

The system designed by alligatortek enabled their staff to work more efficiently and effectively through a  variety of features. The number of steps involved was reduced to merely entering donors along with their  donation amounts. This allowed the users to quickly generate reports with the exact information they needed.

Furthermore, users could now automatically generate several different letters quickly and accurately while  being able to select the proper recipients. This enabled the foundation to provide outstanding customer service and to keep in touch with their donors.

As the alligatortek team worked to update the system, several system errors were discovered and eliminated.  reviously while performing normal tasks, users would receive processing errors. These errors were eliminated which resulted in less frustration for the user along with error free processing.

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.