Research questionnaire

[Martine]

I’m making an Access db for a research project. There are
several different questionnaires most of which are taken
before and after the study. There is also a daily diary.
Each questionnaire varies in number/type of responses. For
example, Questionnaire 1 has the first Section as T/F and
the next Section as “not bothered”, “slightly
bothered”, “really bothered”

I’m trying to create forms for data entry that I can use
again and again for each questionnaire. I can’t figure out
how to to combine them so that the question shows but the
answer is left blank.

Another catch is that the form has to look like the hard
copy. I’ve just quickly looked at Duane Hookam’s
AtYourSurvey but I can’t use it as I have to have the form
with the ability to select T/F on buttons not on a drop
down list.

Here is my design:

TblParticipant
fldPID
fldSurName
fldFirstName
Etc

TblQuestion
fldQID
fldQNID
fldDepends On
fldSection
fldNum
fldMain question
fldIsNum
fldAnsNum
fldAnsType1
fldAnsType2
…
fldAnsType7
fldAnsType99

TblAnswer
fldQNID
fldQID
fldAns1
fldAns2
…
fldAns7

tblQuestionnaire
fldQTID
fldQNID
fldPID
fldDate

TlkpQstnName
fldQNID
fldDescription
fldBaseline or Final