Help me create a database to give money away
January 16, 2008 2:41 PM Subscribe
Help me design a small Access application to run a prize drawing. As I see it, the MC will open the application and click the Draw button, which will select from the available prizes for that month. Once drawn, that prize becomes unavailable. MC will then type in the winner's name and click Save, setting the form ready for the next contestant.
Specs and examples follow.
posted by kc0dxh to computers & internet (8 answers total) 1 user marked this as a favorite
Prizes will be one of the following dollar denominations: 5, 10, 20, 50, 100, or Consolation Prize.
There may be more than one prize of a particular denomination, that will change from month to month.
Prizes should be chosen randomly.
Prizes cannot be given more than once. (obvious)
As an example, this months drawing may have 12 $5 prizes, 9 $10 prizes, 5 $20 prizes, 2 $50 prizes, 1 $100 prize, and 50 consolation prizes.
The application will need to be opened and closed a few times before the month's drawing is complete. Freeware applicaitons that interface with Access or Excel will be considered.