Medical Chart Database

Mar 7, 2008

I am a doctor with a knoledge of computer greater than most of doctor. Even though i use a company for part of my office managment, i would like to develop a small database as a project, that can save my patient charts and i though that microsft access should work for this (please correct me if i am wrong, and also let me clarify that i have not use access),

This is what i want, when i dictate a patient chart i do it on a word document template, if i take pictures i save them as jpeg in zoombrowser, and other material is safe as pdf in paperport. Would it be possible to develop a database that will combine this on for example a record called Peter smith # 1234, and when i find this patient, it will have folders like chart, photos, bills, etc

Your hlelp will be very greatly appeciated

Thanks

Rafael :)

View Replies

Forms :: Database For Medical Facility - Admit And Discharge Radio Buttons

Apr 18, 2015

I have been writing a database for a medical facility. Currently, I have a box to check if a patient in the database is admitted. What I would like to do is create two radio buttons: one to admit and one to discharge.

When the patient is discharged, I want the data in some of the fields on the form(s) to clear, but not all the fields.

I realize the I will need some scripting here.

As an example: the fields for Unit and Room number will clear upon discharge. As well as fields for diagnosis and informed consent signature located on another form within the same table.

View 3 Replies View Related

Forms :: How To Display Next Medical Due On A Subform

Jul 24, 2014

I have a form call "frmemployee" that holds employee's details. I have page tabs with sub forms on and the one I'm now concentrating on now at the moment is a Sub form called "medical Sub form" this holds data regarding the last medical the employee has had on continuous form e.g. MedicalDate ,Doctor , Place

now what I'm trying to do is find last medical date for the employee selected and add +730 days to show next medical date in text box on the footer of the subform

I have a sample with bubble speech show what I'm try to do

medical Test For Shane1.zip

View 3 Replies View Related

How To Create A Template For A Medical Practice

Oct 26, 2012

I am just wondering if theres a way I can create a customise database for my workplace. We are looking at replacing the old record cards that sit on the desk that records each clients visit and the price they paid. We do use MYOB for all our accounting etc but we are wondering if there is a way that we can create a database that enables us to record the date and price paid for each visit for every individual client?

View 4 Replies View Related

Reports :: One Chart For Each Team In Database

Nov 11, 2013

What I'm doing wrong with the chart in the attached DB? I need just one chart for each team but I'm getting 5 times as many charts as I want.

I'm using Access 2010 on Windows 7 & Vista

View 3 Replies View Related

Forms :: Show Multiple Records In A Medical Form

Apr 11, 2013

I work at a small mental health clinic and am trying to accomplish the following.

What I have:I have one table that lists all of the patients, their phone number, address, etc.

In another table, it lists the medications that each patient takes, as well as the strength, dosage, etc.

The two tables have a relationship via the "Patient ID" column in each table.

Most patients have multiple entries in the second table, as most patients take multiple medications.

What I am attempting to accomplish:The main form in my database simply lists all the patients names in datasheet view. I want to be able to click a Patient's name, then go to a form that lists all of that patients medications. I've attached a screenshot that encapsulates precisely what I am looking to accomplish.

Since most patients take multiple medications, I need to be able to list multiple records in a single form, grouped by medication name, just like in the attached image.

I am uncertain as to how to accomplish this. I've tried using subforms but it doesn't list the data at all? Also, it looks like an Access report can create precisely what I need, but I need to have a live form that I can use to update data real-time.

View 8 Replies View Related

General :: Tracking Patients Medical Tests Then Alerts When It Is Overdue

Apr 8, 2015

I have been asked to create a access data base (using 2007) on tracking patients medical tests that then alerts you when it is overdue set against a scale:

Physical Test - age 20-39 - every 3 years - Male and Female
Physical Test - age 40-49 - every 2 years - Male and Female
Physical Test - age 50+ - every 1 years - Male and Female
PAP Test - 20+ - every 3 years - Female

There is about 10 of these tests like this and then tests specifically for Cancer type patients.

I figured out one way by creating a table with each column being a test but this didn't really work as I need to keep a record of each time they come in and the test is done and then it spits out the next reoccurring test from that date.

I then will need to make a report created from this that alerts on everybody who is overdue to not gotten any of the tests by category.

I then thought okay I will create a table that has the fields as ready something that this is better and to append the records to another form:

Illness - Pulling from tables of Illness
Test - Pulling from table of Tests
AgeGrp - multi-field, referenced from Table of Patients
Gender - Multi-field, pulling from the Table of Patients
Frequency - pulling from table of frequencies with amount of days to calculate

I did this and now I can't figure out anything past this point and how to link all this data up so the right information pops out.

Or is there a better way of going about this.

View 3 Replies View Related

Can Form UseMicrosoft Excel Chart Instead Of Microsoft Chart Wizard

Mar 22, 2006

Hi all,

I'm trying to create a chart in a form, this is not a problem, however, the chart types available are a bit limited compared to if i inserted a Microsoft Excel Chart object.

I'd do that except I'm trying to create a chart based on a query.

Is there a way to make the chart wizard use the Microsoft Excel Chart object as its chart creator so I have access to the chart types available in that object?

any assistance much appreciated.

thanks all.

regards

keji