coin collecting template for access users

  • Thread starter Thread starter Guest
  • Start date Start date
trying to organize my coin collection........
Click to expand...

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]
 
Back
Top