1 of 1 people found this helpful
The key is to set up a data model that works for Surveys and which also supports your chosen response formats.
You only need surveys if you plan on having more than one survey. But you need one record for each question, one record for each response to a question and one record for each person taking the survey. Responses serves as a Join table between respondents and questions as well as recording each person's response to a given question.
Other supporting tables may also be needed, but that's a starting point for what you need.