multiple option fields or multiple yes/no fields

[NETHROW]

I'm trying to set up a db for employee counseling that will have multiple choices for a field. example

data field answer

Work Attitude Below Average Above
Gets along with peers Below Average Above
Professionalism Below Average Above

Please keep the responces as simple as possible, I'm kinda of new at this.
Thanx,
Nethrow

 

[lespaul]

This is basically a survey database:

tblQuestion
QuestionID
QuestionText

tblAnswers
AnswerID
AnswerText

tblQuestionsAnswers
QuestionID
AnswerID
(if all your answers are the same - Below, Average, Above then you really don't need this table, if you have different answers for some questions this is where that would be set up)

tblResponses
SurveyID
QuestionID
AnswerID

you should already have a person table somewhere that has employeeID, if not you'll need to create one:

tblEmployees
EmployeeID
Name
Address
Etc.

tblEmployeeSurveys
EmployeeID
SurveyID

this should get you started. You may also want to check out the relational database article on JeremyNYC's website:

http://www.alphabetcitydataworks.com/Developers/FundamentalsOfRelationalDatabaseDesign.doc

HTH

leslie

 

[dhookom]

There is an normalized employee evaluation database available at

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

There is also a more robust survey sample/demo at the same site that is similar to leslie's suggestion.

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