Create a Survey

[Guest]

Hi

I would like to create a survey where I can email the link out to people to
conduct a survey. The result of the survey is automatic transfer to the
database which can be tallies at a later time.

Can Access do this? if yes, Could anyone show me how?

I read on the Access website on Sample Table Design to Support Questionnaire
Applications but it doesn't help much.

Thank you very much for your time to read this.
Hong

 

[Douglas J. Steele]

This isn't really something that Access can do, since you must have Access
installed in order to run an Access application.

 

[Guest]

Hi Douglas

Is there a table structure that I can follow.

With the nonrelational table design as below

Respondent ID (Primary key)
Question 1
Question 2 - --- Question n.

If my question is two long, it won't fit.

But if I have the Relational Table design which is simplier
Respondent ID (Primary key)
Question ID (Primary Key)
Response

But I don't know how to creat a survey form for this table.

Could you please point me to the right direction.

Thanks
Hong

 

[Douglas J. Steele]

Take a look at Duane Hookom's "At Your Survey" for an example of a
well-designed survey application.

For Access 97:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 97'

For Access 2000 and newer:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

 

[Duane Hookom]

Porting At Your Survey to the web would take some fancy ASP or other
language. I've been asked many times about a web version but I work mainly
with ColdFusion which isn't as universal as ASP is.