Database that finds typing errors by comparing what's typed to a sample in database?

[sarahms2201974]

Hi,

I'm attempting to create a database that holds a simple typing test and I'm having some trouble setting it up.

I've created a table that holds 5 test samples. The thought is when someone takes the test they will be given a printout of one of the five samples. They will enter the test sample # in the test form and then complete the test by typing what's on their printout.

I need to figure out a way to compare what's typed in a field with what should be typed in that field based on the test sample...I need to come up with a count of all fields typed incorrectly.

Any help getting started with this would be GREATLY appreciated!!

Thanks!

[NeoPa]

Unless they're very short they would have to be stored as Memo fields.

A database doesn't spring to mind as the most appropriate method of doing this.

Unless of course you plan to hold the data in a special way that you haven't shared with us. What thoughts have you had on the issue yourself so far?

[nico5038]

Looks a simple task, but isn't really.
I would check upon a product (e.g. like http://www.freediff.com/) to use by creating from the basic table holding the correct text and the typed sample two files in .txt format and activate this application.

Nic;o)