Survey form Excel vs. Access

[Doug]

Hi,

I want to conduct a brief survey. There are around 300
participants and 8 questions. I want to take my Pocket PC
around and enter the answers to the questions
electronically. My Pocket PC has Excel on it.

What would be the best way (if possible) to use Excel to
conduct this survey? I would like to compile results from
different results after the survey is done.

I originally thought about using Access, but I have no way
to do so using my Pocket PC and don't want to buy more
software.

 

[Guest]

Hi Doug
If you enter the names running down in column A, and the answers to each participants questions in the adjacent cells on the same row, you will get a pretty good table. I suspect you could even save it as a .dbf, .csv, or .txt file and then open it in Access, though I don't use Access at all, so I'm not sure about this

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- Doug wrote: ----

Hi

I want to conduct a brief survey. There are around 300
participants and 8 questions. I want to take my Pocket PC
around and enter the answers to the questions
electronically. My Pocket PC has Excel on it

What would be the best way (if possible) to use Excel to
conduct this survey? I would like to compile results from
different results after the survey is done

I originally thought about using Access, but I have no way
to do so using my Pocket PC and don't want to buy more
software