Database Project - Coin Community Forum

To participate in the forum you must log in or register.

Author	Replies: 6 / Views: 2,427
timsumrall Pillar of the Community United States 1256 Posts	Posted 05/22/2011 11:02 am I've been "slowly" working through a coin database project and I'm having second thoughts about structure. I think I need to go one more level deep, "Type". Here's what I have how describing each coin as they are entered. It's fast as the date increments while adding and I can add to the code tables on the fly auto-filling the new item for me. The Code Tables The Normalized Coin Table My thoughts are to change this and build a "type" table as the primary with the following Country Denomination Face Amount Obverse Reverse Strike (biz, proof, satin) Composition (specific percents of metal) Questions: In your opinion would this spec a type completely in most cases of modern coinage? How would it match to a 7070? How would commemoratives fit? Would I need a switch for that? Once this table is complete for a one coin type the second level is year/mint/mintages. This function would be like the first picture except I would simply pick a type then enter a date/mint then auto-run the set. Mintages would have to be hand entered. The last function is where any user add/edits/deletes their stash. Any thoughts/ideas on primary structure would be welcome. Report this Post to the Staff

MrCanada Pillar of the Community Canada 650 Posts	Posted 07/03/2011 12:38 am Nice screen shots, may be your transaction area but do you have purchase, current value,and sale price as part. Grade, vaietys, details, lots of variables to deal with.I played with writing one myself but got lazy and bought Liberty street Coin Manage and find it pretty compehensive.Check it out if you have'nt, might give you some ideas. Report this Post to the Staff
Landude Valued Member United States 223 Posts	Posted 07/03/2011 10:39 pm Same here, I was going to do one in access till I found Coin Manager. It does more then I'll ever need. I actually had downloaded it for ideas for my access front end. Then I just bought it.. Report this Post to the Staff
flotsam Valued Member United States 115 Posts	Posted 07/05/2011 1:09 pm i think that's what a lot of people do, they get started with something but then see that it is a lot of work and then,... my thought is that it would be great if all this information was hosted so it was portable so that you could access it with something like a smartphone. I would really like all that info to come with me when I go to a coin show or a dealer etc. that would make it unique as the phone apps (do they have one for android?) are not so good yet. i guess the fundamental question is will it just have your primary collection or will it include all the dupes as well? that would be good for traders I suppose. Report this Post to the Staff
coinmap Valued Member United States 266 Posts	Posted 08/02/2011 2:09 pm That is a nice database. When I did mine, I put in a place for a picture of the actual coin. I have a little more space on my page, because it is a little more basic. I do't deal with coins from other countries, and I just deal with one coin per slot. Meaning, I wouldn't have the line in about the coins for trade. Everybody has their own idea of what they want for their own database. That is one reason that I created my own, as opposed to going with an online database. Report this Post to the Staff
The_Duke Pillar of the Community United States 1745 Posts	Posted 08/02/2011 4:34 pm I do have type (Lincoln Wheat, Lincoln Memorial, etc.) in my database. I pretty much use them as defined by the Red Book. I could send you a copy of my Access database, if needed. Edited by The_Duke 08/02/2011 4:40 pm Report this Post to the Staff
LowCostSilver New Member United States 2 Posts	Posted 08/13/2011 4:05 pm I love the look of your database and would love to get a copy of the template to customize. Would that be possible? I am still debating whether to use Excel (which I know) and biting the bullet and using Access (which I do not know). Any recommendations? Report this Post to the Staff
	Replies: 6 / Views: 2,427

To participate in the forum you must log in or register.

All Forums Category: General Numismatic Forums Forum: Supplies, Books, Reference, Software, etc

The First Dollar, your premier source for bullion and rare coins. See our bullion list on the site and the coin inventory on ebay.

Silver Gold Bull US is the United States leading bullion dealer. We deliver gold coins, gold bars, silver coins, silver bars and precious metals to your door. Order today!

View Last 100 New Topics

View Last 100 Active Topics

Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Coin Community assumes no liability for errors. Copyright 2005 - 2026 Coin Community Family- all rights reserved worldwide. Use of any images or content on this website without prior written permission of Coin Community or the original lender is strictly prohibited.
Contact Us | Advertise Here | Privacy Policy / Terms of Use

Coin Community Forum

It took 0.28 seconds to rattle this change.