How do I set-up a likert scale in Access?

[Guest]

I am creating a survey in Access 2003. I need to use a Likert Scale (1 is
Strongly Disagree.....to 5, Strongly Agree) for many questions. I need to
have a toggle option for this field, and it should be laid out horizontally.
I don't know how to define the field in the Table, and I don't know how to
design the field in the Form.

Strongly Disagree Disagree Neither Agree Strongly Agree
1 2 3 4
5

where the text are the headings and the numbers are the choices (single
choice).

 

[Guest]

This is ideally suited to an Option Group, using checkboxes in place of
toggle buttons. Access sets this up in a single column by default, but you
can rearrange them horizontally. Bind the option group to a numeric
"LikertID" field.

Each subform record will need a RespondantID, QuestionID, and the LikertID.

Hope that helps.
Sprinks

 

[Guest]

Thank you. I will give it a try!

This is ideally suited to an Option Group, using checkboxes in place of
toggle buttons. Access sets this up in a single column by default, but you
can rearrange them horizontally. Bind the option group to a numeric
"LikertID" field.

Each subform record will need a RespondantID, QuestionID, and the LikertID.

Hope that helps.
Sprinks