Simple Questionnaire DB

Hello,

Tina sent me a demo of a db she did and it is perfect for what you need. If
you let me have your email address I will send it but don't write the email
correctly (ie use "dot" instead of "." and "at" instead of @). So spam
software doesn't find it :-)





"Pixie78" wrote:

I mean that what I want is nothing fancy, I just want it to add for me. I
don't want to type in all the questions or create a pretty form with all
kinds of buttons and functions and spend a ton of time on this. I just want
a quick way to tally. Nothing more. The 2 tables I have so far a

tblQuestions
QuestionID (PK) Numbered 1-32 in this case
Questions - probably contain a couple of words of the question in case I'm
tallying a survey that doesn't have actual numbered questions

tblAnswers
AnswerID (PK) Answer
1 Strongly Disagree
2 Disagree
3 Neither Agree or Disagree
4 Agree
5 Strongly Agree

There's no survey versions, demographics, names, departments or anything
else aside from the survey questions and answers and a bunch of check marks
in the boxes. There are just under 200 employees here but if the survey
isn't mandatory, there could only be 70 turned in. All our surveys are
similar with this opinion of Agree or Disagree.
I just want to have a form that has all the questions with the answer box
next to it and just tab through and type the answers as in 3 tab 1 tab 1
tab 4 tab and when I get to question 32 I hit submit or send or it just
automatically goes to a new, blank survey form and I enter the results of the
next person and so on til there's no more and then run the query and see the
totals for each question. How many Agrees, Disagrees.... you get the point.
I know I need another table of SurveyID which will act as the number of
papers I have and then a table of the questions with the answers in which to
run the crosstab query, it's there I'm having the problem. How do I go about
linking the questions with a selectable answer and have each "form" equal the
32 questions I have? Make sense?

"scubadiver" wrote:


"I don't care to set up the actual survey in the database". What do you mean
by that? In order to enter information you need to set up tables and forms.

You don't have to enter the totals by hand. Export the summary information
to a source spreadsheet and link the cell references to another spreadsheet
in a format that your boss will like.

"tally" ho!


--

http://www.ready4mainstream.ny911truth.org/index.html


"Pixie78" wrote:

Sorry, I've been out of town. This sounds more like what I need. Could you
elaborate a little more? I'm understanding the concept and the end result,
just need a boost with getting there.
I didn't expect so much commotion over a survey =)
Here's the deal on the surveys: I don't care to set up the actual survey in
the database, they are just handed to me after the employees fill them out
and my boss says 'Here, go ahead and tally these up, thanks'. Then he sends
me an electronic copy of the survey (excel spreadsheet) and I enter the
totals on there and mail it back. Pretty simple. Except for the tally part,
that's time consuming reading each check mark. I don't care about naming the
questions, answers or surveys it's just for tally purposes and would probably
be used over and over for different surveys of the same set up. I'm still
new at my job so I don't know how often the same survey goes out but I know
the same TYPE of survey frequently goes out and if I'm the tally girl, I'd
like an easier way to get there. =)
Thanks so much!


"John W. Vinson" wrote:

On Sun, 19 Aug 2007 23:42:00 -0700, scubadiver
wrote:

I think you will need 34 fields. A field for each edition of the survey (if
it is to be repeated monthly, quarterly), a field that identifies each
questionnaire within each survey set and the remaining 32 for each question.

BZZZZT!!!

"Pull over to the side. Take your hands off the keyboard and keep them in
sight. You're under arrest for Committing Spreadsheet!"

g

Seriously, this is a very common error in designing surveys. You're much
better off having a one-to-many relationship from Surveys to Questions, and
from Surveys to Answers; instead of 32 fields, you would have 32 records, one
for each question. You can use a Crosstab query to *display* a grid layout,
and even use a Grid control to edit the answers - but the tables should be
tall and thin, not storing questions in fieldnames.

John W. Vinson [MVP]

Thanks scuba, I'm working on 3 databases so my mind goes fuzzy sometimes
trying to figure out how to make things go. =p And this survey business
isn't crucial, it's just an easy out for me when it comes time to count so I
can spend more time building the other databases!!

bruja (under score) leslie at hot mail dot com
~No spaces~
Thanks so much!


"scubadiver" wrote:



Hello,

Tina sent me a demo of a db she did and it is perfect for what you need. If
you let me have your email address I will send it but don't write the email
correctly (ie use "dot" instead of "." and "at" instead of @). So spam
software doesn't find it :-)





"Pixie78" wrote:

I mean that what I want is nothing fancy, I just want it to add for me. I
don't want to type in all the questions or create a pretty form with all
kinds of buttons and functions and spend a ton of time on this. I just want
a quick way to tally. Nothing more. The 2 tables I have so far a

tblQuestions
QuestionID (PK) Numbered 1-32 in this case
Questions - probably contain a couple of words of the question in case I'm
tallying a survey that doesn't have actual numbered questions

