Voting Database

[Vinnie]

Hello all,

i have been tasked with coming up with a solution to accomodate a voting
session during a conference.
There will be approx 40 Voters.
Approx 50 Questions (all different formats; i.e. Best from 1-10, Multiple
Choice, Top 5 out 50 Choices, etc.)
The conference center has a mini LAN set up to accomadte (40 Workstations, 1
Server; Windows 2000)
I was thinking of using Access to provide the voting solution.

Would it be feasible to create a Back-End containing all the tables needed
and then create 40 Front End linking the tables to the Back-End with the
Forms needed to complete the Voting?
Or is there a better solution?

Any help is greatly Appreciated.

Vincent

 

[Duane Hookom]

Whatever method you use, consider creating tables like those found in "At
Your Survey" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. AYS
isn't the best tool to allow users to enter their own responses without
doing some tweaking.

If you have internet connectivity, there are some survey hosting providers
that allow you to set these up on line (for a fee).

 

[Vinnie]

A response from the man himself, cool. Your "At your Survey" application
was the first, and only, one I found on my Net Searching. I have to admit,
I am way too much of a novice to even think about tweaking.
I also have to have it ready to go in just a few days.
I am enlisted military and its just one of those "hurry up and do it !"
situations.
I wish I could just use one of those Net Based survey programs, but its
going to be on a secure network with no connectivity to the outside, its all
internal.

I was even thinking of having the table contain only the answers; the
questions will be from a PPT or something. The voting will be done as a
group, with a proctor up at a podium discussing the question, then they put
it to a vote.
Then when everyone has voted, they move on to the next question.

Do you know if there happens to be (in a spare junk drawer somewhere), a At
your Survey for Dummies type of app somewhere.? or even just an idea of how
the table structure should look like?

Do you think that it would work, meaning, have the 40 Front-Ends talking to
one Back End simultaneously, meaning, can access handle that burst of
writing to? I have never used access in that way. The most I have used it
is 8 users writing to a back end over the network.

Thanks for your response and I will look very closely at the AYS table
structures.

Vincent

 

[Duane Hookom]

One of the benefits of a normalized table structure is the ability to handle
multiple users more easily.

You could probalby change the continuous subform for entering responses to
single record view.

 

[Vinnie]

Thanks a lot Duane, Im well on ,my way now. I took a good hard look at ATS.
The work was already done!

If you dont mind, could I run this by you; Ive had no luck all day getting
any responses:

Trying to Figure how to go about adding an expression in a Query what will
Automatically Number the Results.

Example:
Query of the Employeee Table, of employees who live in NY:

John
Ralph
Jim
Doug

Would like to add a Number Field in there, so results would like this:
1 John
2 Ralph
3 Jim
4 Doug

Thanks As Usual !

Vincent

 

[Duane Hookom]

You can't number the records as shown with just the field that is shown in
the order that is shown. You must provide a value in the record that
identifies the sort order. You also mention "who live in NY" but you don't
show a city or state field.

 

[Vinnie]

there is a City and Stae Field. How do I use them to give me a count?
Sorta like a Fill Series in Excel.?

 

[Duane Hookom]

Can't. You haven't provided what I stated was needed.