Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012

    Help designing private practice database


    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.

  2. #2
    Join Date
    Feb 2012
    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?

  3. #3
    Join Date
    Jan 2012

    Some ideas and links

    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 -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts