Keeping track of one's collection
Post new topic Reply to topic Page 4 of 51, 2, 3, 4, 5
Author

User avatar

Grandstanding Collector

Posts: 6078
Joined: May 03, 2003
Last Visit: Jul 31, 2021
Location: Waterloo, Ontario, Canada

Post Posted: Mon Apr 09, 2007 4:37 pm 
 

Xaxaxe wrote:Any advice or resources you'd recommend? Or should I pretend it's no worse than Excel and just jump right in?  :)


Access isn't that bad, just jump right in.  The main difference between using something like Access vs Excel is that you try to avoid duplicating information.  So you would probably have a separate table that lists company info that would link to your entries in the items table (so you avoid typing in the company each time - just reference it from the Companies table).  

I'm not sure how many tables you really need in setting up a database - the obvious ones are an Items table, Company table, Store Purchased From table.

 WWW  


Prolific Collector

Posts: 115
Joined: Mar 20, 2007
Last Visit: Sep 27, 2007

Post Posted: Mon Apr 09, 2007 4:56 pm 
 

Xaxaxe wrote:Sadly, that is not me. But I'm assuming Access would still work for small collections.  :)


It'll work, you just wouldn't derive as much benefit.  Access can make huge amounts of data much more manageable than they would be in Excel.  It'd still be a good way to learn the program.

  

User avatar

Grandstanding Collector

Posts: 8219
Joined: Jan 21, 2005
Last Visit: Jun 12, 2017
Location: Wallasey, Merseyside, UK

Post Posted: Mon Apr 09, 2007 7:05 pm 
 

i've used access many times in the past. its a good little program and very easy to manipulate and quite easy to learn as well.

might not be a bad move....

Al



  


Prolific Collector

Posts: 636
Joined: Sep 14, 2005
Last Visit: Jan 16, 2009
Location: Montreal, Canada

Post Posted: Mon Apr 09, 2007 8:21 pm 
 

If you don't want to pay Microsoft to be able to track your items, you might want to check out MySQL.


"Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats."
--H.L. Mencken

 WWW  


Prolific Collector

Posts: 117
Joined: Feb 05, 2005
Last Visit: Sep 14, 2008
Location: Ottawa, Canada

Post Posted: Thu Apr 12, 2007 8:34 am 
 

Still using Excel, with hyperlinks to external documents..  

I made an attempt to convert to Access, but it turned out to be more work than I thought (to achive the desired results), so it was abandoned.


Gary H. Kramer

  


Long-Winded Collector
Acaeum Donor

Posts: 3066
Joined: Jul 09, 2004
Last Visit: Apr 30, 2015

Post Posted: Thu Apr 12, 2007 4:49 pm 
 

Mars wrote:Access isn't that bad, just jump right in.  The main difference between using something like Access vs Excel is that you try to avoid duplicating information.  So you would probably have a separate table that lists company info that would link to your entries in the items table (so you avoid typing in the company each time - just reference it from the Companies table).  

I'm not sure how many tables you really need in setting up a database - the obvious ones are an Items table, Company table, Store Purchased From table.

Everything Mars said is correct.  However, as databases go, Access is a horrible, horrible beast.  It's only saving grace is that it works on a typical Windows PC.  If you don't need to use a database, I'd recommend sticking with Excel.  It might not be as tidy but it gets the job done.

For my own collection, I use a technique called "looking at the pile of stuff in the corner".  Sometimes, I rummage through it like an untrained bulette.

 YIM  

User avatar

Verbose Collector
JG Valuation Board

Posts: 1665
Joined: Jul 01, 2006
Last Visit: Jul 19, 2021
Location: Moncton, NB Canada

Post Posted: Thu Apr 12, 2007 5:13 pm 
 

If you want to use a spreadsheet that is Microsoft compatible without having to pay for office try:

http://www.openoffice.org/


Check out my Chaosium sourcebook.
Secrets of Tibet

  

User avatar

Grandstanding Collector

Posts: 8219
Joined: Jan 21, 2005
Last Visit: Jun 12, 2017
Location: Wallasey, Merseyside, UK

Post Posted: Thu Apr 12, 2007 5:38 pm 
 

deimos3428 wrote:
For my own collection, I use a technique called "looking at the pile of stuff in the corner".  Sometimes, I rummage through it like an untrained bulette.


Deim? i like your style dude :) a person after my own heart :D

Al



  

User avatar

Long-Winded Collector
Subweb Admin
JG Valuation Board

Posts: 4497
Joined: Nov 08, 2002
Last Visit: Aug 02, 2021
Location: Land of 10,000 ponds

Post Posted: Thu Apr 12, 2007 5:58 pm 
 

:roll:

Get organized. Course it sucks having something on a list and not knowing where it is  :wink: (But I want to say I'm more like a blind Umber Hulk digging through the shelves and boxes)

ShaneG.


I reject your reality and substitute my own

 WWW  


Prolific Collector

Posts: 414
Joined: Mar 26, 2006
Last Visit: Nov 30, 2007
Location: Chicago

Post Posted: Thu Apr 12, 2007 10:49 pm 
 

killjoy32 wrote:
Deim? i like your style dude :) a person after my own heart :D

Al


Me too! :lol:


A Wizard is never late, Frodo Baggins, nor is he early. He arrives precisely when he means to.

  


Prolific Collector

Posts: 195
Joined: Mar 31, 2006
Last Visit: Jan 23, 2009
Location: UK

Post Posted: Fri Apr 13, 2007 10:11 am 
 

Finding stuff> This is where i'm sorta glad my collection isn't that vast and we have that huuuuge set of shelves. I have one shelf.. seriously.. only ONE. out of about 12.. bah. My man keeps buying books so I just leech off his collection.. mwahahaha.
But, it does mean everything is nice and easy to find. It's on the D&D or AD&D shelf provided Rob hasn't taken one of the books to read and left it somewhere stupid (why oh WHY does he do this? Books do not belong under BEDS! or half under the sofa!)
I love my shelf of books, it's all meticulously organised unlike his shelves.. i'm a bit obsessive about things like that... hell, I'm the person who keeps her cd collection in alphabetical chronilogical order and will rearrange other peoples stuff because it bugs me.. i'm terrible.


"Somehow, in hell I knew there would be mushrooms"

 WWW  

User avatar

Grandstanding Collector

Posts: 8219
Joined: Jan 21, 2005
Last Visit: Jun 12, 2017
Location: Wallasey, Merseyside, UK

Post Posted: Fri Apr 13, 2007 10:45 am 
 

flying_purple_monkfish wrote:I love my shelf of books, it's all meticulously organised unlike his shelves.. i'm a bit obsessive about things like that... hell, I'm the person who keeps her cd collection in alphabetical chronilogical order and will rearrange other peoples stuff because it bugs me.. i'm terrible.


hey just yesterday i found my kobold hall inside my bloodbowl box.

you know, i dont even remember putting it there and couldnt figure out where the hell it had gone! i'd also put 2 tourney mods inside my silver anniversary box and didnt realise they were there either :)

oh what fun, no wonder i can never find anything.

however on a lighter note, i DID find a packet of 6 old unused orange dice. gotta try and figure out now what the hell they belong to  :P

the joys of collecting :)

Al



  


Prolific Collector

Posts: 195
Joined: Mar 31, 2006
Last Visit: Jan 23, 2009
Location: UK

Post Posted: Fri Apr 13, 2007 2:37 pm 
 

Silly men, putting your things in any old box (hmm.. was that euphamism intended? lol)
At one point I used to store all my planescape books inside the larger box sets because I didn't have the room on my bookshelf (I used to live in a tiiiny room... seriously.. our BATHROOM is bigger than that bedroom.. it was a nightmare. So nice to have our own house and not share with 6 guys)
It is fun finding wierd things though. We were going through a bunch of stuff we'd stored in the "basement" (it's more a glorified cupboard really) and so going through a few water damaged boxes of books we found a whole bunch of things we forgot we had. Like a few of my PS1 games (i'd wondered where i'd put them) and a couple of half read books that still had the recepts for movies from 1996 as bookmarks! eeep. No interesting rp related finds yet though... I might trawl through the box of CCGs and see what I find.