tblAnswers
AnswerID (PK) Answer
1 Strongly Disagree
2 Disagree
3 Neither Agree or Disagree
4 Agree
5 Strongly Agree

There's no survey versions, demographics, names, departments or anything
else aside from the survey questions and answers and a bunch of check marks
in the boxes. There are just under 200 employees here but if the survey
isn't mandatory, there could only be 70 turned in. All our surveys are
similar with this opinion of Agree or Disagree.
I just want to have a form that has all the questions with the answer box
next to it and just tab through and type the answers as in 3 tab 1 tab 1
tab 4 tab and when I get to question 32 I hit submit or send or it just
automatically goes to a new, blank survey form and I enter the results of the
next person and so on til there's no more and then run the query and see the
totals for each question. How many Agrees, Disagrees.... you get the point.
I know I need another table of SurveyID which will act as the number of
papers I have and then a table of the questions with the answers in which to
run the crosstab query, it's there I'm having the problem. How do I go about
linking the questions with a selectable answer and have each "form" equal the
32 questions I have? Make sense?

"scubadiver" wrote:


"I don't care to set up the actual survey in the database". What do you mean
by that? In order to enter information you need to set up tables and forms.

You don't have to enter the totals by hand. Export the summary information
to a source spreadsheet and link the cell references to another spreadsheet
in a format that your boss will like.

"tally" ho!


--

http://www.ready4mainstream.ny911truth.org/index.html


"Pixie78" wrote:

Sorry, I've been out of town. This sounds more like what I need. Could you
elaborate a little more? I'm understanding the concept and the end result,
just need a boost with getting there.
I didn't expect so much commotion over a survey =)
Here's the deal on the surveys: I don't care to set up the actual survey in
the database, they are just handed to me after the employees fill them out
and my boss says 'Here, go ahead and tally these up, thanks'. Then he sends
me an electronic copy of the survey (excel spreadsheet) and I enter the
totals on there and mail it back. Pretty simple. Except for the tally part,
that's time consuming reading each check mark. I don't care about naming the
questions, answers or surveys it's just for tally purposes and would probably
be used over and over for different surveys of the same set up. I'm still
new at my job so I don't know how often the same survey goes out but I know
the same TYPE of survey frequently goes out and if I'm the tally girl, I'd
like an easier way to get there. =)
Thanks so much!


"John W. Vinson" wrote:

On Sun, 19 Aug 2007 23:42:00 -0700, scubadiver
wrote:

I think you will need 34 fields. A field for each edition of the survey (if
it is to be repeated monthly, quarterly), a field that identifies each
questionnaire within each survey set and the remaining 32 for each question.

BZZZZT!!!

"Pull over to the side. Take your hands off the keyboard and keep them in
sight. You're under arrest for Committing Spreadsheet!"

g

Seriously, this is a very common error in designing surveys. You're much
better off having a one-to-many relationship from Surveys to Questions, and
from Surveys to Answers; instead of 32 fields, you would have 32 records, one
for each question. You can use a Crosstab query to *display* a grid layout,
and even use a Grid control to edit the answers - but the tables should be
tall and thin, not storing questions in fieldnames.

John W. Vinson [MVP]

On Thu, 30 Aug 2007 13:22:02 -0700, scubadiver
wrote:

Hello,

Tina sent me a demo of a db she did and it is perfect for what you need.

Thanks, scubadiver. If you and Tina are both on the case I can relax - she's
in good hands!

John W. Vinson [MVP]

Can you answer the queries in my last message?


"John W. Vinson" wrote:

On Thu, 30 Aug 2007 13:22:02 -0700, scubadiver
wrote:

Hello,

Tina sent me a demo of a db she did and it is perfect for what you need.

Thanks, scubadiver. If you and Tina are both on the case I can relax - she's
in good hands!

John W. Vinson [MVP]

Put the following in the "on change" event of the [answer] field in the
subform.


If Me.CurrentRecord Me.Recordset.RecordCount Then

If Len(Me![detailAmount].Text) 0 Then
DoCmd.GoToRecord , , acNext
End If
End If



When you enter an answer the cursor will tab to the same field in the next
record. When you get to the last record the code doesn't bug out.

--

http://www.ready4mainstream.ny911truth.org/index.html


"Pixie78" wrote:

Thanks scuba, I'm working on 3 databases so my mind goes fuzzy sometimes
trying to figure out how to make things go. =p And this survey business
isn't crucial, it's just an easy out for me when it comes time to count so I
can spend more time building the other databases!!

bruja (under score) leslie at hot mail dot com
~No spaces~
Thanks so much!


"scubadiver" wrote:



Hello,

Tina sent me a demo of a db she did and it is perfect for what you need. If
you let me have your email address I will send it but don't write the email
correctly (ie use "dot" instead of "." and "at" instead of @). So spam
software doesn't find it :-)





"Pixie78" wrote:

