Register to attend our live meetings.
Started by cmerc, February 27, 2013, 02:23:49 AM
0 Members and 1 Guest are viewing this topic.
Quote from: Figleaf on March 09, 2013, 10:45:03 AMA data base has no sub-headings. They are just another column.
QuoteA data base separates data into columns as much as possible. For instance date would be columns first date of type, last date of type, AH date of coin, regnal year, AD date of coin, control field. Catalogue id would be minimum two columns (four if you use KM): catalog id, catalog number. In the case of KM you also need leading letter and trailing letter[/li][/list] etc.
QuoteThis way you can sort and re-sort the data base and still get back to the original order. I would use the date control field for a check on the formula AH date pus regnal year [converted] = AD date to catch anomalies. With conditional formatting, you can catch spelling mistakes in the catalogue id field. You keep the letters in KM catalogue numbers apart to be able to sort the data base by catalogue number. If not, the alpha-numerics will be bunched together when sorting. I general, separate numerics and alpha-numerics
QuoteAnother useful data base field is the date (year) of last review. Catalogue numbers change, you forget to make entries etc, so regular review is necessary.
QuoteOnce you have a clean data base, you can define output forms without the data ballast and with a nice lay-out according to your needs.Detail: if you have a column for price and date, one for seller would be logical.
Quote from: cmerc on March 09, 2013, 05:09:56 PMSo would we want to keep the subheadings feature? It may help if you want to subdivide your collection in some situations.
Quote from: Figleaf on March 09, 2013, 06:33:37 PMSub-headers in the data base will prevent easy sorting. Excel doesn't support style sheets. I can think of solutions with page headers, but it wouldn't be very effective. You can generate sub-headings when printing by using a macro. That will take some programming. The easy solution is to use autofilters and print each subheading separately.
Quote from: cmerc on February 27, 2013, 02:23:49 AMHello All, Are there good (online) collection management tools available for personal collections? I know of some tools on numismaster, and the registry on NGC. But is there a good generalized software / online tool for managing your collection, that allow pictures, details, sorting, etc.? If not, and if such a tool were to be developed, would there be interest among the community? I have spent some time developing a preliminary web-based system for my own collection. It is possible to add some extra features, have a graphical interface, and make it simpler and more useful. For example, the following page (and other pages on my website) is generated automatically from my database: http://www.asarkar.com/coins/DisplayCoinPage.php?pageID=BENGAL and it is very simple to add new coins into the database. (It can be made even simpler!)Would you be interested in using such a system? Or does something like this already exist? Thanks!-cmerc
Quote from: apvkt on March 12, 2013, 11:26:18 AMHi,The above link is very helpful in collecting various models of coins..Like this, share some more links for the collection which is very useful..
Quote from: Figleaf on March 09, 2013, 10:45:03 AMLooks nice as an output form, but has major drawbacks as a data base...