The Department of Public health and Wellness needed a way to automate gathering and management of data related to the Childhood Lead Poisoning Prevention Program. The need was to track information through the process of Blood Lead Testing, Follow Up Testing, referrals to other professionals, Home Visits, and more. In addition they needed reports that would display Blood Lead tests inputted into the system the day before, their activities, and the status of individuals moving through the evaluation and treatment process.
I created a Microsoft Access front end and SQL Server back end database application to do the job. In addition I used Microsoft SQL Server reporting Services to meet their reporting needs.
This database application is now used as a reference by the Commonwealth of Kentucky.