Access Database

Millertime · February 1, 2005 1:01PM

Does anyone have any comments or suggestions about this Acces form I created for my inventory?

Thanks,
Millertime

kenoshapete · February 1, 2005 1:09PM

Looks nice.

Yousri · February 1, 2005 1:15PM

Looks nice, but it is too samll to get the fields details.

XpipedreamR · February 1, 2005 1:18PM

How about a section for a brief description of the coin, or other comments?

Millertime · February 1, 2005 1:21PM

If someone's willing to post the large jpg I have (110 kb) let me know. I had to resize and it's hard to see. There is a comments field below type and variety.

Millertime

jdp2 · February 1, 2005 1:24PM

I use Coin Organizer Deluxe. It's cheap. Oh, duh you are probably trying to create your own.

Millertime · February 1, 2005 1:29PM

<< <i>I use Coin Organizer Deluxe. It's cheap. Oh, duh you are probably trying to create your own. >>

I spent $30 on "My Collection Explorer" and decided it was more of a pain than anything so I decided to create my own with Access. I spent about a week on designing this database.

Longacre · February 2, 2005 6:52AM

Great idea. It's great to store all of the information in one place, especially for tax purposes, if you tend to sell/trade a lot.

Prethen · February 2, 2005 6:54AM

Any place to put the image? By any chance, will there be a special U.S. Coin Forum giveaway of this database app once it's complete?

slabfab · February 2, 2005 8:26AM

Millertime,

That's a great idea. I use Excel spreadsheets for this, but a queryable database would be better.
I can host a larger image for you if you like.

Millertime · February 2, 2005 8:43AM

<< <i>Any place to put the image? By any chance, will there be a special U.S. Coin Forum giveaway of this database app once it's complete?

>>

I haven't tried messing with images yet, I'm still contemplating that part. As soon as I'm done with it I'll probably offer it to anyone that wants it.

Millertime

slabfab · February 2, 2005 8:43AM

Larger Image

Millertime · February 2, 2005 8:44AM

<< <i>Larger Image >>

Thanks Frank.

Millertime

Inditonka · February 2, 2005 12:54PM

Millertime,

One thing you might want to consider is to break out the "RB and PCGS Value" elements and place them into another table. You would lookup the Coin/Mint/Grade and get a hit on the value table. This way you can update your coin value table without having to go into the each coin detail.

CoinOnTheCob · February 2, 2005 1:03PM

I was just thinking the same thing. The way it is now, Which looks easy to use and logical, you would have to do a big “audit” every year to update each coins value.

Millertime · February 2, 2005 1:13PM

CoinOnTheCob & Inditonka,

Good point on the values. I think I'll do as suggested and create a separate value table that RB & PCGS value look at. I still need to learn the filtering but I'll figure it out.

Thanks,
Millertime

Access Database

Comments

Leave a Comment