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
|
|||
|
|||
For Duane Hookom
I have downloaded your excellent survey database.
I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
#2
|
|||
|
|||
For Duane Hookom
I don't believe I store the answer_id in the tbl_responses since I often
allow free text entry. I have a "limit to list" field in my questions table that I use in my data entry form. Using the answer_id assumes all possible answers for each question will be in the tbl_answers. I have some fields in my table of questions that I could use for additional functionality. For instance, if I required a numeric response type, then I would know that I could average or total the field. Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use qstnaire_id in tbl_questions. Each answer from each participant for each question for each survey will create a new record in the responses table. You could use the levels much as I have to group questions. -- Duane Hookom Microsoft Access MVP "dee" wrote: I have downloaded your excellent survey database. I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
#3
|
|||
|
|||
For Duane Hookom
Thank you for your responses.
I have been looking at your tables and how they are related. I'm not totally clear on the roles of the tables that are not related, such as tblKeywords, tlblLookup, etc. Would you mind clarifying this? Thank you. -- Thanks! Dee "Duane Hookom" wrote: I don't believe I store the answer_id in the tbl_responses since I often allow free text entry. I have a "limit to list" field in my questions table that I use in my data entry form. Using the answer_id assumes all possible answers for each question will be in the tbl_answers. I have some fields in my table of questions that I could use for additional functionality. For instance, if I required a numeric response type, then I would know that I could average or total the field. Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use qstnaire_id in tbl_questions. Each answer from each participant for each question for each survey will create a new record in the responses table. You could use the levels much as I have to group questions. -- Duane Hookom Microsoft Access MVP "dee" wrote: I have downloaded your excellent survey database. I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
#4
|
|||
|
|||
For Duane Hookom
These are a symptom of a lazy programmer. I probably converted an
un-normalized survey where separate fields were used for each question. tblLookup was most likely imported and then used to create the tblResponsesList. I might have a potential use for tblKeyWords but it has escaped my memory. There is probably lots of other remnants and garbage that should have been thrown out ;-). -- Duane Hookom Microsoft Access MVP "dee" wrote: Thank you for your responses. I have been looking at your tables and how they are related. I'm not totally clear on the roles of the tables that are not related, such as tblKeywords, tlblLookup, etc. Would you mind clarifying this? Thank you. -- Thanks! Dee "Duane Hookom" wrote: I don't believe I store the answer_id in the tbl_responses since I often allow free text entry. I have a "limit to list" field in my questions table that I use in my data entry form. Using the answer_id assumes all possible answers for each question will be in the tbl_answers. I have some fields in my table of questions that I could use for additional functionality. For instance, if I required a numeric response type, then I would know that I could average or total the field. Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use qstnaire_id in tbl_questions. Each answer from each participant for each question for each survey will create a new record in the responses table. You could use the levels much as I have to group questions. -- Duane Hookom Microsoft Access MVP "dee" wrote: I have downloaded your excellent survey database. I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
#5
|
|||
|
|||
For Duane Hookom
Hi again,
I guess some of my confusion comes from the fact that your database is set up to create the surveys, etc., whereas I am starting mine from scratch. I am trying to understand the role of each table to start with and which tables are not necessary for me, in view of the fact that users won't be setting up surveys. The purpose of the database is to input the data from surveys that have been completed over the summer. We will take the hard copy and input via forms to the various tables. For detailed statistics, we will be exporting to another software. Thank you so very much for your assistance. -- Thanks! Dee "Duane Hookom" wrote: I don't believe I store the answer_id in the tbl_responses since I often allow free text entry. I have a "limit to list" field in my questions table that I use in my data entry form. Using the answer_id assumes all possible answers for each question will be in the tbl_answers. I have some fields in my table of questions that I could use for additional functionality. For instance, if I required a numeric response type, then I would know that I could average or total the field. Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use qstnaire_id in tbl_questions. Each answer from each participant for each question for each survey will create a new record in the responses table. You could use the levels much as I have to group questions. -- Duane Hookom Microsoft Access MVP "dee" wrote: I have downloaded your excellent survey database. I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
#6
|
|||
|
|||
For Duane Hookom
You should be able to just stick with the forms for entering your survey
design. Everything you should need to do to encorporate your survey should be available from the survey design form. -- Duane Hookom Microsoft Access MVP "dee" wrote: Hi again, I guess some of my confusion comes from the fact that your database is set up to create the surveys, etc., whereas I am starting mine from scratch. I am trying to understand the role of each table to start with and which tables are not necessary for me, in view of the fact that users won't be setting up surveys. The purpose of the database is to input the data from surveys that have been completed over the summer. We will take the hard copy and input via forms to the various tables. For detailed statistics, we will be exporting to another software. Thank you so very much for your assistance. -- Thanks! Dee "Duane Hookom" wrote: I don't believe I store the answer_id in the tbl_responses since I often allow free text entry. I have a "limit to list" field in my questions table that I use in my data entry form. Using the answer_id assumes all possible answers for each question will be in the tbl_answers. I have some fields in my table of questions that I could use for additional functionality. For instance, if I required a numeric response type, then I would know that I could average or total the field. Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use qstnaire_id in tbl_questions. Each answer from each participant for each question for each survey will create a new record in the responses table. You could use the levels much as I have to group questions. -- Duane Hookom Microsoft Access MVP "dee" wrote: I have downloaded your excellent survey database. I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
#7
|
|||
|
|||
For Duane Hookom
Yes, I realize that and I thank you.
What I am trying to do, though, is create my own database through trying to understand how yours is constructed, which I can't do through filling in your forms. I also have a lot of extra information (tables) to add that contain regions, interviewer information, etc. -- Thanks! Dee "Duane Hookom" wrote: You should be able to just stick with the forms for entering your survey design. Everything you should need to do to encorporate your survey should be available from the survey design form. -- Duane Hookom Microsoft Access MVP "dee" wrote: Hi again, I guess some of my confusion comes from the fact that your database is set up to create the surveys, etc., whereas I am starting mine from scratch. I am trying to understand the role of each table to start with and which tables are not necessary for me, in view of the fact that users won't be setting up surveys. The purpose of the database is to input the data from surveys that have been completed over the summer. We will take the hard copy and input via forms to the various tables. For detailed statistics, we will be exporting to another software. Thank you so very much for your assistance. -- Thanks! Dee "Duane Hookom" wrote: I don't believe I store the answer_id in the tbl_responses since I often allow free text entry. I have a "limit to list" field in my questions table that I use in my data entry form. Using the answer_id assumes all possible answers for each question will be in the tbl_answers. I have some fields in my table of questions that I could use for additional functionality. For instance, if I required a numeric response type, then I would know that I could average or total the field. Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use qstnaire_id in tbl_questions. Each answer from each participant for each question for each survey will create a new record in the responses table. You could use the levels much as I have to group questions. -- Duane Hookom Microsoft Access MVP "dee" wrote: I have downloaded your excellent survey database. I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
#8
|
|||
|
|||
For Duane Hookom
I am trying to figure out the "limit to list" field. I have many anwers
that are not limited to list - the respondent may select one of the list answers, or may write their own answer. Can you point me in the right direction regarding how to handle this? You mentioned having the "limit to list" field in your questions table, which I see fine. However, I'm looking for how you use this in a data entry form, but can't seem to figure it out. Thanks! -- Thanks! Dee "Duane Hookom" wrote: You should be able to just stick with the forms for entering your survey design. Everything you should need to do to encorporate your survey should be available from the survey design form. -- Duane Hookom Microsoft Access MVP "dee" wrote: Hi again, I guess some of my confusion comes from the fact that your database is set up to create the surveys, etc., whereas I am starting mine from scratch. I am trying to understand the role of each table to start with and which tables are not necessary for me, in view of the fact that users won't be setting up surveys. The purpose of the database is to input the data from surveys that have been completed over the summer. We will take the hard copy and input via forms to the various tables. For detailed statistics, we will be exporting to another software. Thank you so very much for your assistance. -- Thanks! Dee "Duane Hookom" wrote: I don't believe I store the answer_id in the tbl_responses since I often allow free text entry. I have a "limit to list" field in my questions table that I use in my data entry form. Using the answer_id assumes all possible answers for each question will be in the tbl_answers. I have some fields in my table of questions that I could use for additional functionality. For instance, if I required a numeric response type, then I would know that I could average or total the field. Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use qstnaire_id in tbl_questions. Each answer from each participant for each question for each survey will create a new record in the responses table. You could use the levels much as I have to group questions. -- Duane Hookom Microsoft Access MVP "dee" wrote: I have downloaded your excellent survey database. I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
#9
|
|||
|
|||
For Duane Hookom
Check the On Current event of the subform where the answers are entered:
code Rspns.Requery Me![Rspns].LimitToList = Me!LmtLst If Me![RspnsType] = 1 Then Me![Rspns].RowSourceType = "Value List" Me![Rspns].RowSource = "Yes;No" Else Me![Rspns].RowSourceType = "Table/Query" Me![Rspns].RowSource = "SELECT tblResponsesList.Rspns FROM tblResponsesList WHERE ((tblResponsesList.QstnID=[Forms]![frmSurveyResponses]![sfrmResponses].[Form]![QstnID]));" End If If IsNull(Me![RspnsValid]) Then Me![Rspns].ValidationRule = "" Me![Rspns].ValidationText = "" Else Me![Rspns].ValidationRule = Me![RspnsValid] Me![Rspns].ValidationText = Me![RspnsValid] End If /code -- Duane Hookom Microsoft Access MVP "dee" wrote: I am trying to figure out the "limit to list" field. I have many anwers that are not limited to list - the respondent may select one of the list answers, or may write their own answer. Can you point me in the right direction regarding how to handle this? You mentioned having the "limit to list" field in your questions table, which I see fine. However, I'm looking for how you use this in a data entry form, but can't seem to figure it out. Thanks! -- Thanks! Dee "Duane Hookom" wrote: You should be able to just stick with the forms for entering your survey design. Everything you should need to do to encorporate your survey should be available from the survey design form. -- Duane Hookom Microsoft Access MVP "dee" wrote: Hi again, I guess some of my confusion comes from the fact that your database is set up to create the surveys, etc., whereas I am starting mine from scratch. I am trying to understand the role of each table to start with and which tables are not necessary for me, in view of the fact that users won't be setting up surveys. The purpose of the database is to input the data from surveys that have been completed over the summer. We will take the hard copy and input via forms to the various tables. For detailed statistics, we will be exporting to another software. Thank you so very much for your assistance. -- Thanks! Dee "Duane Hookom" wrote: I don't believe I store the answer_id in the tbl_responses since I often allow free text entry. I have a "limit to list" field in my questions table that I use in my data entry form. Using the answer_id assumes all possible answers for each question will be in the tbl_answers. I have some fields in my table of questions that I could use for additional functionality. For instance, if I required a numeric response type, then I would know that I could average or total the field. Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use qstnaire_id in tbl_questions. Each answer from each participant for each question for each survey will create a new record in the responses table. You could use the levels much as I have to group questions. -- Duane Hookom Microsoft Access MVP "dee" wrote: I have downloaded your excellent survey database. I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
#10
|
|||
|
|||
For Duane Hookom
I am working with your forms and thing are coming along. A question would be:
Your tblSrvRespns contains only SrvID, RspnsID and RspnsName. My question is: I have a lot more data for each respondent - phone number, address, etc., etc. They are identified more by a number than a name, BTW. Should I include all of this in the tblsSrvRspns or have a separate table that is related to this one? -- Thanks! Dee "Duane Hookom" wrote: Check the On Current event of the subform where the answers are entered: code Rspns.Requery Me![Rspns].LimitToList = Me!LmtLst If Me![RspnsType] = 1 Then Me![Rspns].RowSourceType = "Value List" Me![Rspns].RowSource = "Yes;No" Else Me![Rspns].RowSourceType = "Table/Query" Me![Rspns].RowSource = "SELECT tblResponsesList.Rspns FROM tblResponsesList WHERE ((tblResponsesList.QstnID=[Forms]![frmSurveyResponses]![sfrmResponses].[Form]![QstnID]));" End If If IsNull(Me![RspnsValid]) Then Me![Rspns].ValidationRule = "" Me![Rspns].ValidationText = "" Else Me![Rspns].ValidationRule = Me![RspnsValid] Me![Rspns].ValidationText = Me![RspnsValid] End If /code -- Duane Hookom Microsoft Access MVP "dee" wrote: I am trying to figure out the "limit to list" field. I have many anwers that are not limited to list - the respondent may select one of the list answers, or may write their own answer. Can you point me in the right direction regarding how to handle this? You mentioned having the "limit to list" field in your questions table, which I see fine. However, I'm looking for how you use this in a data entry form, but can't seem to figure it out. Thanks! -- Thanks! Dee "Duane Hookom" wrote: You should be able to just stick with the forms for entering your survey design. Everything you should need to do to encorporate your survey should be available from the survey design form. -- Duane Hookom Microsoft Access MVP "dee" wrote: Hi again, I guess some of my confusion comes from the fact that your database is set up to create the surveys, etc., whereas I am starting mine from scratch. I am trying to understand the role of each table to start with and which tables are not necessary for me, in view of the fact that users won't be setting up surveys. The purpose of the database is to input the data from surveys that have been completed over the summer. We will take the hard copy and input via forms to the various tables. For detailed statistics, we will be exporting to another software. Thank you so very much for your assistance. -- Thanks! Dee "Duane Hookom" wrote: I don't believe I store the answer_id in the tbl_responses since I often allow free text entry. I have a "limit to list" field in my questions table that I use in my data entry form. Using the answer_id assumes all possible answers for each question will be in the tbl_answers. I have some fields in my table of questions that I could use for additional functionality. For instance, if I required a numeric response type, then I would know that I could average or total the field. Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use qstnaire_id in tbl_questions. Each answer from each participant for each question for each survey will create a new record in the responses table. You could use the levels much as I have to group questions. -- Duane Hookom Microsoft Access MVP "dee" wrote: I have downloaded your excellent survey database. I am building a survey database from scratch and am still in the planning on paper stage. My tables are as follows: tbl_questionnaires qstnaire_id (PK) qstnaire_name qstnaire_code qstnaire_description tbl_participants ppt_id (PK) ppt_no ppt_given_name ppt_family_name ppt_id_no ppt_date_of_birth ppt_gender pregnant rltnshp_to_hd_of_hshld ppt_house_no ppt_phone_no tbl_questions question_id (PK) qstnaire_code (FK) question_number question_text tbl_answers answer_id answer_no question_id (FK) answer tbl_responses response_id (PK) question_id (FK) answer_id (FK) participant_id (FK) qstnaire_date qstnaire_start_time tbl_interviewers interviewer_id (PK) interviewer_no Interviewer_given_name Interviewer_family_name tbl_household_relationships hshld_relationship_id (PK) hshld_relationship_category (FK) hshld_relationship_no hshld_relationship_description The questions are made up of the qstnaire_code field and 1, 2, 3, etc. There are no sub questions. While many questions limit the answer to one listed, some require text reponse from the individual being interviewed. The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 - female on one question and 1 - Yes, 2 - No on another, etc. There are two or three numbers that may appear that are always the same: 50 - NR and 51 - Don't know. These answers are always numbered 50 and 51, even if they follow answers 1, 2, 3, 4 (50, 51). My questions, at the moment a 1. Does my structure, so far, look sound? 2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I would hav thought they would be in the Reponses table. 3. I assume that I will need a record for each and every response to each and every question. 4. I have headings at the beginning of sets of questions with the various questionnaires - Section 1 "xxx", followed by questions pertaining to that section, etc. Would I include that as a level in my tblQuestions? Any guidance would be GREATLY appreciated! Thank you so much! -- Thanks! Dee |
|
Thread Tools | |
Display Modes | |
|
|