Math Question

  • Thread starter Thread starter Rabastan
  • Start date Start date
R

Rabastan

I have a section of my database that is based on the "Glasgow Coma Scale" an
explanation can be found here
"http://en.wikipedia.org/wiki/Glasgow_Coma_Scale"

It is a way of determining someones level of consciousness by evaluating
certian signs and assigning each a score. There are three different criteria
each with a text description and a score. How can I place the text
description and score in a dropdown, for example (Opens Eyes Spontaneously =
4) and be able to get a total at the end?
 
This is probably a bigger question than you realize.

For any person, I imagine you could perform this evaluation multiple times.

For each evalutation, there are multiple questions to be assessed (re eyes,
verbal, and motor).

For each question, there are multiple possible answers (between 4 and 6),
each with their own value.

So, first you have to teach Access about the questions and possible answers
for each:
tblQuestion, with fields:
- QuestionID Number primary key (1, 2, or 3)
- Question Text 'eyes', 'verbal', or 'motor'

tblAnswer, with fields:
- QuestionID Number one of the 3 questions
- AnswerID Number a number between 1 and 6.
- AnswerText Text description of this answer to this question.
(Primary key is combination of QuestionID + AnswerID.)

tblPerson: one record for each person, fields:
- PersonID AutoNumber primary key.
- Surname Text
- FirstName Text

tblEval: one record each time a person is assessed, fields:
- EvalID AutoNumber primary key
- PersonID Number who was assessed
- EvalDate Date/Time when they were assessed.

tblEvalDetail: one record for the answer to each question in an evaluation.
Fields:
- EvalID Number tells which evaluation this row belongs to.
Req.
- QuestionID Number which question this row is answering. Required.
- AnswerID Number which answer was given.
- Comment Text optional
(Primary key is combination of EvalID + QuestionID

To interface this, you will have a main form bound to tblEval, with a
subform bound to tblEvalDetail. Show the subform in Continuous Form view, so
it shows the 3 rows. Place a text box in the Form Footer section of the
subform to show the total; its Control Source will be:
=Sum([AnswerID])
 
Back
Top