When my collection started getting bigger than what I had on my Excel spreadsheet I started looking for something better.
Found several databases but each had their pros and cons. And none had all the fields I wanted to have in the database so I created an Access database for it and used fields from each,.
This is what I ended up with - on my LibreOffice Calc (spreadsheet). I make the entries there as I receive items and then occasionally will add them to the database.
Seq # (so I can sort any way I want)
Cat No
MA (I check this column once it's entered in Access)
Description
Color(s)
Series / Set
Manufacturer
Scale
Group (my own classification)
Road Name Code
Road Name Description
Road Logo
Reporting Mark
Cat (from Yard Office with some additional items)
Type (from Yard Office with some additional items)
Min Curve
Length
Built
Status (used in box, new without box, etc.)
Config (ready-to-run [used], etc.)
Years Cataloged
MSRP
Purch Date
Sold by
Purch Price
S & H / Tax
Calc. Total
% MSRP Purch Price
Item Cond
Best Value
% MSRP Best Value
CY Greenberg Value
% MSRP CY Greenburg Value
MITrains Value Date
MITrains Value Price
% MSRP MITrains Value Price
Qty
Box Type
Box Cond
Images (up to 8)
Notes
Granted it's not the most efficient database, but it works for me.
I'd love to figure out how to create tables so when I make an entry - say in the Cat field (which is a 2-character code) when I run the various reports, Access would print what that cat description is.