"Somehow, in hell I knew there would be mushrooms"

 WWW  

User avatar

Grandstanding Collector

Posts: 8219
Joined: Jan 21, 2005
Last Visit: Jun 12, 2017
Location: Wallasey, Merseyside, UK

Post Posted: Fri Apr 13, 2007 3:18 pm 
 

nah it was a case of i was moving things to look for something and i must have put it there for safekeeping and totally forgot.

i dont mind at all. its an adventure then finding it again :)

Al



  


Long-Winded Collector
Acaeum Donor

Posts: 3066
Joined: Jul 09, 2004
Last Visit: Apr 30, 2015

Post Posted: Fri Apr 13, 2007 4:05 pm 
 

killjoy32 wrote:nah it was a case of i was moving things to look for something and i must have put it there for safekeeping and totally forgot.

i dont mind at all. its an adventure then finding it again :)

Al

Hunting for parts of your existing collection in your own home is infinitely more exciting than hunting for stuff on eBay:

Almost no bidding wars.
No stock photos.
It's easy to stay within your budget.
Eventually, if you're patient, another copy will come along.
You don't have to worry about somebody else grabbing the BIN before you.
It's rare to have excessive shipping & handling fees from the kitchen.

 YIM  

User avatar

Grandstanding Collector

Posts: 8219
Joined: Jan 21, 2005
Last Visit: Jun 12, 2017
Location: Wallasey, Merseyside, UK

Post Posted: Fri Apr 13, 2007 5:23 pm 
 

deimos3428 wrote:
It's rare to have excessive shipping & handling fees from the kitchen.


i was thinking of a $200 handling fee....  :P



  

User avatar

Long-Winded Collector
Subweb Admin
JG Valuation Board

Posts: 4497
Joined: Nov 08, 2002
Last Visit: Aug 02, 2021
Location: Land of 10,000 ponds

Post Posted: Fri Apr 13, 2007 5:36 pm 
 

killjoy32 wrote:
i was thinking of a $200 handling fee....  :P


Don't forget to MBag that too, it'll find your storage area no problem :wink:

ShaneG.


I reject your reality and substitute my own

 WWW  

User avatar

Grandstanding Collector

Posts: 8219
Joined: Jan 21, 2005
Last Visit: Jun 12, 2017
Location: Wallasey, Merseyside, UK

Post Posted: Fri Apr 13, 2007 5:48 pm 
 

Plaag wrote:
Don't forget to MBag that too, it'll find your storage area no problem :wink:

ShaneG.


but it might go missing between the kitchen and the back room...

:D

Al



  


Active Collector

Posts: 82
Joined: Apr 25, 2004
Last Visit: Jul 28, 2021

Post Posted: Fri Apr 13, 2007 7:25 pm 
 

Not to highjack the thread but:

If I can in the next few days I'll try to get my little brother to write up an insider's view of this and post it here....he's pretty savvy and can probably give some good tips, and maybe some ideas for insuring this stuff that will stand scrutiny. In my case, he's told me to maintain better records, but mostly just to bump my existing coverage to the highest level I can WITHOUT declaring my collectibles...in most cases, raising your limit from 40 grand to say 60 grand will cover all that stuff anyway.  Besides, who needs furniture?  If something catastrophic occurs I'll definitely replace my modules first....  

Mike B.


I would love to hear what your bro has to say about this, Mike.  Maybe I am being sold a false bill of good from my agent and if he as some insider knowledge I would enjoy hearing it.

  


Prolific Collector

Posts: 246
Joined: Nov 30, 2006
Last Visit: Sep 29, 2009
Location: Boise, ID

Post Posted: Sun Apr 15, 2007 12:35 am 
 

Everthing I have is logged into a spreadsheet.  I also give everything a SKU number and place it in a numbered box that goes on a shelf.  The box number the item is in is logged into the spreadsheet so I can find anything rather quickly.  I had to do this because once my collection filled several boxes I would forget which box something was in.  The system works quite well.

 WWW  
PreviousNext
Post new topic Reply to topic Page 4 of 51, 2, 3, 4, 5