Survey Design

[DeborahP]

Option Box - Need all that apply

I have a survey that I am creating a database to capture the results. On my survey is a option box that ask "How do you hear about the program" - Check all that apply.

I created an option box however it only allows one bullet. How can I get this to work on my survey?

Thanks,
Deborah

 

[Fizzio]

There are a few ways that you can do this. In this thread
http://www.access-programmers.co.uk/forums/showthread.php?t=78230
Cable has posted one example Db that works well and will achieve what you are trying to do.
There are other options (eg multi select listbox) that can do a similar task. Both solutions need some form of coding to work though.


Make sure that you delete the other 2 duplicate posts so that people can follow one thread with the same problem

 

[Malcy]

Hi Deborah
That is how option boxes work.
Why not try using check boxes instead, then you can tick all that apply when needed.
HTH
Good luck

 

[DeborahP]

survey design - please help

I posted a thread about check boxes and really did not get any advice that I wanted to hear. It was all good advice and it got my mind thinking about the design of my survey.

I have a survey that has 3 sections that I want to extract and analyze data from the sections. I have demographic information, pre-health and post-health information. I have all the information in one table (this is where I think the problem is going to take place).

On 1 part of the survey, it asked to check all that apply. I need to find out the biggest marketing tool and in what areas of town that tool is used.

Can someone help guide me in the right direction? Is there a sample survey out there that I can look to get some ideas?

Thanks,
Deborah

 

[Mile-O]

You posted three questions on this topic yesterday.

These are now merged.

 

[Mile-O]

I posted a thread about check boxes and really did not get any advice that I wanted to hear.

I struggle to see what was wrong with Pat's post. I think that, rather than not getting the advice you wanted to hear, you don't actually know what the advice is you needed to hear.

 

[Pauldohert]

I posted a thread about check boxes and really did not get any advice that I wanted to hear. It was all good advice and it got my mind thinking about the design of my survey.

I don't think Deborah sees anything wrong with Pats post either - the second sentence tells me she has taken it on board - I think she was just hoping for a simpler (but still well designed) answer??

 

[DeborahP]

I am trying to figure out this process of normalization and how to get all the tables to work together. I want to use an autonumber to keep track of entry for the participant (demographic information). I am not sure how to link it to the other tables. I will be using autonumbers for them as well for the pre and post health assessment.

I guess the advice I wanted to hear was something simple so I could continue with what I have. What I have is one table with everything in it.

I am asking for help - maybe I am not doing it the correct way.

Deborah