Survey or Poll creation...

[Mike]

Hi there,

I'm just brainstorming here and wanted to get others' input. I'm looking for a way to have an "Exit
Survey" at an event I'm planning. I figure I can set up some PCs that would be linked to a server
and could survey the people this way isntead of using a paper survey that I then have to go tally
the results by hand.

Is this doable in Access? I can create a form with questions and radio buttons or dropdowns or
whatever with no problem but am not sure about the "submit" portion of the survey/poll.

Has anyone used Access for this before and maybe have a sample database that you could show me or
give me?

Thanks.

 

[Mike]

Use a split database. You could use a backend mdb file with the data table
on the server, linked to the program file (a copy of which should be loaded
onto each PC). Build the form in the front end program on the PCs like you
said. The submit button would have 2 functions to perform 1) Save the data
in the form to the backend database on the server, and then 2) move to a new
record for the next person to use. You just need to make sure you don't
allow record navigation that would make it possible for a participation to
go back and change someone else's responses in another record.

HTH

 

[Mike]

Use a split database. You could use a backend mdb file with the data table
on the server, linked to the program file (a copy of which should be loaded
onto each PC). Build the form in the front end program on the PCs like you
said. The submit button would have 2 functions to perform 1) Save the data
in the form to the backend database on the server, and then 2) move to a new
record for the next person to use. You just need to make sure you don't
allow record navigation that would make it possible for a participation to
go back and change someone else's responses in another record.

HTH

 

[Mike]

You can do it either way. If it is all new programming, you could program it
as one mdb, then split it when you're done. I've usually found this more
convenient. If you are linking a new program to an existing database, of
course, you'd have to do the front-end by itself, then link it to the
existing mdb. Either way will work.

HTH

 

[Mike]

You can do it either way. If it is all new programming, you could program it
as one mdb, then split it when you're done. I've usually found this more
convenient. If you are linking a new program to an existing database, of
course, you'd have to do the front-end by itself, then link it to the
existing mdb. Either way will work.

HTH