Questionnaire form

[Guest]

Hi

I'm trying to create a database to record and analyse questionnaire responses

I wanted to make the data entry form look the same as the hard copy questionnaire itself, but can't work out how to do it

I guess the main starting point would be how can I link an option group to represent 4 pieces of text - poor/unsatisfactory/satisfactory/good/excellent

I am aware how I can force an output through VBA, but then what about reviewing past entries through the form

I am very comfortable with forms/using VBA etc - I have only used Access for importing/analysing/reporting on stored data, so the data entry part is very new to me

Any tips would be really appreciated

Many thanks

Basil

 

[Kevin Sprinkel]

Hi, Basil. I'm not sure how you mean this, but this may
be what you're thinking of. Toggle Wizards on (Wand &
Stars on the Toolbox menu. Add an Option Group to your
form (rectangle w/XYZ across the top). Add the options--
the text you'd like displayed and the value (1,2,...) you
wish to store in the underlying field. Tell the wizard
which field you'd like to store the value in.

If you plan on printing the form, I recommend you create a
report which gives you much more control over the printed
output than trying to print the form directly using the
menu button.

Now, to get the text associated with the option value
printed on your form, create a new table which you can
link to your primary table in a query, e.g,

OptionValues
============
OptionID Number (Primary Key)
OptionText Text

Either create a relationship between OptionID and its
foreign key in your main table at the application level
(Tools, Relationships), or create the relationship in your
query by dragging one field to the other. Choose the
OptionValues->OptionText field and all others you'd like
to print, and base your report on this query.

HTH
Kevin Sprinkel

I guess the main starting point would be how can I link

an option group to represent 4 pieces of text -
poor/unsatisfactory/satisfactory/good/excellent.