N
niklasr
I don't know if this is the right place or if i should have post it on FORM's
section.
but anyway.
I have a paper version survey, already made and answered by people. I need
to store their answered into a database, and we are working with Access2003.
The survey consists of 35 questions divided in three categories (eg. A, B, C)
and three types of questions. These are:
* Yes/No questions
* Multiple choice questions (basically multiple yes/no answers in the same
table), and
* Text field questions
I have made a table for each question, and named them [section][question
no.] (A1 B1 C1 and so on). The reason for giving every question their own
table is that I did not want to mix simple Yes/No questions with multiple
choice questions, and that I can not collect the multiple choice questions
into one table because their answer possibilities differ from each other.
Tables look like this:
A1 (gender) (shows as radio buttons in form)
-----------------------------
Male Yes/no
Female Yes/no
------------------------------
------------------------------
A2 (activities) (are able to choose several alternatives)
------------------------------
soccer Yes/no
theatre Yes/no
fishing Yes/no
------------------------------
------------------------------
A3 (free form question where people fill in a longer text)
------------------------------
Comment PM
------------------------------
My trouble begins then I am to build a collective FORM for this survey.
The ultimate would be if I could get the whole survey in a single form, so
it looks just as it does in paper version (this would help if people with
less experience to fill would assist me in storing the data). Alternative, so
you can get every table/form linked so only one FORM(question) is shown and
when you have answered that the next FORM will open by pressing a button. I
have tried both of these, but I can not get it to work. I simply don’t know
how to link/bind the FORMs together.
1. Anyone know how to solve my trouble with the FORM's
2. Am I doing right in setting up the database the way i do, or is there a
more simpler way to do it?
Sorry if this question became a bit long, i find it a bit hard to explain it.
/friendly: Niklas
section.
but anyway.
I have a paper version survey, already made and answered by people. I need
to store their answered into a database, and we are working with Access2003.
The survey consists of 35 questions divided in three categories (eg. A, B, C)
and three types of questions. These are:
* Yes/No questions
* Multiple choice questions (basically multiple yes/no answers in the same
table), and
* Text field questions
I have made a table for each question, and named them [section][question
no.] (A1 B1 C1 and so on). The reason for giving every question their own
table is that I did not want to mix simple Yes/No questions with multiple
choice questions, and that I can not collect the multiple choice questions
into one table because their answer possibilities differ from each other.
Tables look like this:
A1 (gender) (shows as radio buttons in form)
-----------------------------
Male Yes/no
Female Yes/no
------------------------------
------------------------------
A2 (activities) (are able to choose several alternatives)
------------------------------
soccer Yes/no
theatre Yes/no
fishing Yes/no
------------------------------
------------------------------
A3 (free form question where people fill in a longer text)
------------------------------
Comment PM
------------------------------
My trouble begins then I am to build a collective FORM for this survey.
The ultimate would be if I could get the whole survey in a single form, so
it looks just as it does in paper version (this would help if people with
less experience to fill would assist me in storing the data). Alternative, so
you can get every table/form linked so only one FORM(question) is shown and
when you have answered that the next FORM will open by pressing a button. I
have tried both of these, but I can not get it to work. I simply don’t know
how to link/bind the FORMs together.
1. Anyone know how to solve my trouble with the FORM's
2. Am I doing right in setting up the database the way i do, or is there a
more simpler way to do it?
Sorry if this question became a bit long, i find it a bit hard to explain it.
/friendly: Niklas