MedicineIntakeMonitor.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 08 Jul 2008 at 10:29pm |
This sample db demonstrates monitoring of actual intake by patients against the course of various medicines prescribed by respective doctors. For a given patient, the subform at top displays the medicine courses as prescribed by the doctors. It includes the name of medicine, name of doctor, date of prescription, duration (days) and doses (number of times per day). There is a field for doctor's notes as well. The other subform displays a grid of shadow new records for each dose on each day of the prescribed course for each medicine. To confirm intake of a particular dose of given medicine, the user clicks in a check box named Done. The date and time for such confirmation gets automatically inserted in field named DtStamp. As soon as the user clicks the Done check box, the current shadow record gets converted into an actual record in table T_MedTrack. This way, there is no redundant addition to records, till confirmatory action is actually implemented. Also, if the user attempts to click the check box for any of the future dates (i.e. beyond today's date), a friendly message preventing such an entry comes up. As added convenience, highlighting has been provided as follows: (a) When the user is on any record in the compliance subform (the lower one), corresponding record in prescription subform (the upper one) gets highlighted in yellow. This way, the user can readily see the doctor's and other particulars relevant to the current dose of current medicine. (b) When compliance for a given dose is confirmed and the date stamp matches due date, the record gets highlighted in light blue if the due date is same as today's date. Later, when this due date becomes older than current day's date, the highlight color for such a record changes to orange. (c) Records where compliance date stamp does not match the due date, are highlighted in pink. (d) Records older than current day's date, where compliance has not been confirmed (via selection of check box), are also highlighted in pink. The sample includes report generation for the selected settings, providing compliance status for various prescriptions. Records where compliance is missing or delayed beyond due date, are highlighted in color. Summary of the incidence of missed or delayed compliance is given in the group footer. Version: Access 2K/XP/2K3/2K7 (Access 2000 File Format)
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |