Survey Database

[debinnyc]

I am working in Access 2003 and trying to design a database to collect survey
results. I have the following setup:

tblQuestion
QuestionID Autonumber PK
Section Integer
Question Text

tblRespondent

RespondentID Autonumber PK
Name Text
Address Text
etc.

tblSurveyResponses

SurveyDate DateTime - Default Date()
RespondentID Long FK on tblRespondent
QuestionID Long FK on tblQuestion
Answer Integer

and a query that joins the tables:
SELECT SR.Answer As Response
FROM (tblSurveyResponses As SR INNER JOIN tblRespondent As Rs ON
SR.RespondentID = Rs.RespondentID) INNER JOIN tblQuestion As Qu ON
SR.QuestionID = Qu.QuestionID
ORDER BY Rs.Name, SR.SurveyDate, Qu.Question

My questions are:

What is the best way to join to an employee table (surveys have a place for
employee being surveyed, but sometimes don't get a response)

How do you suggest I create a form to enter the data efficiently? I assume I
would have to create another query, but that would be dependent on how I can
fold the employee tbl into the mix.

Sorry for being long winded, thanks for your help.

 

[John Spencer]

For some ideas on how to set this up

Duane Hookom has a sample survey database "At Your Survey" at

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4

This fully functional application uses a small collection of tables,
queries, forms, reports, and code to manage multiple surveys. Users can
create a survey, define questions, enter pre-defined answers, limit to
list, report results, create crosstabs, and other features without
changing the design of any objects.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================