Survey Database structure

[cdborg]

I have created many queries, and reports for a survey application where each question represented one one field in the sole table in the database. This type of structure made it very difficult to work with the underlying data.
I have re-created the database and this time have normalized its structure & was wondering if anyone could give me some feedback/advise. Here is my basic structure:

tblAnswers
Answerid
Questionid
Clientid
Answer
Date

tblQuestions
Questionid
QuestionText

tblParticipant
Participantid
ParticipantName
Locationid

tblLocations
Locationid
LocationDesc

tblSurveyAnswers
Surveyid
Answerid
SurveyDesc

 

[Blorf]

Your structures look good. Be sure to set your relationships to ensure good data goes in.

Force your question and answer boxes to use combo box look ups on forms.

Barring that, I think you are on your way.

ChaZ

 

[dhookom]

You might want to review "At Your Survey" which can be downloaded from

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

Duane
MS Access MVP
Find out how to get great answers faq219-2884.