Quiz DB

[BenJones]

I'm trying to make a quiz database using access 97. I need a bit of advice.

Do I need a seperate table for quiz questions and answers or should I put the correct answer with the question in the question table.

Bearing in mind the quiz is going to be multichoice.

Any help would be appreciated, especially example db's

Thanks

 

[Mile-O]

Example DBs like this, for example?

 

[BenJones]

That's it!

Cheers, just what I was looking for

 

[TimE]

This database looks like what I am needing to do. I need to have:

1) tblMain that has Name, QuizDate, and Score

2) A way to be able to log in if name exists in tblMain

3) Record score and date in tblMain after Quiz is complete



Thanks in advance for any help you can provide!