Topics Search

How do I show only aggregate data for survey responses?

How do I show only aggregate data for survey responses?
Views: 9
I'm trying to develop an Access 2007 report that will allow me to analyze and aggregate raw survey Monkey survey data without displaying the individual responses to each question.

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?
Best: 25%
Good: 50%
Bad: 25%
Poor: 0%
Sponsored Links:

Similar posts...

 

Survey Database Design - hit a snag

Survey Database Design - hit a snag Icon
I am working on a Survey / Questionnaire database and have hit a roadblock. I am trying to follow a design that mirrors the At Your Survey database in Roger's Access Library that has been recommended on these forums.

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).
 

Subract access Query

Subract access Query Icon
I have a database where, on a weekly basis, I will be entering around 20 lines. The columns are exported in from excel, with the date they were entered. A definition of the columns used are below.

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
 

chart with multiple serieS

chart with multiple serieS Icon
I am developing a survey application that has 4 questions with responses. the responses are strongly disagree, disagree, agree and strongly agree. I would like to make a chart of some type in access that would show the over breakdown of the questions and the total answers.

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.
 

Relational database concept example

Relational database concept example Icon
And have been tasked with (what I hope to be) a fairly simple relational database problem. to get some feedback on whether or not this is a simple enough task for someone new to access, and 2. understand if this process seems correct.

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:

dataset 1:
each study can have multiple responses for country, audience and database, In excel it would look something like:
 

A survey issue

A survey issue Icon
I guess this is a pretty basic problem and I know when I hear the answer I will kick myself, but.
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.
 

Question setting up tables for a survey

Question setting up tables for a survey Icon
What is the best way to create tables for a survey. I have inherited a survey (in excel). I need to get it into Access. Unfortunately, there are more than 255 fields (more like 400). I've separated the survey into 6 tables.

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":
 

More Questionnaire

More Questionnaire Icon
Hi; have searched and read forums for Questionnaire/Survey design,

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?
 

Round robin survey design

Round robin survey design Icon
I've got a survey that goes out to 4 people. Each survey is asking the people to rate aspects of the other 3. For instance an architect might be scoring a contractor in terms of health and safety.

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?
 

Query to populate data from rows to columns

Query to populate data from rows to columns Icon
I have been given survey data with questions in one column and answers in another column. Each survey has 7 questions and therefore each survey is listed on 7 rows like 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.
 

Use Access 2007 Aggregate Functions

Use Access 2007 Aggregate Functions Icon
The Access 2007 aggregate functions calculate values over a range of data. The totals row is new with Access 2007 and makes it easier to use aggregate functions such as averages, counts, sums and totals. You may still use these functions in queries and Visual Basic Applications as before but the "Totals" row is generally faster. The following tutorial will show how the use the Access 2007 aggregate functions.