Create database

[Chas]

Hi all. I am trying to create an exam database where i can
input hundreds of multiple choice questions and when
ready, have it print out an exam. Each question has 5
possible answers, one of theme obviously being the correct
one. As I am new to this, any guidance would be greatly
appreciated!!

Thanks

 

[Larry]

-----Original Message-----
Hi all. I am trying to create an exam database where i can
input hundreds of multiple choice questions and when
ready, have it print out an exam. Each question has 5
possible answers, one of theme obviously being the correct
one. As I am new to this, any guidance would be greatly
appreciated!!

Thanks
.
In one table create 2 fields

field 1 = (Primary key) question number
field 2 = question

In another table create 3 fields

field 1 = question number from table above
field 2 = answer
field 3 = correct (yes/No)
set up a relationship between the two tables on the
question number field.

Enter the question in the first table
Enter the answers in the second table and check the one
that is correst so you can later use it to grade papers

 

[Duane Hookom]

You might want to check out the At Your Survey application at
http://www.rogersaccesslibrary.com/OtherLibraries.asp. You could easily
modify the structure to similar to Larry's response.

 

[Lori]

Duane,
I have downloaded your survey database and am using it in
Access 2002 (Office XP) to create a survey that I use
with the teachers/staff in my school district. Some of
the questions require that they choose multiple responses
(all that apply) from the list given. How can I make
your survey application allow multiple answers to chosen
from the list of pre-defined responses?
Thanks!!

 

[Duane Hookom]

A multiple choice question is the same as multiple yes/no questions.

 

[Lori]

I understand that the questions are multiple choice (i.e.
choose from a pre-defined list of answers). I wanted to
know if there is a way to allow more than one answer to
be selected from that pre-defined list.

Thank you for your help.

 

[Duane Hookom]

At Your Survey doesn't support multi-select for a single question. If you
have a question like "Select colors you like" with possible responses like
"Red", "Green", "Blue". You would need to create three separate yes/no
questions: "Do you like Red", Do you like Green", "Do you like Blue".