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

Efficient way to design a Data Entry Form with 100 questions

Efficient way to design a Data Entry Form with 100 questions

Efficient way to design a Data Entry Form with 100 questions

Hello all,

Need your expert on efficient way to design a form.
I have constructed an interview questionnaire with 100 questions. The table structure is:

Question_number (range from 1 to 100)
Score  (3 choices, either 1, zero, or blank)

The first five fields will be repeated 100 times per one questionnaire.

My questions are:

1. What is the most efficient way to create a data entry form?  I would like the person who perform an input, can finish one questionnaire as soon as possible.

2. Should I just create 2 fields in the form? It will work for the first 100 (to repeat the same information.) Record # 101 might be different because of different interviewer and different supervisor.

3. I need to create the table this way because I can create a report based on specific question number.

Any advices from the experts?  I use the Wizard to create the form. I use ACCESS 2000, not 97. Thanks.

Ike T.

RE: Efficient way to design a Data Entry Form with 100 questions

I am slightly confused by what your have written. Surely it would be far more efficient to simply have a table containing the fields for 'Interviewee', 'Interviewer', 'Supervisor', 'Department', & 'Date' with a primary ID field. Then create a one-to-many relationship a table containing a the question no (which can be the primary key for the table), & the answer to each question. That way the 'slow' data need only be entered once per questionaire. You could normalise this further, but that depends on how many surveys each interviewer completed. As for a data entry form, the user would then enter the main details for each survey, & then could then simply tab through the 100questions reasonably quickly......

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