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 |
#11
|
|||
|
|||
Simple Questionnaire DB
I think I understand what your set up is but how do you deal with the foreign key field in the subform when you append the data. Do you set a criteria in the append query. Would it be possible for you to send a copy of yours for me to look at? empty and compacted of course. I am intrigued. david(dot)bowman(at)thames water(dot)co(dot)uk |
#12
|
|||
|
|||
Simple Questionnaire DB
the setup in my db is part of a much larger, complex interface, it would
take me some time to pare it down to basics. but i built a demo of this very concept some time back, for someone who posted; i'll see if i can dig it up over the weekend and email it to you, scuba. "scubadiver" wrote in message ... I think I understand what your set up is but how do you deal with the foreign key field in the subform when you append the data. Do you set a criteria in the append query. Would it be possible for you to send a copy of yours for me to look at? empty and compacted of course. I am intrigued. david(dot)bowman(at)thames water(dot)co(dot)uk |
#13
|
|||
|
|||
Simple Questionnaire DB
most things I can deal with but not survey design. I didn't think Access would be a suitable method. post it to here instead david (at) cedar1 (dot) demon (dot) co (dot) uk thanks |
#14
|
|||
|
|||
Simple Questionnaire DB
hmm, okay, i hope by "post" you mean to "email" it to the address you gave?
at any rate, that's what i did, so i hope it gets to you okay. if not, post back, and i'll send it from my other email. tina "scubadiver" wrote in message ... most things I can deal with but not survey design. I didn't think Access would be a suitable method. post it to here instead david (at) cedar1 (dot) demon (dot) co (dot) uk thanks |
#15
|
|||
|
|||
Simple Questionnaire DB
I may have received it but Norton might have treated it as spam. I didn't notice it in my inbox. Can you resend, cheers -- The 11th day of every month: http://truthaction.org/forum/index.php "tina" wrote: hmm, okay, i hope by "post" you mean to "email" it to the address you gave? at any rate, that's what i did, so i hope it gets to you okay. if not, post back, and i'll send it from my other email. tina "scubadiver" wrote in message ... most things I can deal with but not survey design. I didn't think Access would be a suitable method. post it to here instead david (at) cedar1 (dot) demon (dot) co (dot) uk thanks |
#16
|
|||
|
|||
Simple Questionnaire DB
okay, on its' way again. hopefully i'm entering your email address right;
haven't got the dreaded "failure notice" email YET, so... "scubadiver" wrote in message ... I may have received it but Norton might have treated it as spam. I didn't notice it in my inbox. Can you resend, cheers -- The 11th day of every month: http://truthaction.org/forum/index.php "tina" wrote: hmm, okay, i hope by "post" you mean to "email" it to the address you gave? at any rate, that's what i did, so i hope it gets to you okay. if not, post back, and i'll send it from my other email. tina "scubadiver" wrote in message ... most things I can deal with but not survey design. I didn't think Access would be a suitable method. post it to here instead david (at) cedar1 (dot) demon (dot) co (dot) uk thanks |
#17
|
|||
|
|||
Simple Questionnaire DB
Sorry, I've been out of town. This sounds more like what I need. Could you
elaborate a little more? I'm understanding the concept and the end result, just need a boost with getting there. I didn't expect so much commotion over a survey =) Here's the deal on the surveys: I don't care to set up the actual survey in the database, they are just handed to me after the employees fill them out and my boss says 'Here, go ahead and tally these up, thanks'. Then he sends me an electronic copy of the survey (excel spreadsheet) and I enter the totals on there and mail it back. Pretty simple. Except for the tally part, that's time consuming reading each check mark. I don't care about naming the questions, answers or surveys it's just for tally purposes and would probably be used over and over for different surveys of the same set up. I'm still new at my job so I don't know how often the same survey goes out but I know the same TYPE of survey frequently goes out and if I'm the tally girl, I'd like an easier way to get there. =) Thanks so much! "John W. Vinson" wrote: On Sun, 19 Aug 2007 23:42:00 -0700, scubadiver wrote: I think you will need 34 fields. A field for each edition of the survey (if it is to be repeated monthly, quarterly), a field that identifies each questionnaire within each survey set and the remaining 32 for each question. BZZZZT!!! "Pull over to the side. Take your hands off the keyboard and keep them in sight. You're under arrest for Committing Spreadsheet!" g Seriously, this is a very common error in designing surveys. You're much better off having a one-to-many relationship from Surveys to Questions, and from Surveys to Answers; instead of 32 fields, you would have 32 records, one for each question. You can use a Crosstab query to *display* a grid layout, and even use a Grid control to edit the answers - but the tables should be tall and thin, not storing questions in fieldnames. John W. Vinson [MVP] |
#18
|
|||
|
|||
Simple Questionnaire DB
Tina helped me out brilliantly when she sent me a demo of what she did. The vast majority of responses are quantitative and the "answer" field is set to number. Here is my current table design. tble_survey SurveyID (PK) Quarter Year tble_resp surveyID (FK) RespID (PK) D1 D2 D3 tble_answer QID (FK) RespID (FK) AnswerID (PK) Answer tble_questions SectionID (FK) QID (PK) QOrder Question tble_section SectionID (PK) Name Questions 1) D1,D2,D3 are demographics. Should they stay there or go into "tbl_questions" 2) I do have some text answers (like open comments). Should [answer] be changed to a text field or will this cause problems? 3) How can I deal with a question that can have multiple responses? Help would be appreciated. Cheers -- http://www.ready4mainstream.ny911truth.org/index.html |
#19
|
|||
|
|||
Simple Questionnaire DB
"I don't care to set up the actual survey in the database". What do you mean by that? In order to enter information you need to set up tables and forms. You don't have to enter the totals by hand. Export the summary information to a source spreadsheet and link the cell references to another spreadsheet in a format that your boss will like. "tally" ho! -- http://www.ready4mainstream.ny911truth.org/index.html "Pixie78" wrote: Sorry, I've been out of town. This sounds more like what I need. Could you elaborate a little more? I'm understanding the concept and the end result, just need a boost with getting there. I didn't expect so much commotion over a survey =) Here's the deal on the surveys: I don't care to set up the actual survey in the database, they are just handed to me after the employees fill them out and my boss says 'Here, go ahead and tally these up, thanks'. Then he sends me an electronic copy of the survey (excel spreadsheet) and I enter the totals on there and mail it back. Pretty simple. Except for the tally part, that's time consuming reading each check mark. I don't care about naming the questions, answers or surveys it's just for tally purposes and would probably be used over and over for different surveys of the same set up. I'm still new at my job so I don't know how often the same survey goes out but I know the same TYPE of survey frequently goes out and if I'm the tally girl, I'd like an easier way to get there. =) Thanks so much! "John W. Vinson" wrote: On Sun, 19 Aug 2007 23:42:00 -0700, scubadiver wrote: I think you will need 34 fields. A field for each edition of the survey (if it is to be repeated monthly, quarterly), a field that identifies each questionnaire within each survey set and the remaining 32 for each question. BZZZZT!!! "Pull over to the side. Take your hands off the keyboard and keep them in sight. You're under arrest for Committing Spreadsheet!" g Seriously, this is a very common error in designing surveys. You're much better off having a one-to-many relationship from Surveys to Questions, and from Surveys to Answers; instead of 32 fields, you would have 32 records, one for each question. You can use a Crosstab query to *display* a grid layout, and even use a Grid control to edit the answers - but the tables should be tall and thin, not storing questions in fieldnames. John W. Vinson [MVP] |
#20
|
|||
|
|||
Simple Questionnaire DB
I mean that what I want is nothing fancy, I just want it to add for me. I
don't want to type in all the questions or create a pretty form with all kinds of buttons and functions and spend a ton of time on this. I just want a quick way to tally. Nothing more. The 2 tables I have so far a tblQuestions QuestionID (PK) Numbered 1-32 in this case Questions - probably contain a couple of words of the question in case I'm tallying a survey that doesn't have actual numbered questions tblAnswers AnswerID (PK) Answer 1 Strongly Disagree 2 Disagree 3 Neither Agree or Disagree 4 Agree 5 Strongly Agree There's no survey versions, demographics, names, departments or anything else aside from the survey questions and answers and a bunch of check marks in the boxes. There are just under 200 employees here but if the survey isn't mandatory, there could only be 70 turned in. All our surveys are similar with this opinion of Agree or Disagree. I just want to have a form that has all the questions with the answer box next to it and just tab through and type the answers as in 3 tab 1 tab 1 tab 4 tab and when I get to question 32 I hit submit or send or it just automatically goes to a new, blank survey form and I enter the results of the next person and so on til there's no more and then run the query and see the totals for each question. How many Agrees, Disagrees.... you get the point. I know I need another table of SurveyID which will act as the number of papers I have and then a table of the questions with the answers in which to run the crosstab query, it's there I'm having the problem. How do I go about linking the questions with a selectable answer and have each "form" equal the 32 questions I have? Make sense? "scubadiver" wrote: "I don't care to set up the actual survey in the database". What do you mean by that? In order to enter information you need to set up tables and forms. You don't have to enter the totals by hand. Export the summary information to a source spreadsheet and link the cell references to another spreadsheet in a format that your boss will like. "tally" ho! -- http://www.ready4mainstream.ny911truth.org/index.html "Pixie78" wrote: Sorry, I've been out of town. This sounds more like what I need. Could you elaborate a little more? I'm understanding the concept and the end result, just need a boost with getting there. I didn't expect so much commotion over a survey =) Here's the deal on the surveys: I don't care to set up the actual survey in the database, they are just handed to me after the employees fill them out and my boss says 'Here, go ahead and tally these up, thanks'. Then he sends me an electronic copy of the survey (excel spreadsheet) and I enter the totals on there and mail it back. Pretty simple. Except for the tally part, that's time consuming reading each check mark. I don't care about naming the questions, answers or surveys it's just for tally purposes and would probably be used over and over for different surveys of the same set up. I'm still new at my job so I don't know how often the same survey goes out but I know the same TYPE of survey frequently goes out and if I'm the tally girl, I'd like an easier way to get there. =) Thanks so much! "John W. Vinson" wrote: On Sun, 19 Aug 2007 23:42:00 -0700, scubadiver wrote: I think you will need 34 fields. A field for each edition of the survey (if it is to be repeated monthly, quarterly), a field that identifies each questionnaire within each survey set and the remaining 32 for each question. BZZZZT!!! "Pull over to the side. Take your hands off the keyboard and keep them in sight. You're under arrest for Committing Spreadsheet!" g Seriously, this is a very common error in designing surveys. You're much better off having a one-to-many relationship from Surveys to Questions, and from Surveys to Answers; instead of 32 fields, you would have 32 records, one for each question. You can use a Crosstab query to *display* a grid layout, and even use a Grid control to edit the answers - but the tables should be tall and thin, not storing questions in fieldnames. John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|