I mean that what I want is nothing fancy, I just want it to add for me. I
don't want to type in all the questions or create a pretty form with all
kinds of buttons and functions and spend a ton of time on this. I just want
a quick way to tally. Nothing more. The 2 tables I have so far a

tblQuestions
QuestionID (PK) Numbered 1-32 in this case
Questions - probably contain a couple of words of the question in case I'm
tallying a survey that doesn't have actual numbered questions

tblAnswers
AnswerID (PK) Answer
1 Strongly Disagree
2 Disagree
3 Neither Agree or Disagree
4 Agree
5 Strongly Agree

There's no survey versions, demographics, names, departments or anything
else aside from the survey questions and answers and a bunch of check marks
in the boxes. There are just under 200 employees here but if the survey
isn't mandatory, there could only be 70 turned in. All our surveys are
similar with this opinion of Agree or Disagree.
I just want to have a form that has all the questions with the answer box
next to it and just tab through and type the answers as in 3 tab 1 tab 1
tab 4 tab and when I get to question 32 I hit submit or send or it just
automatically goes to a new, blank survey form and I enter the results of the
next person and so on til there's no more and then run the query and see the
totals for each question. How many Agrees, Disagrees.... you get the point.
I know I need another table of SurveyID which will act as the number of
papers I have and then a table of the questions with the answers in which to
run the crosstab query, it's there I'm having the problem. How do I go about
linking the questions with a selectable answer and have each "form" equal the
32 questions I have? Make sense?

"scubadiver" wrote:


"I don't care to set up the actual survey in the database". What do you mean
by that? In order to enter information you need to set up tables and forms.

You don't have to enter the totals by hand. Export the summary information
to a source spreadsheet and link the cell references to another spreadsheet
in a format that your boss will like.

"tally" ho!


--

http://www.ready4mainstream.ny911truth.org/index.html


"Pixie78" wrote:

Sorry, I've been out of town. This sounds more like what I need. Could you
elaborate a little more? I'm understanding the concept and the end result,
just need a boost with getting there.
I didn't expect so much commotion over a survey =)
Here's the deal on the surveys: I don't care to set up the actual survey in
the database, they are just handed to me after the employees fill them out
and my boss says 'Here, go ahead and tally these up, thanks'. Then he sends
me an electronic copy of the survey (excel spreadsheet) and I enter the
totals on there and mail it back. Pretty simple. Except for the tally part,
that's time consuming reading each check mark. I don't care about naming the
questions, answers or surveys it's just for tally purposes and would probably
be used over and over for different surveys of the same set up. I'm still
new at my job so I don't know how often the same survey goes out but I know
the same TYPE of survey frequently goes out and if I'm the tally girl, I'd
like an easier way to get there. =)
Thanks so much!


"John W. Vinson" wrote:

On Sun, 19 Aug 2007 23:42:00 -0700, scubadiver
wrote:

I think you will need 34 fields. A field for each edition of the survey (if
it is to be repeated monthly, quarterly), a field that identifies each
questionnaire within each survey set and the remaining 32 for each question.

BZZZZT!!!

"Pull over to the side. Take your hands off the keyboard and keep them in
sight. You're under arrest for Committing Spreadsheet!"

g

Seriously, this is a very common error in designing surveys. You're much
better off having a one-to-many relationship from Surveys to Questions, and
from Surveys to Answers; instead of 32 fields, you would have 32 records, one
for each question. You can use a Crosstab query to *display* a grid layout,
and even use a Grid control to edit the answers - but the tables should be
tall and thin, not storing questions in fieldnames.

John W. Vinson [MVP]

Sorry, when I said last message I meant my final message (ie third from
bottom in the list!).

I do have two remaining

1) I do have some text answers (like open comments). Should the [answer]
field be changed to a text field or will this cause problems with queries etc?

2) How can I deal with a question that can have multiple responses?

3) How I can deal with any questions that are non-numeric (like check boxes)?

Cheers




--

http://www.ready4mainstream.ny911truth.org/index.html


"John W. Vinson" wrote:

On Fri, 31 Aug 2007 00:44:01 -0700, scubadiver
wrote:

Can you answer the queries in my last message?


eh??? I didn't see that you asked any!

John W. Vinson [MVP]

On Mon, 3 Sep 2007 00:22:02 -0700, scubadiver
wrote:


Sorry, when I said last message I meant my final message (ie third from
bottom in the list!).

I do have two remaining

1) I do have some text answers (like open comments). Should the [answer]
field be changed to a text field or will this cause problems with queries etc?

You will need to be consistant - all number or all text - or else have two or
more answer fields: one text answer, one number answer, one date answer, maybe
one yes/no answer. This gets complicated because you need some way to prevent
entry of multiple answers in each question.

2) How can I deal with a question that can have multiple responses?

Another table related one to many to the answers table.

3) How I can deal with any questions that are non-numeric (like check boxes)?

Checkboxes *are* numeric... 0 is unchecked, -1 is checked - but see the answer
to 1.

John W. Vinson [MVP]