I'm going to start making a database of all of the systems I've had from Japan, mostly for personal use. I've been trying to think of characteristics to include as sortable. The database will be 95% limited editions, rarities, etc.
Here's what I have so far, in no particular order:
Box Number (mostly for Sega items)
Sister console available? (ie Sega & Victor Wondermega)
# of units produced
Outputs 1, 2, 3
Inputs 1, 2, 3
# of bundled controllers
# of controller ports
Wireless controller standard?
CD Top/Front Loading
CD-Tray (motorized, push button, etc)
Bundled Software 1, 2, 3, 4
Promo Item 1, 2, 3, 4, 5
Reseller stuff (length, width, height, weight, shipping weight, box type, etc)
Shipping Price from Japan
In the end I want to be able to search and find, for example, CD systems that were skeleton editions and limited in number that can use memory cards (PS2 Ocean Blue, Zen Black, Kasumi XBOX, etc.). Or maybe a TV-Game system with two players that costs less than $50 to ship.
I'm not a technical guy and don't pretend to be one so I usually don't offer any information on things like Bits, colors, processor speed, etc. I could probably add in Bits, tho...I guess...maybe....eh, what's on TV?
Any tips on what to uyse to create such a database? I have Access so that's my default choice. I'd like it to be searchable.