Data Management

B

Bluemist

Hi,

A quick question- I have designed a questionnaire in Excel, this is
combination of check boxes, drop down list boxes, cells to input whol
numbers etc. I have created (in hidden rows) formula to count each o
the variables listed in drop down boxes etc). I was under the initia
understanding that the form would not be distributed to that man
people however now I am advised that this will probably go out to i
excess of 250 people. So my question relates to how I can manage th
data that I receive back.
I was intending to create a template that would take the value
calculated in each individual sheet and put them in a consolidate
template. However I don't believe this would be appropriate for 25
plus returns. Should this be integrated to MS Access or a database
Should it be put on the web and the url given out to intended people?
Are there any tutorials available on the best way to manage dat
received from forms?
I will need to be able to run data analysis by numerous permeations o
variables.
Can anyone offer a sensible and easy solution?

Thanks,
Bluemis
 
B

Bob Phillips

250 is not a large number. The difficulty is extracting it from the
questionnaires and loading somewhere else, and that will apply to Excel or
Access.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top