×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

on-line exam

on-line exam

on-line exam

(OP)
I am looking for assistance to develop an online testing program...I have been able to create a front end in Access that will allow the user to enter his/her responses to questions but I am not able to get Access to grade the exam.  Is there an easy wat to do this?

Thanks,

Mark Tuttle

RE: on-line exam

Hi there,
I think the easiest way to do this is to make your answers multiple choice or true/false types. Then you could use option groups and assign a value to each answer whereby access could calculate a numeric grade for the test.

Hope this helps :)

RE: on-line exam

(OP)
Jelloshot1,

Thanks for taking the time to reply to my request.  What I have set up is multiple choice and true/false.  The use of option buttons allow for the easy entry of Reponses to the question.  What I want is for Access to auto grade the responses. Over the course of the past few days I have been able come up with a solution using the IFF function.  It goes something like this...

       Iff([inputA]<>[AnswerA],-1,0)

This expression is placed in a field of a query and it makes a comparison between input and answer then assigns a value of -1 if the expression is true and 0 if false.  All the -1 then can be added and subtracted from the total number of question to generate a grade.

You wouldn't have and idea on how to get Access to auto e-mail grades back to respondents would you?

Thanks,
Tuttle2

RE: on-line exam

Hiya Tuttle2,

Wish I could help you with the auto e-mail, but that is really beyond me. Possibly with some code it could be done. Hopefully someone else out there can help you with that.



RE: on-line exam

Hi JeloShot1

I reply to sending e-mail in access

I spent a lot of time looking into this.  
if you are useing microosoft exchange it's no problem.  
use the SendObject object it simple to figure out.

if you use Notes and the admins have MAPI turn off Good luck.
sample code from help file

DoCmd.SendObject acSendTable, _
                "Employees", _
                acFormatXLS, _
            "Nancy Davolio; Andrew Fuller",_
                "Joan Weber", , _
            "Current Spreadsheet of Employees", , False


Good luck
Kyle Gaynor

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close