exam

[Garlandengineer]

I have a database of questions and answers that are arranged by the
chapter that they come from. The table for the Q&A has a column for
the question, answer, and the chapter number. There are about 1800
questions and 30 chapters. I am trying to make the database make exams
over the material. I need to be able to select which chapters it pulls
questions from, how many questions will be on the exam,tell it how
many questions to pull from a particular chapter, and have it pick
random questions from each chapter that I select. I also need it to be
able to make several exams during one session without picking the same
questions twice.
At the end I would like it to make a Word or Excel with the exam on it
so that I can edit stuff If I don't like it.

I have done a good bit of work on Access before but this is pretty
hard, and I'm stumped.

Thanks for the help!

 

[Roger Converse]

What exactly are you looking for assistance with?

First, I would design queries that pull questions for a test by chapters.
You may need to insert a unique ID by chapter to help with the random
question generation without pulling the same question twice. Once you have
your queries or set of queries created, you can generate a report and export
it to word. If you are able to keep the test formats consistent throughout
all 30 chapters, you will only need one report. If the material doesn't lend
itself to that, you may haev to create a separate report for the different
tests. So you may haev a report for chapters 1-4, 5-8...

Depending on how user friendly you would like it, you could also create a
form for selecting the chapters or tests youw ish to generate.

It doesn't sound like the project is too big. Just jump in. )

Thanks,
Roger

 

[Anthony]

What exactly are you looking for assistance with?

First, I would design queries that pull questions for a test by chapters.
You may need to insert a unique ID by chapter to help with the random
question generation without pulling the same question twice. Once you have
your queries or set of queries created, you can generate a report and export
it to word. If you are able to keep the test formats consistent throughout
all 30 chapters, you will only need one report. If the material doesn't lend
itself to that, you may haev to create a separate report for the different
tests. So you may haev a report for chapters 1-4, 5-8...

Depending on how user friendly you would like it, you could also create a
form for selecting the chapters or tests youw ish to generate.

It doesn't sound like the project is too big. Just jump in. )

Thanks,
Roger

Thanks for the help Roger. Or more of thanks for the encouragement. I
have got a good bit done on it. I gave all questions a random number
and then using a query I can have it sort ascending and return only
the number of questions that I want. I can manually change the number
of questions that are returned to double the number on an actual exam
and split it to make 2 exams and to ensure that there are no
duplicates. I also made a table that has all the chapters and a yes/no
column. The random sort query is linked to this table as well as the
questions table, and a simple criteria in the yes/no column will
eliminate any chapters that I didn't select.
I learned a lot. I'm still learning Access. VB is the part that I
really don't understand. But so far I have not had to use it.

 

[chahere]

fo kiou

"Roger Converse" <[email protected]> a écrit dans le
message de groupe de discussion :
(e-mail address removed)...

 

[خالد الكومي]

بنت صغيره لسه ÙÙŠ سن المرهقه صاحبت شاب وضحك عليه غلططها
اضيتها عشتها حيتها ظبتتها ونسيت تربيتها
قدره ان كل وحوش الدنيا اتلمو عليها
دلوقتي بقت حيتها انها
تعر٠واحد علشان جنيه
وتعر٠واحد علشان جوان
ويجي واحد اخر الليل
علشان ياخد الحنان