Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Ancient Coins
>
Your processes for new coins
>
Reply to Thread
Message:
<p>[QUOTE="robinjojo, post: 8175973, member: 110226"]If I am not mistaken, but Excel can create a column of cells that are autonumbered, so each record would have a unique identifier. As I recall, there is a way to create a form in Excel that can extract specific fields, but I am now far removed from my years developing reports for the county health and hospital system, so I'm quite rusty now.</p><p><br /></p><p>When I was working, I was much more involved with Access, which allows the creation of a key field, and then a one-to-one relationships or a one-to-many relationship. Then, forms can be created with queries to refine the data and create reports. They can also be used as search engines for specific needs. I never got as far as linking records to photos, which would be nice, but not absolutely necessary.</p><p><br /></p><p>Yes, I have so many coins, it will take ages to enter information into even a simple, basic database. Maybe it is time to whittle down the number of coins.[/QUOTE]</p><p><br /></p>
[QUOTE="robinjojo, post: 8175973, member: 110226"]If I am not mistaken, but Excel can create a column of cells that are autonumbered, so each record would have a unique identifier. As I recall, there is a way to create a form in Excel that can extract specific fields, but I am now far removed from my years developing reports for the county health and hospital system, so I'm quite rusty now. When I was working, I was much more involved with Access, which allows the creation of a key field, and then a one-to-one relationships or a one-to-many relationship. Then, forms can be created with queries to refine the data and create reports. They can also be used as search engines for specific needs. I never got as far as linking records to photos, which would be nice, but not absolutely necessary. Yes, I have so many coins, it will take ages to enter information into even a simple, basic database. Maybe it is time to whittle down the number of coins.[/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
>
Your processes for new coins
>
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...