database surveys?

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!

This is a very common question. Do a search and read the previous posts.

There is a database built by one of the MVPs called "At Your Survey". If
you find the previous posts, there are links to this database that you can
use. It seems to be a great tool that handles just about all the
survey-type issues I've seen posted here.


--
Rick B



"Gizelle Morris" Gizelle wrote in message
...
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!

At Your Survey can be found at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.

AYS is meant to be a template of how a survey can be structured. I doesn't
have more advanced features like conditional branching. You could probably
add more bells and whistles but I wanted to keep it less complex and easier
to understand.

--
Duane Hookom
MS Access MVP
--

"Rick B" Anonymous wrote in message
...
This is a very common question. Do a search and read the previous posts.

There is a database built by one of the MVPs called "At Your Survey". If
you find the previous posts, there are links to this database that you can
use. It seems to be a great tool that handles just about all the
survey-type issues I've seen posted here.


--
Rick B



"Gizelle Morris" Gizelle wrote in
message ...
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!

I encourage you to use this newsgroup and folowup on the advise that seems
reasonable to you. After that if you are not able to still set up your
survey database, contact me at my email address below; I can help you for a
reasonable fee. I am in business to provide Access users like you a resource
for help with Access applications. My fees are very reasonable. I recently
did a housing survey database that contained over two hundred questions.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar form and report? Contact me.



"Gizelle Morris" Gizelle wrote in message
...
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!

Steve,
Is this really you posting or is someone pretending to be you and get you
into trouble for making stupid replies? I find it hard to believe that you
would this blatant in your advertising. This would be way to idiotic of a
post for someone to make under their own name.

--
Duane Hookom
MS Access MVP


"PC Datasheet" wrote in message
nk.net...
I encourage you to use this newsgroup and folowup on the advise that seems
reasonable to you. After that if you are not able to still set up your
survey database, contact me at my email address below; I can help you for a
reasonable fee. I am in business to provide Access users like you a
resource for help with Access applications. My fees are very reasonable. I
recently did a housing survey database that contained over two hundred
questions.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar form and report? Contact me.



"Gizelle Morris" Gizelle wrote in
message ...
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!

"PC Datasheet" schreef in bericht nk.net...
I encourage you to use this newsgroup and folowup on the advise that seems
reasonable to you.

Indeed, I encourage you to just get lost.

Arno R

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

Thank you. Was you form emailed to survey takers? I have a customer survey
that needs to be sent to and resubmitted with the response. Any advice? ejg

"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 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

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