Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Ancient Coins
>
Ancients- Do you digitally catalog your collection?
>
Reply to Thread
Message:
<p>[QUOTE="Broucheion, post: 3881156, member: 104887"]Hi All,</p><p><br /></p><p>Sorry, this may be a bit too long for some. </p><p><br /></p><p>I'm no expert at the programming end of things. I started over 20 years ago with freeware that very soon became obsolete (but before that point it started to strain with what I needed it to do). I next went to spread sheets, which were fine, really, but photos were tricky to handle (but it can be done). About 20 years ago I settled on MS Access because I also used it at work. I set up my various coin databases then, when it was all new, fresh (and easier to assimilate). Since I collect several very specific areas I wanted a separate database for each. I've only tweaked things since then, betraying my laziness and inability to keep up with all the bells and whistles added to the program.</p><p><br /></p><p>I first needed to set up the fields describing the coin, its seller, and various notes and comments. My database has about 50 (yes, overkill) fields. Some of that large structure is shown below.</p><p><br /></p><p>[ATTACH=full]1025187[/ATTACH]</p><p><br /></p><p>Next, I needed a template to add the info into the database. Here is what I use.</p><p><br /></p><p>Design view & user's view.</p><p><br /></p><p>[ATTACH=full]1025188[/ATTACH] [ATTACH=full]1025190[/ATTACH]</p><p><br /></p><p><br /></p><p>All my various 'reports' (database outputs) were set up as 'full info' or with no price shown ('priceless') format so I can trade data to the extent I see fit. I have three main types of outputs:</p><p><br /></p><p>1. flips, </p><p>2. label view (using an MS label template I created a condensed view of multiple coins. This as a printout is useful. It’s small enough to carry around to coin shows.</p><p>3. A single page per coin output view. One day I'll print that out and bind it. Now it's a rather large PDF, but it is very easy to word search and view on my iPad. I sometimes take screenshots from these for my list posts. Here are some sample views.</p><p><br /></p><p>Flips (I cut & fold as needed and insert into plastic flips)</p><p>[ATTACH=full]1025189[/ATTACH]</p><p><br /></p><p>Label view</p><p>[ATTACH=full]1025191[/ATTACH]</p><p><br /></p><p><br /></p><p>Output View</p><p>[ATTACH=full]1025192[/ATTACH]</p><p><br /></p><p>Again, sorry for the long post but I felt it might be instructive for the newcomers to cataloging. What you see is the result of many years of fine tuning so newbies should not be intimidated. You'll get there (and past there), I'm sure.</p><p><br /></p><p>- Broucheion[/QUOTE]</p><p><br /></p>
[QUOTE="Broucheion, post: 3881156, member: 104887"]Hi All, Sorry, this may be a bit too long for some. I'm no expert at the programming end of things. I started over 20 years ago with freeware that very soon became obsolete (but before that point it started to strain with what I needed it to do). I next went to spread sheets, which were fine, really, but photos were tricky to handle (but it can be done). About 20 years ago I settled on MS Access because I also used it at work. I set up my various coin databases then, when it was all new, fresh (and easier to assimilate). Since I collect several very specific areas I wanted a separate database for each. I've only tweaked things since then, betraying my laziness and inability to keep up with all the bells and whistles added to the program. I first needed to set up the fields describing the coin, its seller, and various notes and comments. My database has about 50 (yes, overkill) fields. Some of that large structure is shown below. [ATTACH=full]1025187[/ATTACH] Next, I needed a template to add the info into the database. Here is what I use. Design view & user's view. [ATTACH=full]1025188[/ATTACH] [ATTACH=full]1025190[/ATTACH] All my various 'reports' (database outputs) were set up as 'full info' or with no price shown ('priceless') format so I can trade data to the extent I see fit. I have three main types of outputs: 1. flips, 2. label view (using an MS label template I created a condensed view of multiple coins. This as a printout is useful. It’s small enough to carry around to coin shows. 3. A single page per coin output view. One day I'll print that out and bind it. Now it's a rather large PDF, but it is very easy to word search and view on my iPad. I sometimes take screenshots from these for my list posts. Here are some sample views. Flips (I cut & fold as needed and insert into plastic flips) [ATTACH=full]1025189[/ATTACH] Label view [ATTACH=full]1025191[/ATTACH] Output View [ATTACH=full]1025192[/ATTACH] Again, sorry for the long post but I felt it might be instructive for the newcomers to cataloging. What you see is the result of many years of fine tuning so newbies should not be intimidated. You'll get there (and past there), I'm sure. - Broucheion[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Ancient Coins
>
Ancients- Do you digitally catalog your collection?
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...