G
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!
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!