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

Comparing values from different records

Comparing values from different records Icon
I'm not sure exactly what is the best way to do this, so I have this under queries . I have a listing of survey responses from year A. I have another listing of survey responses from year B. Both are in the same table with a unique record - names and years are separate related tables. What I need to be able to do is find out if each individual's answers to questions X and Y changed from year A to year B and then count how many changed. In other words, I need a way to say that # individuals changed their answer in question X and Y from year A to B. Is there a way to query this

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?

Multiple entries wanted in Form

Multiple entries wanted in Form Icon
I am needing to create a form that will allow data entry of a survey. On this form I have set up survey date and location which are always unique to the survey. I also need to set up a way to enter an unknown number of survey results normally 1-5. The survey results are limited to defined results that are already in a table. I have set up a junction table between the survey table and the results table using each tables primary key. I am having no luck getting multiple entries of the results on the form.

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?