Need to create an exam in Infopath that can calculate answers and send notification to a user if preferable or allow admin to check on a seperate form
Posted on 2006-06-22
I have been given the task of creating an exam using Infopath that staff take in a test room.
The exam is all multiple choice questions. As well as the form, there needs to be a way of administrators going and seeing (or being sent) the answers plus a calculation of how many were correct.
The only way I can think of this happening is to have a form which pokes the results inot a database....then another form takes the results and compares them with a seperate table (with the correct answers) and then gives an output.....this is a bit beyonde my experience with Infopath though.
Can someone give me an overview of what I need to construct and how to architect it? We have SQL server 2000 and Infopath 11 (2003), and run a 50-noce W2k3 domain.
Alternatively, does anyone know of another method of getting this to work?