database surveys?

[Gizelle Morris]

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!

 

[Rick B]

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.

 

[Duane Hookom]

At Your Survey can be found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#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.

 

[PC Datasheet]

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
(e-mail address removed)
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.

 

[Duane Hookom]

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.

 

[Chinda D via AccessMonster.com]

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

 

[ejg]

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

 

[Duane Hookom]

My "At Your Survey" demo found at Roger Carlson's site
http://www.rogersaccesslibrary.com/OtherLibraries.asp#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.

 

[John Vinson]

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]

 

[Duane Hookom]

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

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?

 

[dee]

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.

 

[Steve]

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
(e-mail address removed)

 

[BruceM]

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

 

[Steve]

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
(e-mail address removed)

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

 

[John Marshall, MVP]

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

 

[Arno R]

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