Can access 2007 do what I need?

  • Thread starter Thread starter JRD
  • Start date Start date
J

JRD

I would be grateful for some help!

I need to create a program that can calculate a score based on data entered
by the user.

The user will need to enter data from patients with coronary disease.

The first question will be "how many coronary narrowings are present"

Then there will need to be a series of questions for each coronary narrowing.

So if there are 3 narrowings, then the program will need to go through a
series of "sub-questions" for each coronary narrowing. when it has finished
the questions on the 1st narrowing, then it will ask the same sub questions
for the 2nd narrowing and then the 3rd.

At the end it will need to calculate a score based on the answers to the
questions.

For example

Question 1: How many narrowings are there? Answer 2

Narrowing 1:

Question 1.1: Which artery does it affect. Answer: Left coronary

Question 1.2: IS the narrowing causing more that 90% blockage. Answer: Yes

Narrowing 2:

Question 2.1: Which artery does it affect. Answer: Right coronary

Question 2.2: IS the narrowing causing more that 90% blockage. Answer: No




Score calculation:

If Question 1.1 = L coronary then multiply by score by 5
If Question 1.1 - Right coronary then multiply score by 3

If Question 1.2 = Yes then score 5, If = No then score 2

Based on the calculation algorithm the score for narrowing 1 would be 5x5=25
and for narrowing 2 would be 3x2=6

Can anyone tell me whether access 2007 can deal with this sort of problem.
If so, how best do I get started, if not which program can I use?

Many thanks

JD
 
I would be grateful for some help!

I need to create a program that can calculate a score based on data entered
by the user.

The user will need to enter data from patients with coronary disease.

The first question will be "how many coronary narrowings are present"

Then there will need to be a series of questions for each coronary narrowing.

So if there are 3 narrowings, then the program will need to go through a
series of "sub-questions" for each coronary narrowing. when it has finished
the questions on the 1st narrowing, then it will ask the same sub questions
for the 2nd narrowing and then the 3rd.

At the end it will need to calculate a score based on the answers to the
questions.

For example

Question 1: How many narrowings are there? Answer 2

Narrowing 1:

Question 1.1: Which artery does it affect. Answer: Left coronary

Question 1.2: IS the narrowing causing more that 90% blockage. Answer: Yes

Narrowing 2:

Question 2.1: Which artery does it affect. Answer: Right coronary

Question 2.2: IS the narrowing causing more that 90% blockage. Answer: No

Score calculation:

If Question 1.1 = L coronary then multiply by score by 5
If Question 1.1 - Right coronary then multiply score by 3

If Question 1.2 = Yes then score 5, If = No then score 2

Based on the calculation algorithm the score for narrowing 1 would be 5x5=25
and for narrowing 2 would be 3x2=6

Can anyone tell me whether access 2007 can deal with this sort of problem..
If so, how best do I get started, if not which program can I use?

Many thanks

JD
Click to expand...

Hi,

Sure you can do it using Access if you know how. :)

I think the best way to do it is to have a table with answers related
to patient. When user say there are 2 narrowings, write 2 records into
this table with patient ID.

Now all you need to do is to run form filtered to the patient ID and
the form will show 2 records. You will need to design the form to
contain 2 questions/answers per record. It is up to you how you will
lead/force user to go from record one to last record (that is record 2
in this case), to make sure that user provide all answers.

When both questions for both records are answered, you can run
calculation. No need to store result of calculation in DB as you can
always re-calculate it for reporting purposes.

However, this program will require advanced Access programing
knowledge; depending on design, how to deploy queries and/or VBA
program, but still I think the Access is the easiest program to do it.

Regards,
Branislav Mihaljev
Microsoft Access MVP
 
JRD said:
I would be grateful for some help!

I need to create a program that can calculate a score based on data entered
by the user.

The user will need to enter data from patients with coronary disease.

The first question will be "how many coronary narrowings are present"

Then there will need to be a series of questions for each coronary narrowing.

So if there are 3 narrowings, then the program will need to go through a
series of "sub-questions" for each coronary narrowing. when it has finished
the questions on the 1st narrowing, then it will ask the same sub questions
for the 2nd narrowing and then the 3rd.

At the end it will need to calculate a score based on the answers to the
questions.

For example

Question 1: How many narrowings are there? Answer 2

Narrowing 1:

Question 1.1: Which artery does it affect. Answer: Left coronary

Question 1.2: IS the narrowing causing more that 90% blockage. Answer: Yes

Narrowing 2:

Question 2.1: Which artery does it affect. Answer: Right coronary

Question 2.2: IS the narrowing causing more that 90% blockage. Answer: No




Score calculation:

If Question 1.1 = L coronary then multiply by score by 5
If Question 1.1 - Right coronary then multiply score by 3

If Question 1.2 = Yes then score 5, If = No then score 2

Based on the calculation algorithm the score for narrowing 1 would be 5x5=25
and for narrowing 2 would be 3x2=6

Can anyone tell me whether access 2007 can deal with this sort of problem.
If so, how best do I get started, if not which program can I use?

Many thanks

JD
Click to expand...

Here are my initial thoughts:

You'll want a table with patient records (name, age, whatever). Also a
table for narrowings, related to the Patient table by PatientID - a
one-to-many relationship set up in the Relationships window.

If you've correctly linked the tables (be sure to use the same field
name for the Primary Key of the Patients table and the Foreign Key in
the Narrowings table, and I'd suggest you use an Autonumber for the
former and a Long Integer for the latter), then Access will recognise
the relationship when you "Create a form with Subform" (look that up in
Help). You'll need to run the Wizard a few times to get it laid out
right, but you should end up with a form showing patients and within it
a subform showing the various fields for Narrowings. Don't bother
trying to tell the system first that Patient X has 3 narrowings; just
add three Narrowings records against that patient in the subform.

Once you have the data entered, you can use VBA logic to calculate the
scores. I guess you'd create a query to calculate the score for each
narrowing as a calculated field (play with the Expression Builder - well
worth the time spent understanding it). Then you'd create a report on
that query which would provide an opportunity to sum the scores for a
patient in the report footer. You could also turn on grouping by
PatientID and sum scores for each patient in a report which showed all
patients.

Do this in stages:
1) Most important - get your tables right. Ignore calculations at this
stage; you're just trying to set up tables to store the raw data. Post
a description here as a followup to this thread. You can use the
built-in Documenter to describe your tables.

2) Then get your form/subform right. If you go about it the right way,
Access's Form Wizard will do all the hard work for you! You should be
able to enter all patient data at the end of this step.

3) Then get a query built with a "calculated field" which will display
the score for each narrowing according to the medical rules you've
devised. This query will be based on both Patient and Narrowing tables.
The Expression Builder will help you find and use functions like IFF,
and express your basic arithmetical calculations.

4) Build your report on this query using the Report Wizard, and marvel
at your handiwork. Access is just great for this sort of stuff.

Post for help or comments here at each stage if you need to. This is
one of the best newsgroups anywhere in terms of expertise and
helpfulness, and you'll get a lot of help. I'm certainly not an expert,
and I'm learning constantly just reading the replies to other people's
questions!

Phil, London
 
Back
Top