scampbell70
Registered User.
- Local time
- Today, 13:15
- Joined
- Jul 15, 2017
- Messages
- 15
Hello, I am brand new to access, but I am not new to the world of computers. I work for a mental health agency that operates a treatment program within a jail and we need a way to track patients, outcomes, etc. I have only worked for this agency about a month and prior to that, they were trying to track over 300 patients in an excel spreadsheet with a few columns. Needless to say that when the jail's director came to ask about anything it takes 2 people half the way to put the information in a report and half the time the numbers are wrong due to human error. As a result, I am trying to build a database that will allow me to run reports that will tell me things such as
1. How many patients are active in the program
2. How many are on a waiting list to get into the program
3. How many graduated successfully
I will also need to be able to run reports that show
County the conviction was in
Court System the patient is involved with
Name of the Judge
Patients incarcerate by that Judge
and that has to be further broken down to show a list of active by that judge, on the waiting list for only that judge, etc.
I am including a photo of the tables and their structures. I know this is not going to be an easy project but our budget is zero and I am tired of spending half a day looking up this stuff, so I am willing to invest as much time as it takes to learn how to do it. I have watched several udemy videos, and lynda.com courses but I have no idea if I am laying these tables out correctly or if I am setting myself up for a disaster as soon as I try to enter 300 patients into it.
Thank you for any help and assistance I am able to get.
1. How many patients are active in the program
2. How many are on a waiting list to get into the program
3. How many graduated successfully
I will also need to be able to run reports that show
County the conviction was in
Court System the patient is involved with
Name of the Judge
Patients incarcerate by that Judge
and that has to be further broken down to show a list of active by that judge, on the waiting list for only that judge, etc.
I am including a photo of the tables and their structures. I know this is not going to be an easy project but our budget is zero and I am tired of spending half a day looking up this stuff, so I am willing to invest as much time as it takes to learn how to do it. I have watched several udemy videos, and lynda.com courses but I have no idea if I am laying these tables out correctly or if I am setting myself up for a disaster as soon as I try to enter 300 patients into it.
Thank you for any help and assistance I am able to get.