Access as a questionnaire

[Poooominator]

Hello

Is Access suitable for use as an electronic questionnaire?

My intention would be to use forms with a mix of memo/text/combo boxes etc, then run a report that prints all of the inputted answers.

- how would I populate the tables (would the questions be the field names)?
- how would I join the tables to produce a query on which to run a report (what could I use as a primary Key if the questions on each form are different)?

Any suggestions would be appreciated, even if it's to tell me that Access is not suitable for this purpose!

 

[Mile-O]

Yes, Access can be used for this type of activity and this is one of those questions that appear here time after time - before posting, it always pays to search the forum for similar problems to yours as it typically saves time waiting for a response and negates the need for someone to write a response if the answer is already there.

However, although it is possible, you should know exactly what you are doing (understanding database normalisation would be extremely beneficial) and how you are going to do it.

Read this recent post for a logical table structure.