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