Access Database for managing raffle auctions

One of the annual events I help with is the SPCA Theme Basket auction, and year after year it has proven to be a challenge. At least as far as the logistics of managing the drawing. Different methods were tried but most years they ended in mistakes due to volunteers being stretched thin enough to make mistakes, and everyone blaming each other, which didn’t help either.

To help ease the burden, for the past couple of years I was working on developing an Access database to help manage auction, as the Excel spreadsheets used in the past required too much human input to generate the calling lists, it sometimes would end up shifting a line. The idea of the database was to minimize human input and errors from entering the winning numbers, to generating the calling sheets. But because the prior experiences with the Excel spreadsheets typically ended in disaster, it failed to garner support from the other volunteers.

The all paper method that was employed last year didn’t work much better either. It required longer hours from the volunteers, and mistakes were still made, probably even more so. That being said, this year ended up being the year of attempting this new method I’ve been working on, with the Access database.Continue reading