quiz database

[Neil Mansell]

hi all,

i just wondered if i could pikc any of your brains out there and ask whats
the wasiest way to make a quiz-type program using ms-access.
so i can create or import questions and it has a onscreen (with timer and 4
selection buttons) with the selection result being dependent on the
table(s)/correct answers.

i am a medium access program but haven't got a clue for this. can anyone
help.
this is just for fun!!!

regards,

Neil

[pietlinden]

Recycled answer from the NG:
Tom van Stiphout Dec 26 2000, 5:53 am show options
Newsgroups: comp.databases.ms-access
From: [e-mail] (Tom van Stiphout) - Find messages by
this author
Date: Tue, 26 Dec 2000 13:45:45 GMT
Local: Tues, Dec 26 2000 5:45 am
Subject: Re: Need help: Computer "Quiz" type database problem
Reply to Author | Forward | Print | Individual Message | Show original
| Report Abuse

On Tue, 26 Dec 2000 00:38:14 -0700, azscorp <[e-mail]>
wrote:

It all depends on your database design, which you did not elaborate
on. I'm afraid with a table of 17 fields (I'm guessing one for each
question) you're going in the wrong direction. Spend more time on
achieving a perfect 3rd normal form database design before building
anything else.
We have a similar database, with at least 5 tables:
Tests, Questions, Answers, ResultQuestions and ResultAnswers. The
latter 2 contain similar data to Questions and Answers, but contain
the data AS IT WAS AT THAT TIME, since the questions and answers may
change over time. Answers has a field indicating which one is correct,
and ResultAnswers has both this field and a field to store the user's
choice. With a select statement you can find all answers where Correct
= Chosen.

-Tom.