Hello Hannah,

First, answering your specific question, one-field tables are seldom useful
and seldom "the answer" for what you are trying to do. The one notable
exception is to to create a "pick list" for dropdowns etc.

One thing that you didn't tell us, but I'm presuming is the case.....will
this application be where they actually participate in the survey? I.E. the
person sits at the computer, and looks at the questions and answers them
through the Access application that you are going to write?


- - - -

That said, your mission as you describe it is very complex. For you to do
it yourself as described would probably require sever years of teaching
rather than a post in this group.

I think that you are going to have to either simplify it, or else have
someone more expert work on it for you. (like pay a developer or something.)
But don't use anyone who solicits for business in these forums.


Just being honest, which is hopefully helpful.