I have this idea that I’m going to do some organizing around my house, among other things. To that end, I wish to make some kind of record for some of my possessions, such as DVDs/Blu-Rays, CDs, books (paper and electronic, to include old RPG-type books) and video/PC games. I also want to (finally!) get all of my dadblasted logins & passwords (to include security questions & answers, security codes, backup emails, etc.) stored in one easily accessible place (flash drive, not on the computer). All such constructed lists are entirely for my personal use, bless my anal retentive soul, and will not be used for any business purpose that I can currently fathom.
I’m somewhat familiar with constructing spreadsheets (having done several here at home for personal use), but have only used the very simplest of formulas whilst doing so. I use Open Office, if that matters. I’ve only ever fiddled with constructing any kind of database in an introductory course some years ago, which spent only a small portion of time covering the big 4 of the Microsoft Office suite. I do have a spreadsheet book that I can’t seem to put my hands on at the moment, nor apparently do I recall the exact title (something along the lines of ‘How To Be A Spreadsheet (or Excel) Hero,’ with the cartoon figure of a superheroine on the cover–online searches turn up nothing, but I believe the book is around 10 years old, give or take a couple years), and that book has helped me quite a lot, even if it may be judged to be simplistic. If you’re a spreadsheet fan or a database fan, or both, beginner book suggestions along with your recommendations will be very much appreciated.
I expect some of my categories to be large, numbering in the dozens if not the hundreds (I’ve recently reawakened an interest in Magic: The Gathering–please don’t judge. ). Here’s the elements I want to include, although I don’t rule out adding more to this list as needed: name/identification, creator/company, type of thing, year published where applicable, sequence/order where a series is concerned (such as Butcher’s Dresden Files), possibly whether I own the item or not (where a series is concerned–music albums and movie franchises count here as well as book series), and maybe a couple-other things that aren’t coming to mind at the moment. A high priority for me is ease of updating and reordering–if I have 30 books under the letter ‘P’, I want to be able to insert a new book easily into its ‘proper’ place. (Which reminds me of an old joke where I don’t suffer from OCD, I suffer from the same disease called CDO, with the letters in alphabetical order–as they should be. )
Sorting within spreadsheets seems to me to be a fairly easy process to finish updating a particular list/category, but then I have almost no experience with databases, thus I turn to you all. Considering the lengthiest of a given category would have absolutely no more than 200-300 entries (except for M:TG, which I foresee climbing a bit higher–they don’t call it cardboard crack for nothing), should I stick with (lots of) spreadsheets? Or should I construct a database with everything in it, and call up a list out of that bloc when I want to see (for instance) what albums I have, specifying albums as a category that must be included (thus, of course, eliminating any non-album items for that report)?
Any and all recommendations, suggestions, anecdotes, experiences, and preferences will be most appreciated. I’m really looking to hear from those of you who’ve used both types of program, but of course anyone with anything to tell is welcome to chime in, even if you take the trouble to tell me both types of program are Ebil™ and I should use a real program like MySQL, or just stick to pencil and paper like back in the good ol’ days.
Mods, since I’m soliciting opinions, I thought this would be the appropriate forum. If that just ain’t so, please move as needed. And to all, thanks in advance!