Many Multiple Check Boxes for One Question

J

Jesse

BEGINNER - Using Access 2007, I'm trying to set up a survey form for someone
and am immediately having problems. I've only performed very basic designs in
Access. I took the task on because I've never done something like this and
wanted the challenge.

The first question is the worst of the lot. I have five columns and six rows
as shown in the Table below, which are actually Check Boxes on the form with
the info Header to the right. These all pertain to ONE QUESTION on the Survey.

N Y M W D
City
County
Local
Park
Town
Bypass

What I've done so far is to generate a table containing five Fields. The
above pertains to just the first question/first field. I generated a Form,
went to the Form Structure and for the "N" pulled in 6 check boxes. Under the
Arrange Tab I selected the Stack option which grouped that column vertically.
(Looking at it now I'm wondering if I should have grouped horizontally?) I
repeated these steps for each of the five columns. I ASSUMED after reading
what little there is in Access concerning Check Boxes that I was doing this
correctly.

I need to know if I've started this off correctly. If so, then HOW do I
extract the data from the check boxes. Each is unique, but how do I do a
compilation of say 500 records of information?

The next problem I ran into is that even though I neatly organized the Check
Boxes on the Form Structure, it does not retain that format when viewing the
form for Input. Rather it puts the check boxes in a row (record). How do I
get it to display much as a paper form would be?

I would appreciate any and all help with these problems.

Jesse
 
D

Damon Heron

Your explanation is a bit confusing. Are you saying you have a table with
five fields- N, Y, M, W, and D? Then what are the other words related to?
What exactly are your intentions? If it is to save multiple checkmarks in a
single field, (tho this can be done) I think its a bad idea. Explain
further, please.

Damon
 
J

John W. Vinson

BEGINNER - Using Access 2007, I'm trying to set up a survey form for someone
and am immediately having problems. I've only performed very basic designs in
Access. I took the task on because I've never done something like this and
wanted the challenge.

Well... your first mistake is that you evidently began in the middle, by
designing your Form.

Forms are *secondary*. Data is not stored in forms, but in Tables; you need to
get your table structures and relationships right first, BEFORE you start
thinking about forms.

A second mistake is a very common one for people starting with a
questionnaire: storing data in fieldnames. Data should be stored *as data in a
field*, not as a fieldname (e.g. your "Y" field).

For a good, worked-out questionnaire database design see
Duane Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

or

Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=TrainingRegistration.mdb
 
J

Jesse

My table consists of five fields: Shop, No Shop, Limit, Needs, Improve.
What I'm working with is the first field only, Shop.
They want this set up in a grid of five columns and six rows of Check Boxes.
The Column Text is the letters N, Y, M, W, D
The Row Titles are like sub-Questions.
The grid would look something like below with the X's being Check Boxes

N Y M W D
X X X X X City (sub-Question 1)
X X X X X County(sub-Question 2)
X X X X X Local(sub-Question 3)
X X X X X Park(sub-Question 4)
X X X X X Town(sub-Question 5)
X X X X X Bypass(sub-Question 6)

For each sub-Question the user can select ONE of the column
items, N, Y, M, W, or D

Again, this comes from the original question in the Table Field - Shop

I didn't know if this could be done with such a large number of textboxes,
or, if I would have to make a table for each of the Sub Questions - OR - if
there was some other way to do this.

JESSE
==========================================
 
J

Jesse

JOHN:

Thanks for the tips and the links.
I have downloaded the files and will thoroughly review them.

JESSE
------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top