database surveys?

On Tue, 5 Dec 2006 08:09:00 -0800, Shannon
wrote:

What a great thread; full of adventure, good answers and danger! Chinda
D-your answer was understandable. I have some questions for you. First,
though, I must ask about Duane H's software. It seems you have to download
it and run it which seems scary to me when I don't know what it is. Is it a
survey to mimic? Is it a wizard? There's a zip option. Will my computer
explode when I unzip it? DH's software may be the best route, but not
without answers to the previous questions.

Just want to chime in as an external observer. Duane Hookum's "At Your
Survey" download is just an Access 2000 format .mdb file. There's no
executable, no program, just a database. As he says, it's a properly
normalized *example* of how a survey can be set up; it's excellent at
that, and quite good enough to use on its own if you're comfortable
with using Access; even more so if you're comfortable with
*developing* in Access and can customize it to your specific needs.

As Duane says, if you're totally new to Access it may be a lot of
effort to get running with it, and another tool might be more
appropriate.

John W. Vinson[MVP]

Thanks. I didn't mean to put down your demo. It is very nice. Is there a
way to look at the tables? Maybe I can figure it out. There's a table for
surveys, a table for the filled out surveys, a table for questions, and
tables for responses.

This may be over my head, as I work on Access about once every two years. I
still have question. On a survey I'm practicing on, I have one question and
five possible responses. The question is in a table, but when I choose the
Lookup Wizard to point to the table of responses, it changes the name of the
question to ID and doesn't show the available responses. Since I finished
the 'shuddering' survey, I have time to mess around, experimenting with the
help I find from y'all.

Any suggestions?



"Duane Hookom" wrote:

My "At Your Survey" demo found at Roger Carlson's site
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane will not
blow up anything. It doesn't use one field per question (shudder...) but
rather is normalized to allow you to create new surveys and questions
without modifying anything. I know at least church in Minnesota that used
AYS to survey their membership.

There are some sample reports in the demo that calculate percents and even
display pie charts for each statistical question.

At Your Survey is not built for web distribution. You could use the table
structure but screens, reports,... would need to be programmed in ASP,
ColdFusion, PHP, or other technology. I have given some thought to creating
this for web use but haven't found the time. It would probably be created
with ASP and SQL Server.

If you don't have web experience, you would probably be much better off
using one of the many on-line survey providers.

--
Duane Hookom
MS Access MVP

"Shannon" wrote in message
...
What a great thread; full of adventure, good answers and danger! Chinda
D-your answer was understandable. I have some questions for you. First,
though, I must ask about Duane H's software. It seems you have to
download
it and run it which seems scary to me when I don't know what it is. Is it
a
survey to mimic? Is it a wizard? There's a zip option. Will my computer
explode when I unzip it? DH's software may be the best route, but not
without answers to the previous questions.

That said, Chinda D-your questions: Are the Lookup Wizard and Combo-Box
the same thing? I made a little table of the five responses to choose
from,
but the Lookup Wiz for the table with the questions doesn't display them,
even when put in a form for entry.

The survey for this year is complete. I sadly used a field for each
question and response combo, for example
BeingAMemberOfThisParishHelpsMeToLiveMyFaithStrong lyAgree. I was able to
calculate percentages (for the 90 fields) in a query and merge them into a
copy of the survey which was...written in Word and mailed by US Post to
parishioners. This method will probably change to, or be combined with
the
parish Web-site which was just invented. I entered the data myself
through a
form I made with Yes/no fields for each question/answer combo. This is
why I
have so many related questions for you.

Next question: Is it worth writing an Access survey for a web site? Do
web
sites have their own software for that? Can they even use Access in a web
site?

Another one: If so, and if I use Combo-Boxes, or Lookup Wizards (please
suggest one), can I find the percentages of the results? How would this
be
done? I'm assuming I would have a table of choices like 'Strongly Agree'
and
a table of questions like 'Being a member of this parish helps me to live
my
faith.' The user would simply see a form with check boxes next to each
question, just like the dinasour I just wrote.

