Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Smile Unanswered: questionnaire database design

    Hi
    I have designed a small questionnaire and i want to use Ms Access for data entry and storage.
    Here is the brief description.
    ------------------
    A.Heading
    ------------------
    1.Person id
    2.date of birth
    3.age
    4.sex
    5.school
    -----------------------
    B.Sports Information about individual
    ------------------------------
    1.do you play any spot ------yes/no
    2.what spot do you play -----1.football 2.tennis 3.other
    3.is your father still alive-----yes /no
    4.what spot does he play------1.football 2.tennis 3.other
    5.at what age did you start school
    6.what is your political affiliation 1.liberal 2.centre . other

    -----------------------------------------------
    C.For official use only
    ---------------------------------------------
    1.Date of interview-------
    2.How enthusiastic was the respondent----1.very 2.Average 3. Below average

    How can i go about designing a relational database for the above questionnaire.
    I need advice on the relational schema
    thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    probably best to ask this in the Access forum.. so Ill move it there
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Have a look at Rudy's (R937) site
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Here's a tutorial on designing an Access survey database:

    http://www.functionx.com/access/applications/survey.htm
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    The one thing I can tell you about a survey database (and I've designed quite a few) is try to avoid hardcoding the question into the fieldname! Questions will undoubtly change. I had a lookup table (1 field) which held the questions and a data table which populated a field with the question sentence and another field for the answer.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •