HLP PLS - Survey Answers

I am using AYS as a base in creating a survey database.

I have the questions in one table with a questionID PK.

I have the answers in another table with the questionID FK and the answer.

So far so good. However, I have many surveys that will be filled in by many
individuals. Some answers are straighforward - choose from list. However,
others a

-Circle all answers that apply.
-Choose one of the provided answers OR write something beside Other:
-No answer at all because they responded Yes or No to a previous question,
so move ahead to another section
-Fill in the blank - _____ children
-Some are multi-answers to a question that takes place over a few hours,
such as - _____ (time) ____ blood sugar level; ______ (time) _______ blood
sugar level; _____(time) _____ blood sugar level
-Some are measurements, such as weight, height.

Also, on the survey form (hard copy) the answers are numbered, i.e.
1,2,3,4,5, etc., often jumping to the standard number for N/A, Do not know,
etc. that are 50, 51 and 52. Should I put this in a separate field and
combine it with the questionID FK to make a PK? I don't think I should
include the actual number in the answer field, as it may prove to be
cumbersome when querying for how many people smoke, etc.

HELP! Any suggestion or advice will be greatly appreciated!


--
Thanks!

Dee

-Circle all answers that apply.
Each possible answer of a multiple choice would be a separate yes/no
question

-Choose one of the provided answers OR write something beside Other:
Use the same method as used in At Your Survey

-No answer at all because they responded Yes or No to a previous question,
so move ahead to another section
You could write code that would delete a question based on a previous
question

-Fill in the blank - _____ children
How is this different from How many children do you have?

-Some are multi-answers to a question that takes place over a few hours,
such as - _____ (time) ____ blood sugar level; ______ (time) _______ blood
sugar level; _____(time) _____ blood sugar level
These could be separate questions under the same major level as per the
AYS sample

-Some are measurements, such as weight, height.
How are these questions different from any other question?

I don't understand your last paragraph.

--
Duane Hookom
Microsoft Access MVP


"dee" wrote:

I am using AYS as a base in creating a survey database.

I have the questions in one table with a questionID PK.

I have the answers in another table with the questionID FK and the answer.

So far so good. However, I have many surveys that will be filled in by many
individuals. Some answers are straighforward - choose from list. However,
others a

-Circle all answers that apply.
-Choose one of the provided answers OR write something beside Other:
-No answer at all because they responded Yes or No to a previous question,
so move ahead to another section
-Fill in the blank - _____ children
-Some are multi-answers to a question that takes place over a few hours,
such as - _____ (time) ____ blood sugar level; ______ (time) _______ blood
sugar level; _____(time) _____ blood sugar level
-Some are measurements, such as weight, height.

Also, on the survey form (hard copy) the answers are numbered, i.e.
1,2,3,4,5, etc., often jumping to the standard number for N/A, Do not know,
etc. that are 50, 51 and 52. Should I put this in a separate field and
combine it with the questionID FK to make a PK? I don't think I should
include the actual number in the answer field, as it may prove to be
cumbersome when querying for how many people smoke, etc.

HELP! Any suggestion or advice will be greatly appreciated!


--
Thanks!

Dee

Hi Duane,

Thanks for your help. I think where I got off on the wrong track was
looking at the hard copy survey where you would have, for example:

Q1. What language do you speak at home?

1 - English
2 - French
3 - Spanish
4 - German
5 - Other
50 - Do not know

To me, the question was the text What langauge do you speak at home?" and
the answers were one of the choices.

If I understand it correctly, I should be itemizing the list of "answers" as
"questions", i.e.

Qstlvl1 = Q1
Qstnlvl2 = A
Qstnlvl3 = 1, 2, 3, 4, 5, and 50
QstnTxt -

This is where I get confused. The question is "What language do you speak
at home" with multiple choices. How do I achieve that?

Thank you.

--
Thanks!

Dee


"Duane Hookom" wrote:

-Circle all answers that apply.
Each possible answer of a multiple choice would be a separate yes/no
question

-Choose one of the provided answers OR write something beside Other:
Use the same method as used in At Your Survey

-No answer at all because they responded Yes or No to a previous question,
so move ahead to another section
You could write code that would delete a question based on a previous
question

-Fill in the blank - _____ children
How is this different from How many children do you have?

-Some are multi-answers to a question that takes place over a few hours,
such as - _____ (time) ____ blood sugar level; ______ (time) _______ blood
sugar level; _____(time) _____ blood sugar level
These could be separate questions under the same major level as per the
AYS sample

