multiple choice questions template in msaccess

[mb60]

hello
I am working as teacher. Pl any one can help me in creating a template for multiple choice questions, and matching questions and selecting the answers in ms access? The format of qns as follows
1). xxxxxxxxxxxxxxx xxx
1) aaaaaaaaaaaa 2) bbbbbbbb
3) cccccccccccc 4) dddddddd
2) Match the following
List - I List -II
A) aaaaa I) bbbbb
B) ccccc II) ddddd
C) bbbbb III) aaaaa
D) dddddd IV) ccccc
V) eeeeeee
Choose the correct
1) A-III,B-IV,C-I,D-II 2) A-III,B-IV,C-I,D-V
3) A-II,B-IV,C-I,D-III 4)A-III,B-V,C-I,D-II

[Stewart Ross]

Hi mb60, and Welcome to Bytes! I wish it was possible to give you a solution to what you ask, but the use of Access is really not going to help you much for the production of multiple-choice papers. Relational databases are really at their best in modelling multiple relationships between distinct named entities represented as individual tables, each comprised of columnar attributes given distinct names. The production of multiple choice question papers is more a matter of presentation than of data storage, as the number of distinct entities involved is fairly small (entities such as test paper, question, response - and that's about it). The presentation format for multiple choice questions is not a natural one for Access (or any other relational DB) and may require bespoke VBA coding to implement.

It is possible to devise rigid question formats which could be implemented more easily (e.g. by restricting questions to have the same number of responses in all cases, say four) but the rigidity of such approaches makes the resulting test paper very inflexible and leads to artificial choices of distractor responses simply to make up the numbers.

In my opinion, Access is not the right choice. There are purpose-designed application for the production of multiple choice question papers, but in their absence it is more time- and cost-effective to use Word or some other text presentation tool than it is to use a database to prepare multiple choice papers. When I used to prepare test papers myself I simply used Word to do so - no databases at all.

-Stewart

[mb60]

Thankyou sir.for your suggestion.

recently by using msaccess I created multiple choice format. but I unable to select the question to generate the paper. if you permit me I'll send to for your perusal.

mb60

[Stewart Ross]

Hi. I have sent you a private message in which I have provided my e-mail address if you wish to send me a copy of your DB. I can't promise to resolve the problem for you but I'm happy to have a look at it if this might help

-Stewart