How do I show only aggregate data for survey responses?
The structure of the data is as follows:
Each respondent's survey is on a separate row
Each column contains the answer to a single question
All answers are constrained to a list of choices (e.g., Best, Bad, What I'd like to do is to build a report that shows the percentage of responses to each question. So, for example:
Question #1: What did you think of our product?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
jpg (zipped since forum says new users can't post images) with the current relationship structure that I have. I have removed the Surveys table as there isn't a need formore than one survey any time soon.
Many of the survey questions are set up in sets like below (example only). Each question (Fruit 1-3) uses the same list of possible responses and the responses need to be ranked (Fruit 1= most preferred fruit, Fruit 3 = Least preferred).
List Your Top Three Fruits
Fruit 1: Apple
Fruit 2: Pear
Fruit 3: Orange
Because of this, I have set up an extra table with question categories. Otherwise, I would be storing a lot of redundant values if I had a table with only the QuestionID and PossibleResponses (some sets of questions will ask for as many as ten user responses that use the same set of possible responses)
I want to be able to join the Possible Responses table (SrvQPosResponses) to the table where the Survey Responses are stored (SrvResponses).
The At Your Survey database does not join these two. Don't I want to join them so that if I change a possible response, it will be updated in the survey responses as well (say if I want to rename Apple to Apples).
1) SAN Name - The name of the SAN.
2) Aggregate Name - The name of the Aggregate, within the SAN.
3) Used - The amount of space used within the Aggregate
4) Total - The total amount of space in the Aggregate.
5) Date - The date the data was captured.
For example purposes, I currently have 3 sets of this data (03/01/2012, 09/01/2012, 16/01/2012). The only data that will change is the 'Used', 'Date' and possible the 'Total' columns.
What I would like is a query to run to show the 'different' between each SAN/Aggregate name (all the data will be held in the same table), so would expect to see an additional line everyadditional week there is data inputted; something like the below would be the ideal output.
SAN 1, Aggregate 1, Used -100, Total -0
SAN 1, Aggregate 2, Used 12, Total 50
SAN 2, Aggregate 1, Used -400, Total -0
I was thinking something like a bar chart that would have the names of the questions along the x axis and a count of the responses along the y axis.
each question would have 4 bars one for each of the answers (strongly disagree, disagree, agree and disagree). the aim would be to allowmanagement to see where the strong points and weak points across the board.
I have data for 100 survey studies in excel that have already been broken down into 3 datasets. Study# uniquely identifies each survey, and is the same value across the 3 datasets. I washoping to be able to link all three data bases based on study#.
Below, I outline what is in each dataset, how I think I should be normalizing the data, and at the end describe how I think to combine the 3 data sets:
each study can have multiple responses for country, audience and database, In excel it would look something like:
I am working on a survey form for my office. We have 5 departments, there are 12 questions that our customers are to answer with choices from a combo box,
My question is: Can I do a summary report by department which gives a count of the responses for each of the questions (ie: 5 Excellent, etc.)? I am nearlycertain it can be done, and I have tried several approaches, but I'm not getting the results I expect.
The way my tables work, the ID is an autonumber. The next column is the survey number (since this cannot be duplicated). The student numbers are individual. The following can be duplicated: Date of Birth, Teacher name, Maiden name, Entry date.
How do I set up the relationship so that when someone enters new data in that the tables are linked?
There is no guarantee that whoever enters the data will not abandon data entry at any point during the data input.
Also, I am using Access 2007. Which of the following links should I be using if I wanted to use if I wanted to use Duane Hookom's "At Your Survey":
I have one survey (which will not be repeated, and there will never be more than one survey). I am the only person who will input the data (from either web input form converted to csv or Excel, or from returned paper surveys).
I have not inputted any data, as I want to get the design correct/normalized etc before doing so.
I have set up tables according to info on these forums: ie separate tables with PK/FK etc for Respondents/Questions/etc etc. However, I am still confused about the Answers (Response Options) table; many questions are multiple choice, eg.
Yes/No; Strongly Agree to Strongly Disagree etc etc. But I don't know how to put this in a table, because although some questions have answers unique to them, some have answers in common with other questions (ie Yes/No). I also want to capture no responses.
Do I list each and every possible choice, somehow linking it to the question; eg Q1a 1 Yes, Q1b 2 No; OR do I make a different column for each type of response, and then use lookup tablesto reference, or an "Age Range" field?
There are 13 possible questions but not every question applies to every survey combination.
What I've done is to have a table with:
ResponseID - ProjectID - Name(person filling in survey) - ScoringWho (the role of the person they're scoring) - Q1 - Q2 - Q3 . Q13
As far as I can see the alternative is to have 1 row with every possible combination of response. But it means that every time data is entered 3 rows have to be filled. What's the better way to go about this?
1 Q1 D
1 Q2 S
1 Q3 N
1 Q4 VD
1 Q5 S
1 Q6 VS
1 Q7 Yes
2 Q1 VS
2 Q2 S
2 Q3 N
2 Q4 N
2 Q5 S
2 Q6 VS
2 Q7 No
I’ve been using Excel with named ranges and Vlookups to create a dataset with the 7 questions listed in separate columns with one survey per row like this (abbreviated to simplify example):
Survey Q1 Q2 Q3 Q4 Q5 Q6 Q7
1 | D | S | N VD S | VS Yes
2 | VS S | N N | S | VS No
so the Q1 column is the Answers to survey questions 1.
I am attempting to switch my process from Excel to Access 2007, but I'm having trouble getting results I need with one row per survey and answers to each survey question in a separate column.
I can get the results for answers to one question; however, I knew it wasn't that simple, but I don't know what I need to do. I think Ineed to create a new field with the expression in the field name, but I can’t figure out how to make it work.