So, recently at work I've been getting trained on Access. I don't know if this is just my own inner geekiness or what, but this is the best program EVER for organizing my knitting patterns! Seriously, I'm making a database right now that will have all the details I could want (including gague, yardage, what book it's in, and location in my house) so I can search for exactly what I want, or pick a pattern based on what yarn I want to use at the moment.
There is nothing better than this. I can even search with pictures, to see if that's really the one I want!
Since this is all computer-based, I'll be able to give screenshots as soon as I have it all up and running :) I am a universe of joy.