I am the mental health coordinator at a jail and I need a database to track inmates.
Everyday I recieve 2 lists. A list of new inmates admitted to the jail and a list of inmates with requests to be seen in sick call.
Inmates can be routed 2 ways from booking. First is routed to me to see them and for me to decide if they need to see the psychiatrist.
The second is straight to the psychiatrist. Sick calls have 3 possible routes, first is to me. Second is to the psychiatrist and third is if the sick call request is just for information and is just answered.
I need to be able to create a list with my appointments
I need to create a list for the drs appointments
I need to be able to track an inmate and there sick calls for each admission
I also need to be able to track all appointments an inmate has with the psychiatrist and to store a diagnosis and list of current medicines
I also need inmates that are seen by the psychiatrist to be automatically rescheduled to see The psychiatrist again in 11 weeks for a follow up appointment
I need to be able also to mark an inmate as released from jail and not have them come up on the appointment lists (I need to be able to access old records from previous admissions)
I need to be able to list inmates with specific diagnosis
I need to be able to list inmates by what mediCine they are on
I need to be able to keep track of the numbers of inmates seen by myself and the psychiatrist by month and whether they were new inmates or follow ups
10 freelancers are bidding on average $17/hour for this job
Hello, I have 12+ years experience developing MS Access applications and feel confident that I could do this project for you. Please view my portfolio for some examples of my work. Thank you.
Creating a completely Normalized Database with proper Data validation using VBA - custom built functions to meet business needs. Will be splitting the work on a minimum 5 day basis.
Hi, We are Pune (India) based firm working since 1996. We are a team and we will complete your work in time. We provide online support for software and customer satisfaction is our goal. Please check PMB. Thanks