Nonprofit Silent Auction Database Help

[blueboy18]

I am wanting to create a basic database to use for a nonprofit silent auction. I would want to go ahead and already enter the auction items including description, item #, donor name, donor address and retail value. The night of the auction, once bidding has closed, I would then enter the winning bidder’s name, telephone # and realized auction price. I want to be able to print or view a report/table/etc that sorts auction items by # and another that would sort winning bidders along with each item he/she won. I have very little Access experience and welcome any suggestions or help. Is Access even the way to go for this or should I use Excel for this task?

[ranman256]

yes Access is perfect for this, and will get your feet wet into learning it.
This is not a complex app so you should learn a lot.

you want a tPersons table
PersonID (autonum)
FirstN,
LastN,
Addr,
etc

a tInventory table
ItemID (autonum)
ItemName,
Description,
ValueAmt,
DonorID (from tPersons.PersonID)
WinnerID (from tPersons.PersonID)
SoldAmt,
etc

build forms for data entry,
queries and reports to extract data.

[alansidman]

crossposted: https://www.excelforum.com/excel-gen...-database.html