+ Reply to Thread
Results 1 to 4 of 4

Setting up a comic database

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2013
    Posts
    75

    Setting up a comic database

    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.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,757

    Re: Setting up a comic database

    Here are two links that will help you to understand RDBMS and how you should set up your tables.

    Firstly, http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf

    Then after reading that you will want to read this tutorial on the basics of Access. It is a step by step guide.

    http://www.accessmvp.com/strive4peace/

    If you have specific questions as you begin to set up your db then post back.

    You will need multiple tables or you will end up with a flat db and that is not efficient. Be patient. Access has a very steep learning curve. But it will be very rewarding once you achieve success.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-21-2012
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2013
    Posts
    75

    Re: Setting up a comic database

    Thanks for posting those pages! a ton ** info to learn and its information I need to know...

    As for my comic database, heres what Im thinking:

    table 1 for each individual comic, itll contain things like comic name, publisher, issue number, volume number, and ** course will have a comic ID as my primary key..basically thsi will have all the nonchanging info ** a comic.
    table 2 will be for storage location which will link the comic id with a storage location... this could potentially change semi regularly
    table 3 will be for the value ** the comic... Im still not sure how Ill have this set up to include current value as well as previous values that came before the current value....but when I get to that hopefully Ill ** read enough to figure that one out
    table 4... Im not sure on yet I need to add a condition ** each comic, it could potentially change over time if say a comic gets bent or forms a crease etc... Im not sure if this should be in table 1 or have its own table

    But anyway, how does that basic format look? honestly Im starting to think I picked a bad choice in what to use to make my first database... Im starting to wonder if a plain spreadsheet is what I would want for this.... seems to me from what Im reading a better use for a database would be something where I have more then one unique item interacting... like if I was keeping track ** an address book as well as order forms... with comics Im keeping track ** 1 thing.. comics everything else is related to said comics.

    Not sure why (o f) is a bad word but it keeps ** it out so thats what ** is lol
    Last edited by Trachr; 03-08-2014 at 05:59 PM.

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,757

    Re: Setting up a comic database

    Firstly, the ** of the letters "of" has been fixed.
    Secondly, sounds like your tables make sense. Post back as you venture down this road with specific questions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Setting up a Database
    By christipper in forum Excel General
    Replies: 11
    Last Post: 02-25-2013, 10:56 AM
  2. best way of setting up exam database
    By neeny468 in forum Excel General
    Replies: 2
    Last Post: 05-30-2012, 03:46 PM
  3. Replies: 3
    Last Post: 02-14-2012, 02:32 PM
  4. Excel 2007 : change fron from comic sans to wingdings
    By Spike0907 in forum Excel General
    Replies: 3
    Last Post: 02-10-2010, 03:47 PM
  5. Setting up and searching database
    By smraines in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-22-2009, 12:32 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1