A very simple Newbie Question, Access or VB?

[Raycaster]

I'm 3/4 finished 2 simple VB apps for a upcoming silent auction being held at my children's school.

Very Simple - This is what it does:

1st app allows input and builds a text database

Unit ID (Done before Auction)
Unit Description (Done before Auction)
Unit Donor (Done before Auction)
Unit Value (Done before Auction)
Unit Purchaser #
Unit Winning Bid

2nd app (cashier)

Lets cashier query text file for Purchaser # and prints out a nice sheet with school logo and all the items he/she has purchased and totals.

The auction is run in "rounds" and as results are finished I sneaker-net the new text file over to the cashier table and update it.

I'm almost finished the VB but I started thinking that this may be a simple access database query-report. I took a access 2003 course 2 years ago so I'm back to a newbie.

If anyone can point me to some tutorials involving the same basics I would very much appreciate it. I've been playing with the query and report functions with 3 5lb books in front of me but... If its much easier just in VB alone than I can finish what I have also but access would be a much nicer looking app...

Thank you for your time.

[nico5038]

In Access this would require three tables:

tblUnit
UnitID (*)
UnitDescription
UnitDonor
UnitValue

tblPurchaser
UnitPurchaser # (*)
PurchaserName
PurchaserAddress

tblUnitPurchaser
UnitID (*)
Purchaser # (*)
WinningBid

The (*) indicates the field(s) making the unique identifier.

Having these tables will allow you to produce the Units per Purchaser by JOINing the tables.

Getting the idea ?

Nic;o)