Using FrontPage & Access 2000 to Develop Online Data Forms
What is R1?
Now let's go to Access2000 to check out what went into the database.
This means that all 10 input radio buttons are being treated as one field since we really
haven t told Access how to collect the data or what to do yet. Need to go back to FP and
improve the "communication".
Creating/Defining Fields for the Database
So far, we have four groups of buttons, representing possible options for the two sub
questions in Question 1, regarding regional (1) or national (2) conference participation (P)
and satisfaction (S) ratings. In the P groups, there are three options: Often, Sometimes and
Never. We shall use 3, 2, and 1 to denote these frequency parameters respectively. In the S
group, there are two options: Yes or No. We shall use 2 for Yes and 1 for No. We can name
the fields (Group Name) in whatever way that makes sense to us and for this section, we
shall use Q1_P_1, Q1_P_2, Q1_S1, and Q1_S_2 respectively.
27
New Page 1