database structure/design

[Kaylen]

I want to create a database so that users can enter scores for a list of
questions. The user will enter their name, the date, and then go on answering
a list of questions. The answers are scores: 0,1,2,3,4, and NA. Later I want
a report showing all the questions and the answers for a certain test with
the average of the scores for example, the average scores for question 1
through 4, etc. However the main problem is how would I design the database.
I want to have the user see the list of questions and be able to fill in new
scores for them every time they take a test. I started out having a table of
questions, a table for tests, and a table of answers. But then I don't know
how to link the question to the the table of answers. I don't even know if
the design structure is correct. Any advice on this problem is greatly
appreciated.

 

[Allen Browne]

Duane Hookom has a sample database illustrating how to do a survey.

Download from:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

 

[Kaylen]

The link you gave me does not work. Can u tell where exactly to find a sample
survey dtb? I think a sample survey dtb is what I need.

 

[Kaylen]

I found the sample survey from the link. Thank u. However, The structure is
way too complicated for my understanding. I will try to figure it out at work
on Monday. My database is actually an audit database with standards and
scores 0-4, and N/A only. I need basic simple explanation, like what tables I
need to have and how to link the questions to the answers tables so that the
auditor can see the questions while scoring the standards. Awww.....I feel so
lost trying to figure out the structure.

 

[strive4peace]

Hi Kaylen,

for better understanding of the basics of Access, download and read this:

Access Basics (on Allen Browne's site)
http://www.allenbrowne.com/casu-22.html
8-part free tutorial that covers essentials in Access

Allen has a wealth of information on his site; after you get to the
bottom of this link, click on 'Index of Tips'

Warm Regards,
Crystal

*
have an awesome day
*