Obviously, I'm not an expert, just a nosey stay at home mom, volunteering.
Thanks in advance, Shannon


"Chinda D via AccessMonster.com" wrote:

You can easily contruct an data entry survey by using combo box, command
buttons, and option boxs for multiple questions. I recently did 119
questions with 5 multiple choice each. It took some time but it is
possible.
If this is for data entrying it is perfect. However, if this survey is
going
to be distribute to others. You should restrict previous records from
showing after it is submitted. In your mircosoft office access help
type -
how to prevent a form from showing existing records- to find out how.

I hope this helps.
chinda


How do I set up a database where I may efficiently enter data from a
town
survey? There may be up to 35 questions, some with multiple answers.
Thanks!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200511/1

You can look at the tables by pressing F11 when the mdb is open or holding
down the shift key when opening.


--
Duane Hookom
MS Access MVP

"Shannon" wrote in message
...
Thanks. I didn't mean to put down your demo. It is very nice. Is there
a
way to look at the tables? Maybe I can figure it out. There's a table
for
surveys, a table for the filled out surveys, a table for questions, and
tables for responses.

This may be over my head, as I work on Access about once every two years.
I
still have question. On a survey I'm practicing on, I have one question
and
five possible responses. The question is in a table, but when I choose
the
Lookup Wizard to point to the table of responses, it changes the name of
the
question to ID and doesn't show the available responses. Since I finished
the 'shuddering' survey, I have time to mess around, experimenting with
the
help I find from y'all.

Any suggestions?



"Duane Hookom" wrote:

My "At Your Survey" demo found at Roger Carlson's site
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane will
not
blow up anything. It doesn't use one field per question (shudder...) but
rather is normalized to allow you to create new surveys and questions
without modifying anything. I know at least church in Minnesota that used
AYS to survey their membership.

There are some sample reports in the demo that calculate percents and
even
display pie charts for each statistical question.

At Your Survey is not built for web distribution. You could use the table
structure but screens, reports,... would need to be programmed in ASP,
ColdFusion, PHP, or other technology. I have given some thought to
creating
this for web use but haven't found the time. It would probably be created
with ASP and SQL Server.

If you don't have web experience, you would probably be much better off
using one of the many on-line survey providers.

--
Duane Hookom
MS Access MVP

"Shannon" wrote in message
...
What a great thread; full of adventure, good answers and danger!
Chinda
D-your answer was understandable. I have some questions for you.
First,
though, I must ask about Duane H's software. It seems you have to
download
it and run it which seems scary to me when I don't know what it is. Is
it
a
survey to mimic? Is it a wizard? There's a zip option. Will my
computer
explode when I unzip it? DH's software may be the best route, but not
without answers to the previous questions.

That said, Chinda D-your questions: Are the Lookup Wizard and
Combo-Box
the same thing? I made a little table of the five responses to choose
from,
but the Lookup Wiz for the table with the questions doesn't display
them,
even when put in a form for entry.

The survey for this year is complete. I sadly used a field for each
question and response combo, for example
BeingAMemberOfThisParishHelpsMeToLiveMyFaithStrong lyAgree. I was able
to
calculate percentages (for the 90 fields) in a query and merge them
into a
copy of the survey which was...written in Word and mailed by US Post to
parishioners. This method will probably change to, or be combined with
the
parish Web-site which was just invented. I entered the data myself
through a
form I made with Yes/no fields for each question/answer combo. This is
why I
have so many related questions for you.

Next question: Is it worth writing an Access survey for a web site?
Do
web
sites have their own software for that? Can they even use Access in a
web
site?

Another one: If so, and if I use Combo-Boxes, or Lookup Wizards
(please
suggest one), can I find the percentages of the results? How would
this
be
done? I'm assuming I would have a table of choices like 'Strongly
Agree'
and
a table of questions like 'Being a member of this parish helps me to
live
my
faith.' The user would simply see a form with check boxes next to each
question, just like the dinasour I just wrote.

