I am working on a volunteer project to improve the process used administer and track medications prescribed to youths at a local non-profit agency. There are 100+ patient/residents living various group homes spread over a large urban campus. Meds are prescribed by a doctor, ordered and tracked by a team of nurses and administered by residential staff. They currently use a very labor intensive/hard copy process to manage and document the process. They are badly in need of a modern relational database to streamline their process. They need to account for each pill from the time it is received from a pharmacy until it is given to a patient. They have a detailed "signoff system" to docuement/verify each time a pill is given. Many psychotropic controlled substances are administered. There are a lot of monthly reports required by various regulatory agencies.
I have some previous experience desigining and implementing MS Access databases but I am by no means an expert. I have good idea (see below) how to structure the database but I would rather not start from scratch if there is an existing Access database out there could be modifided to fit our needs. Below is a list of tables that I found in another thread (My thanks to"recyan") in this forum. It is pretty close (but not everthing) to what I envision needing.
tblPatients - Master Table of Patients
PatientID - PK
.......
tblConditions - Master Table of standardized List of Conditions
ConditionID - PK
.......
tblMedications - Master Table of standardized List of Medications
MedicationID - PK
.......
tblDoctors - Master Table of Doctors
DoctorID - PK
.......
tblPatientsConditions
PatientsConditionsID - PK
Patient_ID - FK
Condition_ID - FK
tblPatientsConditionsTreatment
PatientsConditionsTreatmentID - PK
TreatmentDateTime
PatientsConditions_ID - FK
Medication_ID - FK
MedicationDosage
NextCheckUpDate
Doctor_ID - FK
If anyone has or knows of a such a database that I could copy and modify, please let me know.
Thanks
Greg