Art Exhibitions
Index
Links
Home
Feedback
Last
Next
Community Tute 23 - Create the questionnaire form
1. Start Access and open the database we created in the last tute, select the 'Forms' tab and the then hit the 'New' button. If you did not compete the last tute you can download the database
click here to download.
2. Create the questionnaire form,
based on data in the baseline table.
3. Add all the fields to the form.
4. Create a new option group, make
sure the wizard is switched on.
5. Set the label names from r1-r5,
these will be equated to the response sets (or answers) to the questions that
each field represents.
6. We don't want a default, if
someone doesn't want to answer a question we should leave a blank or null
value.
7. This dialogue box lets you modify
the settings for each of the response values, leave the default
values.
8. Store the response in the Q1
(Question1) field
.
9. Modify the style of the buttons,
choose 'Check boxes' and 'Etched'. Press the next
key.
10. Set the label for the option
group to
Q1.
11. Your screen should now look like
the image
below.
12. Delete all the labels Q1 &
r1-r5, add new text boxes across the top to prompt the user for
input.
13. Use the align tool to align all
the buttons to the same height on the
page.
14. After a bit of playing around
the form should look something like the image
below.
15. Save the form as the 'Baseline
Form'.
16. If you copy and paste the option groups like i did (so
you don't have to go through the above process over and over again) you will need
to re-set the control source for each of the option
groups.
17. The final form view with some selections made, look at
the values that the option group creates in the fields, 1=always, 2=mostly,
3=sometime, 4=little and 5=
never.
Copyright © 1999 R&D Robotics Pty Ltd, All rights reserved.
Any copyright subsisting in the above code and or literary works including source files vests with R&D Robotics Pty Ltd. ACN 086 345 137
Last
Next