Obviously, I'm not an expert, just a nosey stay at home mom,
volunteering.
Thanks in advance, Shannon


"Chinda D via AccessMonster.com" wrote:

You can easily contruct an data entry survey by using combo box,
command
buttons, and option boxs for multiple questions. I recently did 119
questions with 5 multiple choice each. It took some time but it is
possible.
If this is for data entrying it is perfect. However, if this survey
is
going
to be distribute to others. You should restrict previous records from
showing after it is submitted. In your mircosoft office access help
type -
how to prevent a form from showing existing records- to find out how.

I hope this helps.
chinda


How do I set up a database where I may efficiently enter data from a
town
survey? There may be up to 35 questions, some with multiple answers.
Thanks!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200511/1

I was interested in your response to this question. I am struggling with a
survey that requires some "limit to list" responses, some "choose more than
one option", and any combination therein.

I'm really having trouble desiging my form. I know that I an use various
controls, such as combo box, List box, etc., but have no idea how these
relate back to my tables.

When I design the form, it doesn't allow me a variety of controls for each
question - am basing it on AYS.

Thanks.
--
Thanks!

Dee


"Chinda D via AccessMonster.com" wrote:

You can easily contruct an data entry survey by using combo box, command
buttons, and option boxs for multiple questions. I recently did 119
questions with 5 multiple choice each. It took some time but it is possible.
If this is for data entrying it is perfect. However, if this survey is going
to be distribute to others. You should restrict previous records from
showing after it is submitted. In your mircosoft office access help type -
how to prevent a form from showing existing records- to find out how.

I hope this helps.
chinda


How do I set up a database where I may efficiently enter data from a town
survey? There may be up to 35 questions, some with multiple answers.
Thanks!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200511/1

AYS is very restrictive! You probably need to relook at the design of your
tables.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications






"dee" wrote in message
...
I was interested in your response to this question. I am struggling with a
survey that requires some "limit to list" responses, some "choose more
than
one option", and any combination therein.

I'm really having trouble desiging my form. I know that I an use various
controls, such as combo box, List box, etc., but have no idea how these
relate back to my tables.

When I design the form, it doesn't allow me a variety of controls for each
question - am basing it on AYS.

Thanks.
--
Thanks!

Dee


"Chinda D via AccessMonster.com" wrote:

You can easily contruct an data entry survey by using combo box, command
buttons, and option boxs for multiple questions. I recently did 119
questions with 5 multiple choice each. It took some time but it is
possible.
If this is for data entrying it is perfect. However, if this survey is
going
to be distribute to others. You should restrict previous records from
showing after it is submitted. In your mircosoft office access help
type -
how to prevent a form from showing existing records- to find out how.

I hope this helps.
chinda


How do I set up a database where I may efficiently enter data from a
town
survey? There may be up to 35 questions, some with multiple answers.
Thanks!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200511/1

"Steve" schreef in bericht ...
AYS is very restrictive! You probably need to relook at the design of your
tables.

PC Datasheet

--
==Let's ask it the 'nice' way...
Would you please, please go away Steve ??

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 3700+ pageloads, 2375+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
== We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
== Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR

How about posting a freely available database, as Duane has done, if you
have a better idea?

"Steve" wrote in message
...
AYS is very restrictive! You probably need to relook at the design of your
tables.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications






"dee" wrote in message
...
I was interested in your response to this question. I am struggling with
a
survey that requires some "limit to list" responses, some "choose more
than
one option", and any combination therein.

I'm really having trouble desiging my form. I know that I an use various
controls, such as combo box, List box, etc., but have no idea how these
relate back to my tables.

When I design the form, it doesn't allow me a variety of controls for
each
question - am basing it on AYS.

Thanks.
--
Thanks!

Dee


"Chinda D via AccessMonster.com" wrote:

