Managing a silent auction

[Guest]

Has anyone designed an Access database to manage a charity silent auction? I
need to be able to keep track of bidders, the items that are bought, the
sales price, and also to be able to print invoices at the end of the auction
for each bidder listing the items they bought, their sales price, and the
total amount owed. I am a complete novice with Access and I am afraid it
will take me forever to get this designed!

 

[Yellowstone Valley Tree Surgeons]

This would be a good place to start using Access. My first project was for
a charity membership database, very similar to what you need. I'm guessing
it will take you at least 30 hours of work to do this, if you are new. You
need a members table, a products table, an invoice table, and a lineitem
table for each item in the invoice. If you want to use this application for
multiple auctions, and want to keep each auction separate so you can compare
profits, total sales, etc, then you should also have an auction table.

After these talbes are setup and linked correctly, then begin building the
forms for data entry. Finally, build the reports you need such as invoices.