Yikes I inputted data but now I am stuck

[issy8689]

I just inputted 1000 surveys into an Access database. The survey had 17 questions with choices of Yes Definitely, Yes I think, No I don't think, No Definitely, Not Applicable. I would like to work with the data and make some comparisons but I am really really stuck. Is there a pay per problem area here. :banghead: Any help would sure be appreciated.

 

[jdraw]

No pay area, but lots of readers.

I just inputted 1000 surveys into an Access database.

Did you design the database? test it?

In plain, simple English give readers a little background, and describe the current status a clearly as you can.

 

[issy8689]

Ok, I will try my best. I made a table in Access and each field name was one of the questions and let the Auto ID give a number to be used as the Primary Key. There were 5 questions concerning person filling out survey. Example, How long have you been using Home Care? I then used Look up Wizard and added the 5 choices, 0-3 months, 4-6 months, etc. Then there were 17 questions all with look up wizards with the same choices, Yes, Definitely, Yes, I think, No etc. I thought I was clever in doing it this way but I am doubting myself now that I would like to work with it. I have done Query's for different age groups, that worked slick!

 

[jdraw]

So, what is the issue exactly that caused you to seek help for pay?
What is it you want to do but can't?

 

[issy8689]

I would like to sub total some of the questions. For instance, Question 6 The nurses listen to me? 600 answered Yes, Definitely, 40 No, Definitely.

 

[gemma-the-husky]

as a start, do a totals query. That will show you how many of each answer type you have for that particular question.

in the access query design window click the large sigma (greek E).

I presume your access table just has (at least) 17 columns though, one for each question. That isn't really the optimal design for a dbs.

The table should look more like this - much easier to work with.
(sorry - hard to line stuff like this up)

respondent QuestionNumber Answer
fred 1 Yes
fred 2 Maybe
fred 3 No

mike 1 No
mike 2 Maybe
mike 3 No

rather than

 respondent    q1    q2    q3
fred             Y     M     N
mike             N     M     Y

 

[issy8689]

Can I still do this with the data I have?

 

[issy8689]

I also don't know which to group by. Should I replace all the choices, example, Yes D with a number 1 etc. I appreciate your patience

 

[gemma-the-husky]

SELECT mytable.question1, Count(mytable.question1) AS responses
FROM mytable
GROUP BY mytable.question1;

change the table and field names to match your table, and then copy/paste this as SQL. THEN, you should be able to switch to query design view, to see what the query looks like

try it, to get familiar with queries.

this sort of structure will give you a query that shows the answers and number of answers supplied for a single question. Combining this sort of thing for multiple questions will start to get tricky, I think.

to get answers for a different question , select a different question.

copy your database first, as having entered 1000 questionaires, you certainly wont want to lose your data.

 

[issy8689]

It worked beautifully!!! Thank you sooo much!

 

[gemma-the-husky]

pleased it's making sense.