Election Database

[SuzieQuz]

I would like to set up an election database so that everyone in our school
could vote and then I could easily tally the votes. This is for an elementary
school setting. Does anyone have one already set up or any suggestions on how
to go about this.

 

[Sean Timmons]

Seems like a relatively straightforward idea.

Have each person enter their personal info and their selection from a
drop-down list...

A lot of it depends on how much you want to have in drop downs and how much
you'd prefer be typed in.

For drop-downs, make a table with just the selections.. I'd imagine the
candidate names would be one such thing.

In your master table, set the candidate name as text, then pick Lookup
Wizard...
Tie the table to your field.

You can also have all student/employee names in a drop-down if you'd like...
Depends on how secretive you want to be. Other idea could be giving people
random numbers so their names aren't tied to their votes...

Simple query using candidate name as the group by with a count on any other
field will give results.

How far you go from here depends on personal preference.