Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009

    Keying in Test answers to Access DB from Written Test


    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 to produce a final score 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.

    Basically I just want to recreate what the FoxPro program does, but do it using Access 2003.

    I have the answer key and I am making a form so that you can simply key in what the test taker has answered on the written test.

    The person keying in the written test answers has to do this frequently and since she is a typist she would like to be able to quickly key in what the test taker wrote down without having to do any clicking.

    What form controls should I use so that she does not have to click any thing? More importantly, what coding do I need to do in order for the typist to be able to type in all the answers and have them added to a new database for each test taker? The test is all multiple choice so either 0,1, or 2 points are awarded based on how they answer the question.

    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

  2. #2
    NassauBob's Avatar
    NassauBob is offline Not THAT Green
    Windows Vista Access 2007
    Join Date
    Feb 2010
    Augusta, GA
    Wow! It sounds like someone ELSE may be building themselves some job security - kudos to you!

    And yes, screenshots are always good! If we can help you, we will.

  3. #3
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    hard core data entry; where the typist looks at the source paper and not the screen - should be accommodate with the tab movement from textbox to textbox....set up the screen form in the exact same order as the paper form and make sure your tab order is correct....and it should go very fast. typists use the tab button and not the mouse....

  4. #4
    Join Date
    Oct 2009

    Adding Form data to a database

    Once I have my form set up, how do I insert the data that is keyed into a form control into a database? Or if I store values into radio buttons on the form, how do I add those values into a database? More specifically, what settings / code do I need to accomplish this.


Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-30-2010, 04:45 PM
  2. Replies: 16
    Last Post: 01-13-2010, 04:31 PM
  3. Keying in Test Answers from Hard Copy
    By CityOfKalamazoo in forum Forms
    Replies: 4
    Last Post: 12-07-2009, 12:44 PM
  4. download test file from WS_FTPin Access VBA
    By dollygg in forum Access
    Replies: 0
    Last Post: 07-28-2009, 08:08 PM
  5. Replies: 0
    Last Post: 12-01-2008, 03:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums