Hi,

My wife is a lactation consultant and needs to keep records of her professional activity. There are commercial software packages for this, but they are usually expensive and designed for offices with many workers.
So I thought to design it myself in Microsoft Access, and wanted some advice.

My main question is whether there is a rough template of what I'm trying to do so I don't have to reinvent the wheel.

The main tasks required for the database:
1. Enter new client information
2. Update client data (weight, etc.) on each visit
3. Write treatment summaries, diagnosis, work plan
4. Keep record of visits, phone calls
5. Billing
6. Expenses
7. Generate reports for doctors

The tables I thought of creating are:
1. Client
2. Events: Visit, phone call, weight measurement
3. Money movement

Any help would be appreciated.
Omri

I was looking for the same thing! (I'm a breastfeeding educator.) I've got some ideas on what I want, just not sure how to go about it. Maybe we could find a medical client template somewhere we can tweak?

I didn't find exactly what I wanted yet, but I have a much better idea of what is needed. Any further ideas or a candidate for something to customize would be greatly appreciated!

I think the key difference between a lactation EMR and a standard EMR is the mother-baby dyad. You want to be able to link a mother to her babies in a smooth way, and there are things you will only check in the mother and others you will only check in the baby.

My current thought about entities is:
1. Moms
2. Babies
3. Inventory
4. Measurements (separate mom/baby???)
4a. Measurement type
5. Encounter - mom+baby+billing
5a. Encounter type: home, phone, email
6. Providers (to send referrals for doctors)


A few useful (?) links:
Creating a simple electronic medical record through Access
Request: Miscellaneous | Linking mothers and babies for lactation
OpenEMR 4.1 Users Guide - OpenEMR Project Wiki
OneNote EMR
EMR Database Design - emrupdate.com