Questionnaire

[PSnyder]

I've given up trying to figure this out so I'm turning to you for help.

I 'm trying to computerize a questionnaire to analyze responses. Actually
it's 5 questionnaires that each client has to fill out so each client has to
answer each question and each question will be answered by all clients.
Write now the questionnaires are on paper. I'd like to get it into the
database so the client can directly enter the info eliminating the need for
data entry.

I understand it's a many-to many-relationship. Should I lump all the
questions into one table and set a category to the questions? I think a
junction table is needed to link the clients to the questions to the
responses. Would I have a Response ID with the Client ID and the Question ID
in the junction table with all three being components of the Primary Key?

Am I asking the right questions? Should I cry uncle? Any help would be
appreciated.

 

[Piet Linden]

I've given up trying to figure this out so I'm turning to you for help.

I 'm trying to computerize a questionnaire to analyze responses.  Actually
it's 5 questionnaires that each client has to fill out so each client hasto
answer each question and each question will be answered by all clients.  
Write now the questionnaires are on paper.  I'd like to get it into the
database so the client can directly enter the info eliminating the need for
data entry.

I understand it's a many-to many-relationship.  Should I lump all the
questions into one table and set a category to the questions?  I think a
junction table is needed to link the clients to the questions to the
responses.  Would I have a Response ID with the Client ID and the Question ID
in the junction table with all three being components of the Primary Key?

Am I asking the right questions?  Should I cry uncle?  Any help wouldbe
appreciated.

take a load off and check this out...
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

 

[Piet Linden]

I've given up trying to figure this out so I'm turning to you for help.

I 'm trying to computerize a questionnaire to analyze responses.  Actually
it's 5 questionnaires that each client has to fill out so each client hasto
answer each question and each question will be answered by all clients.  
Write now the questionnaires are on paper.  I'd like to get it into the
database so the client can directly enter the info eliminating the need for
data entry.

I understand it's a many-to many-relationship.  Should I lump all the
questions into one table and set a category to the questions?  I think a
junction table is needed to link the clients to the questions to the
responses.  Would I have a Response ID with the Client ID and the Question ID
in the junction table with all three being components of the Primary Key?

Am I asking the right questions?  Should I cry uncle?  Any help wouldbe
appreciated.

take a load off and check this out...
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

 

[John W. Vinson]

I've given up trying to figure this out so I'm turning to you for help.

I 'm trying to computerize a questionnaire to analyze responses. Actually
it's 5 questionnaires that each client has to fill out so each client has to
answer each question and each question will be answered by all clients.
Write now the questionnaires are on paper. I'd like to get it into the
database so the client can directly enter the info eliminating the need for
data entry.

I understand it's a many-to many-relationship. Should I lump all the
questions into one table and set a category to the questions? I think a
junction table is needed to link the clients to the questions to the
responses. Would I have a Response ID with the Client ID and the Question ID
in the junction table with all three being components of the Primary Key?

Am I asking the right questions? Should I cry uncle? Any help would be
appreciated.

Take a look at these resources:

Duane Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=TrainingRegistration.mdb

 

[John W. Vinson]

I've given up trying to figure this out so I'm turning to you for help.

I 'm trying to computerize a questionnaire to analyze responses. Actually
it's 5 questionnaires that each client has to fill out so each client has to
answer each question and each question will be answered by all clients.
Write now the questionnaires are on paper. I'd like to get it into the
database so the client can directly enter the info eliminating the need for
data entry.

I understand it's a many-to many-relationship. Should I lump all the
questions into one table and set a category to the questions? I think a
junction table is needed to link the clients to the questions to the
responses. Would I have a Response ID with the Client ID and the Question ID
in the junction table with all three being components of the Primary Key?

Am I asking the right questions? Should I cry uncle? Any help would be
appreciated.

Take a look at these resources:

Duane Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=TrainingRegistration.mdb