Design Flaws

[Jim]

Client surveys prostitutes around the world for a health organization. Unfortunetly, the questions and their possible answers are constantly changing during a process of questionere revision. Answers are either restricted to a possible list, or are a two digit value. Once the questions are locked down, the question form does not change, and is sent out as the template for the survey. Once the survey is completed about 1200 questioneres are returned for data entry. Client also wants a general reporting section that will spit the data out once entered. Some questions represent standard data, where the question's wording might change, but the meaning stays the same. Also there are only 20 "types" of answers for about 100 questions.

I have written a question manager database for them, where they can choose the printed question number, wording of the question, notes etc. I have also set up a table to recieve the data, each cell referencing one of the 20 reference tables that represent "types" of questions which have the possible answers & answer codes.

So client can manage questionere, but I must come in once questionere is locked down to make sure that changes in the questions or answers are reflected in the table, data entry form, and summary reports. I believe that my database is flawed due to my level of knowledge of access. Does anyone have any suggestions.

I have a question table, an answer table designed to recieve raw data, and reference tables that are tied to the answer table, restriction the type of data it can collect. Thanks

 

[Duane Hookom]

You might want to check out "At Your Survey" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You
can't just use this out of the box but you can get an idea of how you might
set up your table, forms, etc.

--
Duane Hookom
MS Access MVP

Client surveys prostitutes around the world for a health organization.

Unfortunetly, the questions and their possible answers are constantly
changing during a process of questionere revision. Answers are either
restricted to a possible list, or are a two digit value. Once the questions
are locked down, the question form does not change, and is sent out as the
template for the survey. Once the survey is completed about 1200
questioneres are returned for data entry. Client also wants a general
reporting section that will spit the data out once entered. Some questions
represent standard data, where the question's wording might change, but the
meaning stays the same. Also there are only 20 "types" of answers for about
100 questions.

I have written a question manager database for them, where they can choose

the printed question number, wording of the question, notes etc. I have
also set up a table to recieve the data, each cell referencing one of the 20
reference tables that represent "types" of questions which have the possible
answers & answer codes.

So client can manage questionere, but I must come in once questionere is

locked down to make sure that changes in the questions or answers are
reflected in the table, data entry form, and summary reports. I believe
that my database is flawed due to my level of knowledge of access. Does
anyone have any suggestions.

I have a question table, an answer table designed to recieve raw data, and

reference tables that are tied to the answer table, restriction the type of
data it can collect. Thanks