Sample

BEANIE INVENTORY RECORD DATABASE

Figure 1

Beanie Database Format

KEY

# = inventory record number

 

DATE = date updated or retreived (result of calculation)

 

ACC = number acquired

 

Sell = number traded / sold

 

Have = number presently in stock (result of calculation of those acquired minus those traded/sold

 

Av.Cost = average of 6 cost entries

 

IF Have = >5 result is YES; if <5 result is OUT)

 

Status = IF retirement date is entered result = RETIRED. No retirement date = current.

Figure 2

Sample Beanie Database Record