View Single Post
  #2  
Old October 31st, 2008, 06:43 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Setting up Survey Database

As I recall, you could use "At Your Survey" to build your survey, rather
than using as a model you'd tweak.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"JS" wrote in message
...
I am trying to create something of a survey database. I have seen the
sample
database "At Your Survey", but I am not sure how to tweak it to what I
need.
I have a form that is for safety observations. Supervisors will observe
procedures and mark them as "safe" or "at-risk". I have a list of things
they
can observe but they don't necessarily have to observe everything on the
list. For example:
1. Stair/Ladder Use
2. Elevated Work
They could observe one of these things and mark it as "safe" or "at-risk".
I
understand the concept of a table for questions and a table for answers
and
then another table for possible answers for each question. I need all of
the
possible observations to show up on the form, even if they are not
selected
as safe or at-risk. I am unsure how to set up the form or the response
table
from the form. I have been reading all the posts and I know that the "At
Your
Survey" is a good example, but I just don't know how to modify it so that
all
my observations show at once on the form. I also would like to have the
"safe" and "at-risk" options as option buttons if possible. Thank you.