Hello AccessForums.net!
I am writing on behalf of the City of Kalamazoo. We currently have a FoxPro program that was developed to allow employees from the Transportation department to key in test answers from hard copies of tests they administer to potential bus drivers. Once keyed in, the test answer data can then be calculated by the program and stored in a database. The program prints out a "results" sheet with the test takers overall score and how well they did in each section.
The FoxPro program was developed by an employee who no longer works here. We do not know how exactly he coded it or where the test data is being stored.
My question is: Is it possible to create a form in Access 2003 that would allow someone to key in test answers and then Access would crunch the numbers to display a "results" page, as well as store those results in a database?
Basically I just want to recreate what the FoxPro program does, but do it using Access 2003.
Thanks very much for your time!!! I really appreciate everything you guys do!
(I have screenshots of the FoxPro program as well as a copy of the "results" page if you would like to see them)
-Phil Hajek
City of Kalamazoo, IT