Questionnaire HELP!

[pipegg]

Hi,

I have the task of creating a new questionaire and associated reporting. Normally I would have done this in Excel, but due to the size I feel it is neccessary to create this in Access.

My question is should I revise my table of completed forms? I initially planned to create a form to populate the completed forms table. Job done?
However I am sure I have read somewhere this is not the best in terms of reporting and I should have a table of answers for each question? Is this correct I have approx 50 questions?

I have the following tables:

1) Staff Details
2) Table Of Questions
3) Table Of Answers (Questions are multiple choice)
4) Table of completed forms

 

[KenHigg]

I'm not sure Pip was considering a seperate table for each question...???

 

[pipegg]

Thanks guys,

Unfortunately I was considering 50 tables!

I had researched and found the 50 columns was wrong, but when I got back to working on it I had been unable to find the same reference! I for some reason thought it was 50 tables and 50 rows, didn't occur to me!

I think I am still stuck in my Excel head as I'm still spend 80% of my time working in it! The 50 rows makes a lot more sense.

Thanks again, I should be OK from here (hopefully)!

Cheers

Phill