How do I create a patient database wit demographic data in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 80 patients that I wish o form a database including their demgraphic
data, medication and illnesses, how can I perform this with access?
 
I have 80 patients that I wish o form a database including their demgraphic
data, medication and illnesses, how can I perform this with access?
Click to expand...

Preferably by hiring someone experienced in the complex and tangled
realm of HIPAA patient-records security requirements. Legal
experience, medical experience, and database development experience
are all highly recommended.

Short of that, you're asking about a project that would take quite a
few hours for a skilled developer. It's doable... but asking for the
entire database design is more than the "getting started" newsgroup
volunteers like me would usually tackle! That said, you'll need at
least the following tables:

Patients
PatientID, LastName, FirstName, contact information, ...
Diagnoses
<probably use defined insurance industry codes>
Medications
<you may be able to get a sample table from the Merck Index>
Procedures
if you want to track surgery, for example
PatientDiagnoses
Linked to Patients and Diagnoses to handle multiple illnesses
PatientID
DiagnosisCode
<date of first symptoms, date of diagnosis, severity, comments, ...>
PatientMedications
PatientID
MedicationID
Dosage
DoseSchedule
DateStarted
DateEnded
Visits?

Seriously - to do this right, and legally, is a pretty big project; if
you have the time and expertise to do it yourself, fine, but you may
want to consider getting a canned system or hiring it done.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Hello Anhedonia...
John Vinson is absolutely correct. It's a whole lotta work! I have been
using an Access database electronic medical records system I wrote about a
year ago. It is HIPPA compliant/secured and works pretty well. All my
encounters are paperless, all my Rxs either printed or faxed and it tracks
meds, PMH, PSH, demographics, etc. etc reasonably. I'm a physician and I
recently spent a solid week with a pro Access developer face-to-face in his
city to gain a foot up (and VBA coding) on version II, which I hope to take
to market.
BUT, if you have an interest, we could discuss this via email. I'd even
be interested in finding anoither "test site," if that interests you. I
have 3000 patients and I don't know that I'd spend the hundreds of hours
necessary for only 80 patients unless, like me, one happens to have the
"programming bug."
(e-mail address removed).
 
Back
Top