HELP: Test Database

T

Tim

Access 2000

I have a database that holds questions and answers to a test.
Table 1 contains: Question#, Question Text, Category (Multiple Choice or
True/False)

Table 2 contains the multiple choice answers: Question#, A,B,C,D

Table 3 contains the true/false check list: Question #, true, false
(the TRUE & FALSE columns are YES/NO conditions).


The problem I am running into is combining these tables into a single report.
Do I need to make the true/false section into a sub-report?
If that is the case I need MAJOR HELP, becuase every time I try to make a
sub-report it is always blank.


Thank You.

TIM
 
S

Sharkbyte

Tim:

It sounds like you are close, but I think your 3rd table is constructed
incorrectly. Try this:

tblQuestions
QuestionNumber (PK)
QuestionText
QuestionType (Identify the question as TF or MC)

tblAnswers
QuestionNumber (PK) (FK)
Answer (True/False, A-B-C-D, etc.)

tblUsers
UserID (PK)
UserName

tblUserAnswers
UserID (PK) (FK)
QuestionNumber (PK) (FK)
UAnswer

Then simply compare tblUserAnswers.UAnswer against tblAnswers.Answer.

Good luck.

Sharkbyte
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top