View Single Post
  #8  
Old November 16th, 2009, 04:07 PM posted to microsoft.public.access.tablesdbdesign
hannah
external usenet poster
 
Posts: 66
Default Table design help!

Hello Fred,
Your honesty is very much appreciated - every bit of advice is really useful
and I dread to think where I'd be without the amazingly helpful people in
this group.

In response to your question, this application won't be where the person
participates in the survey - they've already filled it in on paper. It will
be mainly me that inputs the data but I'm hoping that I can make the
application easy enough to use so that other people could use it too
(ambitious as this seems given my access skills!) I think this is part of the
problem in that the people who designed the questionnaire didn't make it very
clear or give much thought to how they were going to analyze the data at all!

The other key bit of information I should have written in my description was
that after I've put all the data in, it won't be changed or updated in anyway
(it's part of a one-off research project). I want people to be able to use
the application and see how it's set up but there will be no need to
add/change data in future.

I definitely agree that this needs simplified but I'm not really sure how to
go about it? unfortunately there's no budget for getting someone else to
develop it. At the moment, I've got a rudimentary application but I'm far
from sure that I'm going aboout it in the best way.

Anyway, thanks again for all your help (and patience!) - I genuinely can't
tell you how much I appreciate it.

"Fred" wrote:

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.