Questionnaire

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.

On May 21, 9:51*am, PSnyder wrote:
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 load off and check this out...
http://www.rogersaccesslibrary.com/f...osts.asp?TID=3

On Thu, 21 May 2009 07:51:01 -0700, PSnyder
wrote:

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%20Your%20Survey%2 02000'

Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/d...gistration.mdb
--

John W. Vinson [MVP]