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
|
|||
|
|||
Simple Questionnaire DB
I'm just looking for a simple database to input the results of a
questionnaire/survey done by our employees. It was made in Excel but printed and handed out to the employees. There are 32 questions and the possible answers for each on a 1. Strongly Disagree 2. Disagree 3. Neither Agree or Disagree 4. Agree 5. Strongly Agree I'm not looking for anything fancy and I'm not looking to create these surveys in the database or anything like that. That's not my job function. I did get the task of having to tally up the results of this survey and there are others once in a while that are similar to it so it would be handy to have this little interface to zip through the tally process. I just wanted to see if there was an easy way to set up a form similar to the survey taken and run through it survey by survey and then run a totals query for the results. A tally, how many strongly agrees for question 1, 2 , 3, so on and so forth. The survey's are anonymous so all I have are the questions and the answers. I looked up the At Your Survey download and it just seems way beyond what I'm trying to accomplish. Anyone have any suggestions?? Thanks in advance |
#2
|
|||
|
|||
Simple Questionnaire DB
Just set up a single table with the 32 questions and an autonumber. If it is a regular survey then you will need an indicator for each survey group and what about demographics? age, gender and whatnot. Then you can do your averages, distributions, cross-tabs, filtered forms, graphs. -- The 11th day of every month: http://truthaction.org/forum/index.php "Pixie78" wrote: I'm just looking for a simple database to input the results of a questionnaire/survey done by our employees. It was made in Excel but printed and handed out to the employees. There are 32 questions and the possible answers for each on a 1. Strongly Disagree 2. Disagree 3. Neither Agree or Disagree 4. Agree 5. Strongly Agree I'm not looking for anything fancy and I'm not looking to create these surveys in the database or anything like that. That's not my job function. I did get the task of having to tally up the results of this survey and there are others once in a while that are similar to it so it would be handy to have this little interface to zip through the tally process. I just wanted to see if there was an easy way to set up a form similar to the survey taken and run through it survey by survey and then run a totals query for the results. A tally, how many strongly agrees for question 1, 2 , 3, so on and so forth. The survey's are anonymous so all I have are the questions and the answers. I looked up the At Your Survey download and it just seems way beyond what I'm trying to accomplish. Anyone have any suggestions?? Thanks in advance |
#3
|
|||
|
|||
Simple Questionnaire DB
In article , Pixie78
@discussions.microsoft.com says... I'm just looking for a simple database to input the results of a questionnaire/survey done by our employees. It was made in Excel but printed and handed out to the employees. There are 32 questions and the possible answers for each on a 1. Strongly Disagree 2. Disagree 3. Neither Agree or Disagree 4. Agree 5. Strongly Agree I'm not looking for anything fancy and I'm not looking to create these surveys in the database or anything like that. That's not my job function. I did get the task of having to tally up the results of this survey and there are others once in a while that are similar to it so it would be handy to have this little interface to zip through the tally process. I just wanted to see if there was an easy way to set up a form similar to the survey taken and run through it survey by survey and then run a totals query for the results. A tally, how many strongly agrees for question 1, 2 , 3, so on and so forth. The survey's are anonymous so all I have are the questions and the answers. I looked up the At Your Survey download and it just seems way beyond what I'm trying to accomplish. Anyone have any suggestions?? Thanks in advance this is a quick example which may or may not work for you http://www.psci.net/gramelsp/temp/SurveyExample1.zip |
#4
|
|||
|
|||
Simple Questionnaire DB
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. To speed up the data entry put this in the "on change" event of the first box: If Len(Me![FIELD1].Text) 1 Then Me![FIELD2].SetFocus End If When you enter a single digit it will set the focus automatically to the next text box. Remember to change your fields names appropriately when you move to the next text box. -- The 11th day of every month: http://truthaction.org/forum/index.php "Pixie78" wrote: There's no demographics. Just an anonymous survey. Just a page with 32 questions and 5 boxes next to each questions with the rating of 1-5. I guess I'm having the issue of how to link the questions to the answer. It's like I forgot how to build a database today. lol. "scubadiver" wrote: Just set up a single table with the 32 questions and an autonumber. If it is a regular survey then you will need an indicator for each survey group and what about demographics? age, gender and whatnot. Then you can do your averages, distributions, cross-tabs, filtered forms, graphs. -- The 11th day of every month: http://truthaction.org/forum/index.php "Pixie78" wrote: I'm just looking for a simple database to input the results of a questionnaire/survey done by our employees. It was made in Excel but printed and handed out to the employees. There are 32 questions and the possible answers for each on a 1. Strongly Disagree 2. Disagree 3. Neither Agree or Disagree 4. Agree 5. Strongly Agree I'm not looking for anything fancy and I'm not looking to create these surveys in the database or anything like that. That's not my job function. I did get the task of having to tally up the results of this survey and there are others once in a while that are similar to it so it would be handy to have this little interface to zip through the tally process. I just wanted to see if there was an easy way to set up a form similar to the survey taken and run through it survey by survey and then run a totals query for the results. A tally, how many strongly agrees for question 1, 2 , 3, so on and so forth. The survey's are anonymous so all I have are the questions and the answers. I looked up the At Your Survey download and it just seems way beyond what I'm trying to accomplish. Anyone have any suggestions?? Thanks in advance |
#5
|
|||
|
|||
Simple Questionnaire DB
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] |
#6
|
|||
|
|||
Simple Questionnaire DB
"Pixie78" wrote in message
... I'm just looking for a simple database to input the results of a questionnaire/survey done by our employees. It was made in Excel but printed and handed out to the employees. There are 32 questions and the possible answers for each on a I have one that you might be able to adapt. Drop me a line at keith dot wilby at baesystems.com and I'll send you a copy (A2003). Keith. |
#7
|
|||
|
|||
Simple Questionnaire DB
Sorry officer but I feel I haven't broken the law in this instance. For ease of data entry it would be far easier to simply treat the questions as fields. Pixie doesn't state how many surveys have been completed or how often the survey will be repeated. What if there are 500 surveys or 16000 data points. If I understand it right having questions as records would require selecting the question in a combo box and then entering the response. A lot of very time consuming work dont you think? Or have I missed a point somewhere. Having said that Pixie may be better off considering using a web based portal. -- "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] |
#8
|
|||
|
|||
Simple Questionnaire DB
If I understand it right having questions as records would require
selecting the question in a combo box and then entering the response. not necessary. it's very easy to pre-fill a form with "answer" records where the question reference is already entered, with the actual question being displayed, and all the user has to do is run down the list, entering the answers. as John says, a short wide structure should absolutely be avoided. even though the Op says this is a "simple" survey, it will most likely be repeated at some point - and sure as God made little apples, somebody in management will want to put in new questions. easy to handle in a correctly normalized db, a nightmare in a short, wide structure. hth "scubadiver" wrote in message ... Sorry officer but I feel I haven't broken the law in this instance. For ease of data entry it would be far easier to simply treat the questions as fields. Pixie doesn't state how many surveys have been completed or how often the survey will be repeated. What if there are 500 surveys or 16000 data points. If I understand it right having questions as records would require selecting the question in a combo box and then entering the response. A lot of very time consuming work dont you think? Or have I missed a point somewhere. Having said that Pixie may be better off considering using a web based portal. -- "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] |
#9
|
|||
|
|||
Simple Questionnaire DB
Am I thinking that questions can be entered into a table and then use it for a query that can then be used as the source for the form? |
#10
|
|||
|
|||
Simple Questionnaire DB
um, not quite. keep in mind that any table storing "answers" must include a
reference to a specific question in each record. it's just a matter of populating the answers table "all at once" for each parent survey record, then entering the answers manually from the paper media. here's an example of how i use this setup daily in my job. i have to enter test values in a database. each "batch" of material is put through several different tests, and the test value of each test must be recorded for each batch. so i have a table listing all the tests (a supporting table). i have a parent table to enter each batch, by batch number, date issued, material type, etc. i have a child table to hold each test value for each batch record, linked to the pk of the batch table, of course. the pk from the tests table is used as a foreign key in this child table. my data entry setup: mainform, bound to the batches table, subform bound to the child test values table. when i enter a new batch record in the mainform, code runs to automatically append a record into the child table for each batch test listed in the supporting table. the append query appends the pk value from the batches table and the pk value from the tests table, into the foreign key fields in each record. then the subform is requeried. so now it contains an "answer" record for each test belonging to the mainform batch record, though the test value field is blank in all the records, of course. all i have to do is tab into the subform and Enter or Tab from record to record, typing in the appropriate test value in each record. i use a combo box control in the subform, with RowSource the tests table, to display the "text" test name. the combo is disabled and locked because i never choose a test manually - they're always preloaded. if i delete the batch record in the main form, the child test value records automatically get deleted of course. i also use code to check the child records before leaving the subform; if none of the subform records has an answer (test value) recorded, then all of the subform records related to the current mainform record are deleted. for my specific needs, i went a step further and included code to "re-load" the test answers records for the current batch record in the main form, so i can delete some or all of them from the subform if necessary, and then re-run the append query to re-add the missing records. there are also some "grouped" tests where there are two or more possible tests but i will enter a test value for only one of the group, and i have more code that automatically deletes the "un-used" test record(s) when i exit the subform. you can get about as creative as needed for this kind of setup, but for the op's data entry purposes i think a simple append query would probably be sufficient - no need to get fancy! hth "scubadiver" wrote in message ... Am I thinking that questions can be entered into a table and then use it for a query that can then be used as the source for the form? |
Thread Tools | |
Display Modes | |
|
|