If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Questionnaire
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 |
#3
|
|||
|
|||
Questionnaire
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] |
Thread Tools | |
Display Modes | |
|
|