Quiz Test Maker

Did this work? Have you done this? I was looking at doing something
similar. If you got it to work I would be interested in the file if you
wouldn't mind emailing it to me at . If it is a huge
file, let me know and I can get a different email address that wont bounce it.

Tony Dondero

"Duane Hookom" wrote:

I would start by taking a look at the demo application "At Your Survey"
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. You
could add some functionality to sort using Rnd() function.

--
Duane Hookom
MS Access MVP
--

"Senexis" wrote in message
...
Hello,

I'm trying to create a database that will be used for creating unique
multiple choice tests based off of a list of questions and answers.

Pretty simple concept but I want to be able to generate random question
sets
based on the question grouping, and then since this is a multiple choice
test, be able to generate each question with a different stacking of
answers.

I figure I should create three tables.

1, (tbl_Student_data) being the student data.

2, (tbl_Base_questions) being the table that stores the question, the
correct answer, and "obvious distracter" (dummy) answers plus any other
question data like the section the question comes from.

3, (tbl_Student_Questions) being the main table that I work off of for
student test interaction form, reports, etc.

My idea is that a test admin would be able to use a form to generate
questions from the tbl_Base_questions, coupled with the data from
tbl_Student_data to make a unique test each time, and then be able to keep
that test to later have the student be able to either take the test based
off
of those unique questions on a secured front end version of the DB, and
also
be able to run calculations, reports, and etc off of as well.

My problem that I run into is, how do I get random records from individual
question groups (they're say 50 sections of test material 001-050 and
within
each group there are individual questions pertaining to that
group/section)
that add up to the total number of questions the Test Admin decides to
make
each test. (I can always just have a choice of preset total question
tests
as well) And then randomly sort all the answers for each question making
for
a "unique" test each time.

I figure the answer to this might be if at the time of generating test
records to the tbl_Student_Questions, I have records set in the
tbl_Student_Questions to be an auto-number random, there by after the
append
query gets done merging the tables tbl_Student_data and
tbl_Base_questions,
each record appended would have a random number that I could later do
something with. None the less, the goal is to be able to pull random
questions from all question groups (sections) for a total either defined
by a
test admin or set number and for each of these questions be able to have
randomly stacked multiple choice answers, while still being able to base
editable forms, queries, reports, etc!

Is there a simple solution to this?

Thanks!