Ok, I am familiar with most of excel and word, but Ive always found ways around using access cause honestly its always scared me a lil... not sure why just is more intimidating to me then excel.
Anyway, I in addition to many things am a comic book collector, everyone needs a hobby, but Im approaching a point that remembering what I have and where is becoming a hassle so I am going to attempt my first real database. I figure I want to set it up so I have the following fields... Publisher,series, storage location, volume, issue#, Condition, if its a varient or not, notes, current value, story arc, and title. I would also like to maintain a history of current values so this years value is stored so next year I can see the change, and the year afte rthat I could see trends etc.
Sadly, as Im really bad in access I figure I need to ask how you would set up the general database... would you do 1 main table with all the data and then just run queires etc or would you set up multiple tables by say publisher or series etc... I also have no idea how to do the value and history of values... Im guessing Ill need to use excel there a little but not positive
any general advice would be appreciated, and in all honesty if this is a bad place to use access let me know, and Ill do it in excel.
Thanks.
Bookmarks