can I input sections of survey data results into tables that allow me to copy same responces along s

[francesca.campagnoli]

Hello

I am creating an access database for a survey data input. The survey
replies are multiple choice.

My question is: Instead of having each responce entered through
access form, can I have a table with 30 respondents rows and 6
questions columns that allows me to copy the same answer?
How can I do this?

Thank you very much.
Francesca

 

[Jeff C]

Since Access is a relational database, create a table for those taking the
survey, another table for all the questions, and a third table with the
answer choices. Properly related, select the table with all those taking the
survey and then click on Autoform. The results may give you ideas.

 

[Jeff C]

Also try this link for more info:

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