You can easily contruct an data entry survey by using combo box, command
buttons, and option boxs for multiple questions. I recently did 119
questions with 5 multiple choice each. It took some time but it is
possible.
If this is for data entrying it is perfect. However, if this survey is
going
to be distribute to others. You should restrict previous records from
showing after it is submitted. In your mircosoft office access help
type -
how to prevent a form from showing existing records- to find out how.

I hope this helps.
chinda


How do I set up a database where I may efficiently enter data from a
town
survey? There may be up to 35 questions, some with multiple answers.
Thanks!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200511/1

There isn't a frrely available database that fits the mold of the OP's
survey. She needs to relook at the design of her tables. She is stuck on
using AYS because Duane told her to. In another post she said "I have
searched the newsgroups and looked on the Internet, in addition to reading
and working on this for hours and hours and am at a loss." She is going to
work hours and hours until she relooks at the design of her tables.

Instead of making an offensive remark about my post, why didn't ypu try to
help the OP? You are just like John Marshall! Are you an "MVP" too?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications





"BruceM" wrote in message
...
How about posting a freely available database, as Duane has done, if you
have a better idea?

"Steve" wrote in message
...
AYS is very restrictive! You probably need to relook at the design of
your tables.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications






"dee" wrote in message
...
I was interested in your response to this question. I am struggling with
a
survey that requires some "limit to list" responses, some "choose more
than
one option", and any combination therein.

I'm really having trouble desiging my form. I know that I an use
various
controls, such as combo box, List box, etc., but have no idea how these
relate back to my tables.

When I design the form, it doesn't allow me a variety of controls for
each
question - am basing it on AYS.

Thanks.
--
Thanks!

Dee


"Chinda D via AccessMonster.com" wrote:

You can easily contruct an data entry survey by using combo box,
command
buttons, and option boxs for multiple questions. I recently did 119
questions with 5 multiple choice each. It took some time but it is
possible.
If this is for data entrying it is perfect. However, if this survey is
going
to be distribute to others. You should restrict previous records from
showing after it is submitted. In your mircosoft office access help
type -
how to prevent a form from showing existing records- to find out how.

I hope this helps.
chinda


How do I set up a database where I may efficiently enter data from a
town
survey? There may be up to 35 questions, some with multiple answers.
Thanks!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200511/1

What was his "offensive" remark?
Was it a variation on that four letter word that you strongly detest? "FREE"
Or was it that outrageeous idea that YOU may have a "better idea"?

As to being an MVP, he has made several posts that could make him a
candidate for an MVP award. You on the other hand have made enough posts to
make it very unlikely that you would be considered. The award is given for
helping the community, something you can not comprehend. You have proven
that helping the community is the furthest thing in your mind.

John... Visio MVP

"Steve" wrote in message
...

Instead of making an offensive remark about my post, why didn't ypu try to
help the OP? You are just like John Marshall! Are you an "MVP" too?

PC Datasheet


"BruceM" wrote in message
...
How about posting a freely available database, as Duane has done, if you
have a better idea?

"Steve" schreef in bericht ...
There isn't a frrely available database that fits the mold of the OP's
survey. She needs to relook at the design of her tables. She is stuck on
using AYS because Duane told her to. In another post she said "I have
searched the newsgroups and looked on the Internet, in addition to reading
and working on this for hours and hours and am at a loss." She is going to
work hours and hours until she relooks at the design of her tables.

Instead of making an offensive remark about my post, why didn't ypu try to
help the OP? You are just like John Marshall! Are you an "MVP" too?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word

Hey Steve, relax !!

We are judging (just had a Goons-meeting..), that your situation/reputation is simply *not* improving here in the groups...
== Every week lots of pagehits and new first-time visitors at http://home.tiscali.nl/arracom/whoissteve.html
== No support for you, no new customers from the groups, no answers here ...

== So please don't forget to shut the door behind you !!

Are there any *other* options left ???
Well.... you *could* consider to stop advertising here...
In that case we *might* even consider to close the website...

FYI In case you are interested:
Also when you are not advertising we still have lots of pagehits for the website...
Even in the year that you had gone... Wow...amazing !!

Arno R