Efficent Table Design

[N. Evar]

I am designing a database that needs to track information from different
questionniares (some of the information maybe the same and some maybe
different between the versions of the questionnaires). In looking at how to
efficently design the database, it seems like I should create a table of the
Questions (with question numbers, question descriptions, etc), a table with
the Responses (id#, question #, response). Would this be correct? It seems
that I am missing how to link the two together. Do I need to create a third
table with the Sequencing of the question #? I guess I am confused. Any
suggestions?
Thanks!

 

[Amy Blankenship]

If you have the QuestionID in the Response table, you can drag QuestionID
from the Question table to QuestionID in the Response table in the
relationship window. There's a sample database design with the Database
Basics presentation here http://www.eurotaac.com/2005_files.asp

HTH;

Amy

 

[KARL DEWEY]

Sounds like you want a Survey database. See post by Jeff Boyce.
Duane H. has a tool you may wish to review:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
Regards
Jeff Boyce
<Office/Access MVP>