Create Survey form in Access based on two linked forms

[M.Garza]

Hello,

I am helping a friend out by attempting to create an access database
that will help them understand their customer's input by way of a 45
question survey. The surveys are strictly informational and do not
have respondent information. I have created two tables tables:

Questions_tbl
QuestionID (pk)
Question

Answers_tbl
Tran_num (pk)
QuestionID
Answer

The relationship for these tables based on the QuesitonID field. Most
of these questions (39) are single choice or free text answers, there
are six that require multiple choice answers. FOur of these rate,
specific people:

On a scale from one to five, please rate Mr. Smith's:
Approachability
Knowledge
Availibility
etc.

One rates there performance, and the other rates them as a group.


Here is where I am having the most difficulty, I am not sure how to
treat these questions. Should I create a separate tabel for people
being rated and another for their perfromance and treat those as it's
own survey?

The other issue is setting up the questions in a continous form where
the person that will be doing the entering can just tab down to the
next question. Currently, because I linked the tables and created a
form, I have one question, the answer and then I have to go to the
next record to complete the next question. It is just too confusing
and maybe I am way in over my head.

Any help is greatly appreciated!

Thanks

 

[Douglas J. Steele]

Take a look at Duane Hookom's "At Your Survey" for an example of how to set
a survey up correctly

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

 

[M.Garza]

Take a look at Duane Hookom's "At Your Survey" for an example of how to set
a survey up correctly

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%2...

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)
















- Show quoted text -

Thanks!
M.RGarza