Collecting data to feed the database?

#1

If you were asked to survey 1000 people and collect information for your
Access database, how would you do that? Let's say its about 10
questions, basically yes/no. Would you phone each person up, send an
email with a text, or Excel, or Word file to be imported later, create a
web page, or something else?

#2

HI, Salad

Salad wrote:

Quote:

If you were asked to survey 1000 people and collect information for
your Access database, how would you do that? Let's say its about 10
questions, basically yes/no. Would you phone each person up, send an
email with a text, or Excel, or Word file to be imported later,
create a web page, or something else?

If you have Access 2007 installed take a look at this:

http://office.microsoft.com/en-us/ac...527131033.aspx

Regards
Jens

#3

"Salad" <oil (AT) vinegar (DOT) com> wrote

Quote:

If you were asked to survey 1000 people and collect information for your
Access database, how would you do that? Let's say its about 10 questions,
basically yes/no. Would you phone each person up, send an email with a
text, or Excel, or Word file to be imported later, create a web page, or
something else?

I suppose there's a very good reason why you couldn't use a split Access app
on a server (?) ...

Keith.

#4

I have had to do this on several occasions. I found that the response return
rate was always much higher using Excel. I attribute this to people being
most comfortable with Excel. All I do is attach the Excel workbook
(unzipped) to an email explaining the survey and what to do with it. The
people receiving the survey do not have to bother with unzipping the
attachment. When completed all they need do is attach it to an email and
return it. I design the process so it's very automatic from when I receive
the survey back so I don't have to manually save the Excel file or enter the
reponses.

Steve
santus (AT) penn (DOT) com

"Salad" <oil (AT) vinegar (DOT) com> wrote

Quote:

If you were asked to survey 1000 people and collect information for your
Access database, how would you do that? Let's say its about 10 questions,
basically yes/no. Would you phone each person up, send an email with a
text, or Excel, or Word file to be imported later, create a web page, or
something else?

#5

Jens Schilling wrote:

Quote:

HI, Salad

Salad wrote:

If you were asked to survey 1000 people and collect information for
your Access database, how would you do that? Let's say its about 10
questions, basically yes/no. Would you phone each person up, send an
email with a text, or Excel, or Word file to be imported later,
create a web page, or something else?

If you have Access 2007 installed take a look at this:

http://office.microsoft.com/en-us/ac...527131033.aspx

Regards
Jens

Mindblowing. Thanks much.

#6

Keith Wilby wrote:

Quote:

"Salad" <oil (AT) vinegar (DOT) com> wrote in message
news:wq-dnSb7qd6vL_DXnZ2dnUVZ_sednZ2d (AT) earthlink (DOT) com...

If you were asked to survey 1000 people and collect information for
your Access database, how would you do that? Let's say its about 10
questions, basically yes/no. Would you phone each person up, send an
email with a text, or Excel, or Word file to be imported later, create
a web page, or something else?

I suppose there's a very good reason why you couldn't use a split Access
app on a server (?) ...

Keith.

Yes. I'd assume the majority don't have Access on their computer.

#7

Steve wrote:

Quote:

I have had to do this on several occasions. I found that the response return
rate was always much higher using Excel. I attribute this to people being
most comfortable with Excel. All I do is attach the Excel workbook
(unzipped) to an email explaining the survey and what to do with it. The
people receiving the survey do not have to bother with unzipping the
attachment. When completed all they need do is attach it to an email and
return it. I design the process so it's very automatic from when I receive
the survey back so I don't have to manually save the Excel file or enter the
reponses.

Steve
santus (AT) penn (DOT) com

"Salad" <oil (AT) vinegar (DOT) com> wrote in message
news:wq-dnSb7qd6vL_DXnZ2dnUVZ_sednZ2d (AT) earthlink (DOT) com...

If you were asked to survey 1000 people and collect information for your
Access database, how would you do that? Let's say its about 10 questions,
basically yes/no. Would you phone each person up, send an email with a
text, or Excel, or Word file to be imported later, create a web page, or
something else?

I was thinking an Excel file but when I saw the option provided by Jens,
that Excel idea flew out the window.

#8

Hi salad,

I just read this thread and though instantly of Outlook. You can do
all sorts of surveys and such in there and dump it right back to
Access (directly). I also noticed that it has been suggested already.
Didnt know there was a wizard for it though - thats very helpful
indeed.

The only time I dont use Outlook for something like this (assuming
that Outlook is actually available to use of course) is if I have a
really massive data load to capture, such as shelf pricing from a
supermarket (each shelf, location, ean, price, store, date, time,
person). I use Excel and a custom form for that.

Cheers

The Frog

#9

Mr.Frog.to.you (AT) googlemail (DOT) com wrote:

Quote:

Hi salad,

I just read this thread and though instantly of Outlook. You can do
all sorts of surveys and such in there and dump it right back to
Access (directly). I also noticed that it has been suggested already.
Didnt know there was a wizard for it though - thats very helpful
indeed.

Neither did I. That's a cool feature.

Quote:

The only time I dont use Outlook for something like this (assuming
that Outlook is actually available to use of course) is if I have a
really massive data load to capture, such as shelf pricing from a
supermarket (each shelf, location, ean, price, store, date, time,
person). I use Excel and a custom form for that.

Thanks for the update.

Quote:

Cheers

The Frog

#10

A couple of questions .....
1. Does the recipient need Outlook2007 for this to work?

2. How does the data get back to the sender?

3. Does the sender do the dumping of data to Access? How?

Thanks!

Steve

<Mr.Frog.to.you (AT) googlemail (DOT) com> wrote

Quote:

Hi salad,

I just read this thread and though instantly of Outlook. You can do
all sorts of surveys and such in there and dump it right back to
Access (directly). I also noticed that it has been suggested already.
Didnt know there was a wizard for it though - thats very helpful
indeed.

The only time I dont use Outlook for something like this (assuming
that Outlook is actually available to use of course) is if I have a
really massive data load to capture, such as shelf pricing from a
supermarket (each shelf, location, ean, price, store, date, time,
person). I use Excel and a custom form for that.

Cheers

The Frog