tables for a chart

P

peljo

I want to build a chart for the movement of the blood pressue during the day
for a month,s period.I want to use the Access chart.Does anybody have an idea
how to build the tables for this curve? My idea is to have one table called
BP where to get the bllod pressrue values.This table will consist of BPID,
BPValue,and DayID, to be connected with another tables for the months.The
table months should consist of Dayid.
Am i on the right way,and does anybody has another suggestion for the
selection of the tables for this purpose.
For example :
9 oclock 140
11 oclock 160
14 oclokc 180
16 ocloc 135
Also is there any ready made example for medical charts where i can get an
idea?
 
D

Duane Hookom

It isn't clear whether you are keeping BPs for just one person or more?
Also, BPs usually have 2 values. Are you keeping both values? Apparently you
are doing these by times so you should store the date and time you take the
reading.

tblBPs
==================
PersonID
TakenDateTime
Systolic
Diastolic

If the table is for only one person, you could get rid of the PersonID. I
normally add an autonumber primary key field to all my tables.

If this is the only function you need to do, you might consider using Excel
rather than Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top