Re: question about tables

On Wed, 21 Dec 2005 11:22:02 -0800, Miguel Vivar
<MiguelVivar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I have a question about tables. I have a very large questionnaire with a lot
>of questions, so I wonder if I should break this questions into different
>tables, or should I put all questions in only one table. These questions do
>not have relate one to another so I don't think I could create a relationship
>between tables.
>
>Miguel

If you're thinking of having one field per question... don't.

Instead, take a look at a properly normalized design: Duane Hookum's
excellent "At Your Survey" database. Download it from

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

John W. Vinson[MVP]
.

Relevant Pages

  • Re: Designing a CD Database - How to Start?
    ... > download the database at www.henrysrecords.org and then delete the tens ... Steve ... Prev by Date: ...
    (rec.music.classical.recordings)
  • Update Problem
    ... I created a database to track a survey, ... into all feilds for my tables except one. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: survey database
    ... Access Database Samples: www.rogersaccesslibrary.com ... I have seen that many people recommend the 'at your survey' ... > message 'not authorized to view this page' after I click the download ...
    (microsoft.public.access.tablesdbdesign)
  • Re: GIMP plug-in for chromatic aberration
    ... PTLens has a pretty extensive database of ... profiles you can download off of their site. ... Prev by Date: ...
    (comp.graphics.apps.gimp)
  • Re: Nihongo Benkyo 0.3
    ... Well, you know, it's already supposed to help you understand japanese. ... It's actually a dictionary (but for that, you need to download the ... database) and will be a learning tool as of version 0.5 (according to ... Prev by Date: ...
    (comp.lang.ruby)
Loading