Table design for questionnaire data


New Member
Apr 23, 2007
Hi There (Apologies if this doesn't make sense!)

I need to store results from an paper audit so that the data can be entered via a form and interrogated through queries.
I have 6 text fields but the remaining 30 questions are multiple choice.
I also need to store date, time, who the auditor was

I originally created one table but this was a mistake, it was huge and I cant interrogate the data!

I want the user to select the answers from relevant drop downs.

I have created different question types based on answer types ie
Type 1. Y/N ....Type 2. a,b,c,d,e.... Type 3. 1,2,3,4,5 etc.
I have 7 different question types.

Is the correct way to do this via a few tables?

Do I need one question table for each question type, with 2 columns, an ID then Type? (so 7 tables)
And 7 corresponding answer tables ID then Type?
I have a client table already so will i need to store the ClientID in the answer table?
I also need to store date, time, who the auditor was. would this need to be in a separate table?

Apologies if this is blindingly obvious but I have been looking at it for so long it has morphed in to gibberish!

Any help gratefully received

Forum statistics

Latest member
Tommy O

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...