Militaria Database - MISC MILITARIA - U.S. Militaria Forum | BurgerSlot Guide

I guess I will post this under "misc", but does anyone have a suggestion on a database for cataloging all of your militaria?

I have seen plenty of coin and stamp collection databases, but nothing that really suits our militaria collections here on the site. :dunno:

I have worked around MS Office Access, but what a pain to create all new fields and reports, etc..... (yes I guess I am being lazy :pinch: )

Anyways was wondering if you guys (and Gals) had any ideas.....

r - Gy Dan

http://www.usmilitariaforum.com/forums/ind...c=27361&hl=

s/f Darrell

THANKS Darrel! Man I love this place! Looks like a great tool!

s/f - Gy Dan

THANKS Darrel! Man I love this place! Looks like a great tool!

s/f - Gy Dan

Dan, keep in mind, it does not work with older versions...

older versions of MS Office ?

I have 2003 and 2007.

And a Mac.......with MS Office for Mac as well as their full suite of Office tools.

Thanks again !

Semper Fi Mac!

r-Dan

I simply use Excel. My simple database has been in constant use since I created it in Microsoft Works over 15 years ago. The columns are, the patch, condition, cost, and notes. Excel can average the cost per patch for me, an important consideration for this frugal collector (now at .97 each )

-Ski

I use excel also. I think its good to have a print out, and with excel you can print out specific pages, etc. I made up my data base for anything of value, tabs seporate books, coins, family items, military items, etc. My wife and I discussed making sure that our kids knew what belonged to who in our family history, and most importantly that the didn't give away or yard sale things that have family history with out knowing about it, or give it away for a song if they dont want to keep it. With excel you can add pictures, resize cells, etc. Its a great tool.

Jon B.

I built mine in access, so it wouldn't look so much like a spreadsheet and more like a program. I knew my girls would be more apt to use it, by how it looked. I designed it so it will hold multiple photos, you can catagorize items by country and if the item belongs to a Veteran that you have put in the database, it will link them. You can also input the value, what you paid, where and when you got it. It will also show you pie charts, sorted by items, origins and veterans.

I think that it doesn't matter what we use, just that we use it so others will know what and why we collect and not let the history of our things slip away. :thumbsup:

you'll never find a better reference tool for US Militaria than this place, Gunny

Well I got what I was looking for. Lots of ideas to try. thanks guys! I had one built in excel for my model collection, but that was straight numbers and categories.

I wanted one with pictures and a little more detailed, but I like what some of you have posted. I might try both. MS Access, and MS Excel.

and, yes this is a great place for reference and knowledge. I was just looking to see what other members used as tools to catalog their collections.

Thanks again folks!

s/f - Gy Dan

I have been using MS Excel for years now and have developed it into data log referencing costs and values that are linked directly to another spreadsheet with categories. Anytime I do and update or add items I open the data log spreadsheet and it automatically updates values. Fields or cells can be linked to photographs on the computer as well...I actually set-up a large number of MS Powerpoint presentations on specific items in a category and they linked to the item number, or inventory number.

A hint here is to assign an item number relating to category(uniforms, equipment insignia etc.) and tag each item with its item number. Then to keep a running total of items in the collection, set-up an inventory number sheet and assign each item number an inventory number in sequence from 1 to whatever.

The singular problem with keeping a running total of costs and values is the shock factor when you add everything up...good idea not to show the spouse.

Cheers