467,104 Members | 981 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,104 developers. It's quick & easy.

multiple choice questions template in msaccess

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). xxxxxxxxxxxxxxxxxx
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
Aug 13 '08 #1
  • viewed: 8257
3 Replies
Expert Mod 2GB
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.

Aug 20 '08 #2
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.

Aug 27 '08 #3
Expert Mod 2GB
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

Aug 27 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Graham | last post: by
1 post views Thread by Brian Byrne | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.