Many Check Boxes.

[Guest]

I have been given a paper form with 20+ categories, with 15 to 25 questions
in each category, each question has a check box. It is possible that all
questions would be checked but, more probable that only about half. I have
been asked to create an Access form that looks as close to paper as possible.
I have created forms with 3-4 check boxes but, never this many. A table for
each category and each question a field? This just doesn't seem right. Any
suggestions or examples on how this should be done correctly would be
appreciated. Thank-you

 

[Sandra Daigle]

Take a look at "At Your Survey" by Duane Hookom:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

This database will give you an idea of how to create a properly normalized
survey, test or questionnaire.

 

[Guest]

Thank-you, great example, I will be able to get tables normalized now.

Take a look at "At Your Survey" by Duane Hookom:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

This database will give you an idea of how to create a properly normalized
survey, test or questionnaire.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I have been given a paper form with 20+ categories, with 15 to 25
questions in each category, each question has a check box. It is
possible that all questions would be checked but, more probable that
only about half. I have been asked to create an Access form that
looks as close to paper as possible. I have created forms with 3-4
check boxes but, never this many. A table for each category and each
question a field? This just doesn't seem right. Any suggestions or
examples on how this should be done correctly would be appreciated.
Thank-you