A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Setting up Survey Database



 
 
Thread Tools Display Modes
  #1  
Old October 31st, 2008, 07:11 PM posted to microsoft.public.access.tablesdbdesign
js
external usenet poster
 
Posts: 130
Default Setting up Survey Database

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.
  #2  
Old October 31st, 2008, 07: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.



  #3  
Old October 31st, 2008, 08:10 PM posted to microsoft.public.access.tablesdbdesign
js
external usenet poster
 
Posts: 130
Default Setting up Survey Database

I need option buttons instead of combo boxes. I also only need this to
contain one "survey". I don't need response type or numerous surveys. I don't
want the user to have to pick what survey they want. I want the form to just
open up to the "survey" screen. I tried to use it to fit my application, but
it just doesn't seem to fit just right. Around 20 people will be doing these
observations monthly. Actually each person has to do four a month. I work for
a safety department and we are trying to find our biggest area of concern
when it comes to "at-risk" behaviors, as well as those things that we are
doing right.

"Jeff Boyce" wrote:

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.




  #4  
Old October 31st, 2008, 08:47 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Setting up Survey Database

Option buttons are bound to numeric values. I'm not sure why you just
wouldn't create dropdowns for each question of "Safe" or "At Risk". I suppose
you could store 0 or 1 for safe and at-risk.

You could set the default values so only a single survey is available.
--
Duane Hookom
Microsoft Access MVP


"JS" wrote:

I need option buttons instead of combo boxes. I also only need this to
contain one "survey". I don't need response type or numerous surveys. I don't
want the user to have to pick what survey they want. I want the form to just
open up to the "survey" screen. I tried to use it to fit my application, but
it just doesn't seem to fit just right. Around 20 people will be doing these
observations monthly. Actually each person has to do four a month. I work for
a safety department and we are trying to find our biggest area of concern
when it comes to "at-risk" behaviors, as well as those things that we are
doing right.

"Jeff Boyce" wrote:

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.




  #5  
Old November 1st, 2008, 02:36 AM posted to microsoft.public.access.tablesdbdesign
Steve[_57_]
external usenet poster
 
Posts: 598
Default Setting up Survey Database

TblQuestion
QuestionID
Question

TblAnswer
AnswerID
Answer

TblAnswertoQuestion
AnswertoQuestionID
QuestionID
AnswerID

In TblAnswer, be sure AnswerID for "Safe" is 1 and AnswerID for "At-Risk" is
2.

1) Create a query that includes TblAnswertoQuestion and TblQuestion
a) Join QuestionID to QuestionID Type 3 to display all records
from TblQuestion and only those records from TblAnswertoQuestion where the
joined fields are equal
b) Pull into the fields of the query only Question from
TblQuestion and AnswerID from
TblAnswertoQuestion.
2) Create a continuous form based on the query in 1.
a) Use a textbox bound to Question
b) Use an option group bound to AnswerID. Make the first option
have a value of 1 with the label "Safe" and the second option have a value
of 2 with the label "At Risk".
c) Make the options option buttons.

Let us know how this works for you!!!!

Steve



"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.



  #6  
Old November 5th, 2008, 09:20 PM posted to microsoft.public.access.tablesdbdesign
js
external usenet poster
 
Posts: 130
Default Setting up Survey Database

Okay. I am starting to get this to work. I went ahead and made them dropdowns
instead of the option buttons. I was trying to use the option buttons so it
would resemble the paper form they will be using when actually performing the
observations, but the dropdowns shoudl be fine. I have the default value set
for the survey field on the form, however I don't know how to make it where
the subform for that survey is already visible upon opening without having to
click "Enter Results". Also, I need a button at the bottom to submit the
results and prepare the form for another entry. I am really not familiar with
writing code. I have been trying to decipher what is there, but I am
struggling a bit. I think if I get these buttons in place then I think
everything will work. I appreciate your help. Last week I could not get my
mind around how to modify the "At Your Survey" to fit my needs, but it seems
to be going better now.

"Duane Hookom" wrote:

Option buttons are bound to numeric values. I'm not sure why you just
wouldn't create dropdowns for each question of "Safe" or "At Risk". I suppose
you could store 0 or 1 for safe and at-risk.

You could set the default values so only a single survey is available.
--
Duane Hookom
Microsoft Access MVP


"JS" wrote:

I need option buttons instead of combo boxes. I also only need this to
contain one "survey". I don't need response type or numerous surveys. I don't
want the user to have to pick what survey they want. I want the form to just
open up to the "survey" screen. I tried to use it to fit my application, but
it just doesn't seem to fit just right. Around 20 people will be doing these
observations monthly. Actually each person has to do four a month. I work for
a safety department and we are trying to find our biggest area of concern
when it comes to "at-risk" behaviors, as well as those things that we are
doing right.

"Jeff Boyce" wrote:

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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.