Basic Microsoft Access Video Game Sales Database

Jobber8742Jobber8742
in Help Wanted!
I'm looking for a good template to create a very basic video game sales database to track all my game purchases and sales. Basically, I want to be able to track what comes in, quantity, and price paid. Then I want to be able to compare price sold to price paid and deduct the quantity sold. I'm having a really hard time finding a simple template that would do this. I, unfortunately, have very little to no knowledge of how to create my own Access database, so I'm kind of at a loss. Anyone have a nice little template, or some pointers on how to start to create my own?

Comments

  • smeagolsamasmeagolsama
    Was doing a pretty good job of this in excel until you goofballs came down and we went to St Louis and I bought a bunch of stuff. Then North Carolina came, then MGC, then a KC trip. Its all over now so good luck with this.
  • NintendoAge ModeratorNintendoAge Moderator
    I don't have a lot of DB experience, but I guess the main issue would be your primary key. What if you buy 5 copies of Earthbound. They have unique buy/sell prices for each. Would you use a key like "earthbound-1", a random number, etc? I'm not a huge fan of access, but with all databases, you want to create your ideal schema and relationships on paper or in an ER diagram before you actually build the databases. Once you've fully planned out your tables and relationships, regardless of the software it should be a fairly simple thing to build and then you can populate it.
  • Jobber8742Jobber8742

    Originally posted by: smeagolsama



    Was doing a pretty good job of this in excel until you goofballs came down and we went to St Louis and I bought a bunch of stuff. Then North Carolina came, then MGC, then a KC trip. Its all over now so good luck with this.



    I've always used Excel to track my purchases, it works well enough for that. I think I'm going to run into problems with tracking selling though, especially selling in volume.




    Originally posted by: jonnylentilbean



    I don't have a lot of DB experience, but I guess the main issue would be your primary key. What if you buy 5 copies of Earthbound. They have unique buy/sell prices for each. Would you use a key like "earthbound-1", a random number, etc? I'm not a huge fan of access, but with all databases, you want to create your ideal schema and relationships on paper or in an ER diagram before you actually build the databases. Once you've fully planned out your tables and relationships, regardless of the software it should be a fairly simple thing to build and then you can populate it.



    I would think that there is some sort of First In First Out function by querying dates purchased to determine which price to pull for the items, but I do not know for sure. That's a good idea of mapping out what I want on paper, I think I'll work on that. I really would think there would be some sort of template out there that would do what I want, it's pretty basic stuff, but I was really suprised by the lack of templates on the web. Unless I'm looking in the wrong places.
Sign In or Register to comment.