-Some are measurements, such as weight, height.
How are these questions different from any other question?

I don't understand your last paragraph.

--
Duane Hookom
Microsoft Access MVP


"dee" wrote:

I am using AYS as a base in creating a survey database.

I have the questions in one table with a questionID PK.

I have the answers in another table with the questionID FK and the answer.

So far so good. However, I have many surveys that will be filled in by many
individuals. Some answers are straighforward - choose from list. However,
others a

-Circle all answers that apply.
-Choose one of the provided answers OR write something beside Other:
-No answer at all because they responded Yes or No to a previous question,
so move ahead to another section
-Fill in the blank - _____ children
-Some are multi-answers to a question that takes place over a few hours,
such as - _____ (time) ____ blood sugar level; ______ (time) _______ blood
sugar level; _____(time) _____ blood sugar level
-Some are measurements, such as weight, height.

Also, on the survey form (hard copy) the answers are numbered, i.e.
1,2,3,4,5, etc., often jumping to the standard number for N/A, Do not know,
etc. that are 50, 51 and 52. Should I put this in a separate field and
combine it with the questionID FK to make a PK? I don't think I should
include the actual number in the answer field, as it may prove to be
cumbersome when querying for how many people smoke, etc.

HELP! Any suggestion or advice will be greatly appreciated!


--
Thanks!

Dee

I would expect this to be 6 questions in the database:
Level sublevel
X 1 Do you speak English at home
X 2 Do you speak French at home
......
X 5 What other language do you speak at home

I'm not sure if I would include a question for Do Not Know or just add this
as an option for X 5.

--
Duane Hookom
Microsoft Access MVP


"dee" wrote:

Hi Duane,

Thanks for your help. I think where I got off on the wrong track was
looking at the hard copy survey where you would have, for example:

Q1. What language do you speak at home?

1 - English
2 - French
3 - Spanish
4 - German
5 - Other
50 - Do not know

To me, the question was the text What langauge do you speak at home?" and
the answers were one of the choices.

If I understand it correctly, I should be itemizing the list of "answers" as
"questions", i.e.

Qstlvl1 = Q1
Qstnlvl2 = A
Qstnlvl3 = 1, 2, 3, 4, 5, and 50
QstnTxt -

This is where I get confused. The question is "What language do you speak
at home" with multiple choices. How do I achieve that?

Thank you.

--
Thanks!

Dee


"Duane Hookom" wrote:

-Circle all answers that apply.
Each possible answer of a multiple choice would be a separate yes/no
question

-Choose one of the provided answers OR write something beside Other:
Use the same method as used in At Your Survey

-No answer at all because they responded Yes or No to a previous question,
so move ahead to another section
You could write code that would delete a question based on a previous
question

-Fill in the blank - _____ children
How is this different from How many children do you have?

-Some are multi-answers to a question that takes place over a few hours,
such as - _____ (time) ____ blood sugar level; ______ (time) _______ blood
sugar level; _____(time) _____ blood sugar level
These could be separate questions under the same major level as per the
AYS sample

-Some are measurements, such as weight, height.
How are these questions different from any other question?

I don't understand your last paragraph.

--
Duane Hookom
Microsoft Access MVP


"dee" wrote:

I am using AYS as a base in creating a survey database.

I have the questions in one table with a questionID PK.

I have the answers in another table with the questionID FK and the answer.

So far so good. However, I have many surveys that will be filled in by many
individuals. Some answers are straighforward - choose from list. However,
others a

-Circle all answers that apply.
-Choose one of the provided answers OR write something beside Other:
-No answer at all because they responded Yes or No to a previous question,
so move ahead to another section
-Fill in the blank - _____ children
-Some are multi-answers to a question that takes place over a few hours,
such as - _____ (time) ____ blood sugar level; ______ (time) _______ blood
sugar level; _____(time) _____ blood sugar level
-Some are measurements, such as weight, height.

Also, on the survey form (hard copy) the answers are numbered, i.e.
1,2,3,4,5, etc., often jumping to the standard number for N/A, Do not know,
etc. that are 50, 51 and 52. Should I put this in a separate field and
combine it with the questionID FK to make a PK? I don't think I should
include the actual number in the answer field, as it may prove to be
cumbersome when querying for how many people smoke, etc.

HELP! Any suggestion or advice will be greatly appreciated!


--
Thanks!

Dee