Acces Project

[radiaz via AccessMonster.com]

Hello guys,

I'm working on a project for school and I need to do this in either Excel or
Access, but preferebly Access.

Here is the challenge

There are 6 questions total. Each questions have multiple choices like for
example ( Not a real question)
1. What color is the sea?
a. Green
b. Blue
c. Light Blue
d. Brown
e. Yellow

There are six questions total with its multiple choices

I will hand out this questions to students, perhaps 36 students.
Each student will answer them. There is really not a right answer so anybody
could answer any of them. A person is only allowed to pick one answer.

What I want to do is when I get the questions from everybody, I will enter
the answers into (Whatever I choose to do this), then I'd like to get let say
for example how many people chose letter a, or b, or c, or d, or e for each
question. The I'd like to get a percentage. It will look like this.

Question 1

Anwers #People %Percentage
a 10 28%
b 5 14%
c 5 14%
d 10 28%
e 6 17%

Remember there are 36 people but it could be more. If that happens then the
answer will be divided by that "whatever number" so to get a percentage.

I'd appreciate any help you can offer,

Thanks
Rita

 

[chornish]

Hi,
I dislike offering this without full knowledge of what type of "school
project" this is but --

I will first offer that you can take a look ath this site:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
At Your survey 2000 - may be of some help to you to get some of the basic
table design needs.

Please post more detail about this and more specific questions.

Craig Hornish
chornish at cap-associates.com (feel free to contact me directly - I am
interested in this type of database)