Duane Hookom has a sample survey database at

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

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.

This is a good sample of how to set up a normalized survey database.  In
many cases it is fully functional without the need to do any modifications
to the structure of the tables, forms, and reports.

All you need to do is add and delete records to change it for your survey.