View Single Post
  #9  
Old November 16th, 2009, 04:54 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Table design help!

Hannah,

What you just said DOES simplify it:

A. The database doesn't have to direct the process of which questions cause
which followup questions. Since it is past tense, they are all just
questions that may or many not have been answered.

B. Your users of the DB will be at least partially skilled or familiarized.



That makes things easier. So here are a few more questions after which
I or someone could take a guess at a structure to get you started:

1. Do you want the database to "know"/record what the possible / allowable
answers are for each question?

2. Do want the database to "know" record the "if then " linkages between
questions?

3. Does the DB have to guide the data-enterer along those paths/linkages?
(your answer should be NO on this if you want to simplify)

4. Are the same people taking multiple surveys? Are there several "fields"
with information on the person (address, city, state, phone etc.)