Background:
Our village has recently taken part in a questionnaire/survey whereby
everyone filled in a paper form which is now being transferred to
computer file. The software provided by our local authority (Council) is
not particularly good: you have to go on line for it to build a "Project
List" of surveys done for other villages before selecting & downloading
the one for us - it does this /every /time you want to transfer data
from paper to file. The "Questionnaire" part then loads but is not very
user friendly, not allowing you to go back to previous questions without
loosing data back to that point . . . . I could go on. Once data has
been transferred to files for the session, it must be uploaded but the
process of building a Project List etc.. occurs again first - all
extremely slow & frustrating.
In a moment of frustration/weakness, I did say to the chap running the
project for the village (he did have a good head of hair before it all
started!) that it would be fairly straight forward to design a database
that would do all that is required so much easier. Luckily for me, I'm
too late this time as the project is well under way but may be repeated
in a couple of years time.
So my question is has anyone designed a DataPerfect database for
questionnaires/surveys? It seems to me that that it should be fairly
straight forward but maybe laborious. There questions fall into four
categories:
Simple Yes/No responses,
Multiple choice options whereby only one of a number of options must
be chosen,
Multiple choice options whereby none, one, some or all of a number
of options must be chosen.
A box allowing comments to be written.
The first and last are easy, I'm not sure of the best way to achieve the
other two.
The other problem is the size of the questionnaire. There are just under
200 questions which would be too many for a single panel, although they
are divided into sections such as Transport, Environment etc... I had a
thought of using a panel for each section with a master Table of
Contents Panel with links to all other panels a bit like an table of
contents linking to the relevant pages of a book and maybe links from
each panel to previous & next panels.
This is all thankfully a way off yet but any thoughts or ideas would be
welcomed.
Michael
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
