Re: Data entry forms and/or subforms

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 11:47:08 -0700

Hi Hugh,

> I am attempting to use MS Access forms for a data entry project and am
> fairly new to database design and the use of forms. The data to be
> entered are survey responses from high school students. Each survey
> contains over 300 questions/items. Originally, I had envisioned
> entering the data into a single table with a student id serving as the
> primary key (there is never a one-to-many relationship in the way the
> data appears to be structured). Is this a reasonable approach (or
> should the data go to multiple tables or queries)?

Most likely no, unfortunately.
And you are now running into problems as a result of this table design setup.

This really isn't my area of expertise, but MVP Duane Hookom has a great sample database you should
download:

http://rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%202000'

It is a fully functional survey database.
It should really help show you a proper design setup as well as data entry forms.
Hopefully this should help in your project.
If you have additional questions I'm sure Duane will join in (I hope).

Good luck, 

-- 
Jeff Conrad
Access Junkie
Bend, Oregon
> Because of the large number of items, I had also designed separate
> forms for each page of the survey and inserted them into a main form
> as subforms.  There is a tab-control and I am able to get the forms to
> navigate so that when I hit a button at the bottom of one subform, it
> takes me to the top of the next subform.  However,what I would like to
> be able to do is to hit a button upon completing one data entry record
> that takes me to the next data entry record and back to the main form.
>  I am having no luck at all with this.
>
> I am also having difficulties in keeping the records straight, so that
> once I enter a student id, all of the subsequent data on the subforms
> get entered into this record.  It seems as though some or all of the
> subforms records get bounced around or go back to the first record.
> Any help provided is certainly appreciated.
>
> Best,
>
> Hugh

Relevant Pages

  • Re: Linguistics Survey - Please take part!
    ... >> please help me with a survey that I am doing for my final year project ... >> therefore the sentence from the sample passage should be given the ... >> This is again, a personal opinion, and I require only a few words as ... >> A university student? ...
    (sci.cognitive)
  • Re: Making Selections Available for Choices
    ... I am not a technical user. ... I have a table for school, student, leader, and volunteer information names, ... The multichoice options in a survey (which of these words ... question - if it's a quiz. ...
    (microsoft.public.access.gettingstarted)
  • Re: Design question - best practice to store survey questions
    ... Your response to the design of tblSurveys ... Re no design for the answers tables: Well, ... So above the line between SURVEY and QUESTION ...
    (comp.databases)
  • NHA Sponsorship Opportunity for the 2007 H2U Student Design Contest
    ... NHA Sponsorship Opportunity for the 2007 H2U Student Design Contest ...
    (sci.energy.hydrogen)
  • Re: subform entry limited to (n) fields?
    ... John, ... each week I'll enter a range of marks for each student. ... in another file but it has the wrong design in table structure. ... >>After several tutorial style books about Access and the Function X Tutorial ...
    (microsoft.public.access.forms)