By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Create DB for survey results - how?

P: n/a
I need to create a database or something that will allow me to input all of the results
of a survey and then search the results for trends and stuff. For
example, it might have questions like:

1. Your age: [5-10], [11-20], [21-40], [41 and over]
2. Gender: [m],[f]
3. Children ages (select as many as apply): [0-5], [6-15], [16 and over]
4. Check as many of these as you like:
[] The sky should be purple
[] It rains too much
[] Seatbelts save lives
[] I like aeroplane jelly

5. ...
etc, etc

Then I'd have to be able to, for example, bring up all of the people over 40 who like
aeroplane jelly, or all of the females with children who think it rains
too much, etc.

I'm assuming I'd use a database like Access, but I'm not really sure where to begin.

I've done programming, but not much database stuff, so I'd really
appreciate some design tips about where to start, e.g. what tables should
I use, etc

Thanks!
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ray
Interesting problem, and to be honest the ETIK database we supply does what
you want, but it aint necessarily easy to program. Just allowing multiple
question formats can be tricky. Still, Access will surely do it.

Are the questions always the same, or do you issue multiple surveys?

Ray

--
Access Solutions for College and University Student Administration
ETIK - Electronic Tender Issue Kit - Create and Issue tenders electronically
and receive the responses electronically when clients use the free Response
Kit.
Grab! - Uses your PowerPoint files to create presentations on-the-fly for
demonstrations, displays, queue distractors, Point-of-Sale information
www.bluebridge.com.au
Yurk Yurk <yu******@popmail.com> wrote in message
news:pa****************************@popmail.com...
I need to create a database or something that will allow me to input all of the results of a survey and then search the results for trends and stuff. For
example, it might have questions like:

1. Your age: [5-10], [11-20], [21-40], [41 and over]
2. Gender: [m],[f]
3. Children ages (select as many as apply): [0-5], [6-15], [16 and over]
4. Check as many of these as you like:
[] The sky should be purple
[] It rains too much
[] Seatbelts save lives
[] I like aeroplane jelly

5. ...
etc, etc

Then I'd have to be able to, for example, bring up all of the people over 40 who like aeroplane jelly, or all of the females with children who think it rains
too much, etc.

I'm assuming I'd use a database like Access, but I'm not really sure where to begin.
I've done programming, but not much database stuff, so I'd really
appreciate some design tips about where to start, e.g. what tables should
I use, etc

Thanks!

Nov 12 '05 #2

P: n/a
As an alternative resource, there are companies that does surveys online for
free.
www.surveymonkey.com

"Ray" <ra*@aic.net.au> wrote in message
news:3f***********************@lon-reader.news.telstra.net...
Interesting problem, and to be honest the ETIK database we supply does what you want, but it aint necessarily easy to program. Just allowing multiple
question formats can be tricky. Still, Access will surely do it.

Are the questions always the same, or do you issue multiple surveys?

Ray

--
Access Solutions for College and University Student Administration
ETIK - Electronic Tender Issue Kit - Create and Issue tenders electronically and receive the responses electronically when clients use the free Response Kit.
Grab! - Uses your PowerPoint files to create presentations on-the-fly for
demonstrations, displays, queue distractors, Point-of-Sale information
www.bluebridge.com.au
Yurk Yurk <yu******@popmail.com> wrote in message
news:pa****************************@popmail.com...
I need to create a database or something that will allow me to input all of the results
of a survey and then search the results for trends and stuff. For
example, it might have questions like:

1. Your age: [5-10], [11-20], [21-40], [41 and over]
2. Gender: [m],[f]
3. Children ages (select as many as apply): [0-5], [6-15], [16 and over]
4. Check as many of these as you like:
[] The sky should be purple
[] It rains too much
[] Seatbelts save lives
[] I like aeroplane jelly

5. ...
etc, etc

Then I'd have to be able to, for example, bring up all of the people over 40 who like
aeroplane jelly, or all of the females with children who think it rains
too much, etc.

I'm assuming I'd use a database like Access, but I'm not really sure
where to begin.

I've done programming, but not much database stuff, so I'd really
appreciate some design tips about where to start, e.g. what tables

should I use, etc

Thanks!


Nov 12 '05 #3

P: n/a
Search the NG for a post by Keri Hardwick with the keyword "Survey".
She explains how to set up a database like this. Essentially, you can
do any data analysis you want - you just have to set up your database
correctly for it, and she explains how to set it up and why to set it
up that way.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.