trying to organize my coin collection........
If you'ld like to build a database for it in Access, it should be
fairly straightforward; identify the Entities - real-life things or
events - of importance, and their Attributes. For coins (stretching my
memory back to my brief foray into numismatics in 1964 or so) some of
the attributes might be Country, Denomination, IssueYear, Mint,
Condition, DateAcquired, Price, SellingPriceDesired... whatever seems
needed for your use.
You may need some small auxiliary ("lookup", but I'd advise against
using Access' Lookup Field misfeature) tables such as a list of US
Mints, Countries if you have an international collection, Conditions
(e.g. "Mint", "Uncirculated", "Very Good", etc.), or others.
Create the Table and a Form based on it to enter the data; the form
wizard will give you a decent start, and you can use form design view
to pretty it up. But the Tables come *first*.
John W. Vinson[MVP]
