Ed's Gemlite - Ed’s Db v3


Ed’s Db v3 A Cataloguing and Reference Database for Mineral, Rock and Gemstone Collectors, Curators and Professionals in the Earth Sciences Enquiry & Purchase Form Conditions of Licensing		Back to Ed's Gemlite Software
	Reference and Collection databases This program was started as a catalogue for my personal use ("e-SL Db”) but has grown into a tool that I think is useful to other Collectors, Curators and people interested in the Earth Sciences. It contains 6 Main Reference databases and in excess of 27 Minor-databases. The Main databases are:- e-ML for Mineral Data e-GL for Gemstone Data e-RL for Rock Data e-LL for Locality Data e-EL for Elements Data e-GpL for Group Data e-SL for Specimen Data The data in these is then accessed to help with cataloguing of specimens through the use of pull down tables, and the data is stored in the ‘Specimen Listing e-SL Db’. External access to all data in e-SL and other Databases for Publications and Localities is available, via Excel spreadsheets, in the ‘Table of Specimens’ folder. Full access to all fields in all Dbs is available through the various forms accessed via the Menu buttons. Therefore if updated or extra data becomes available, this can be entered into the appropriate Db fields. To access the main Dbs or to retrieve data again, use the Menu buttons. Data can be searched for in multiple ways. For example, search can be by name, element or multiple elements, as well as other criteria. Data is viewable and printable in both Landscape and Portrait views. The Mineral database e-ML© is a collection of scientific and general descriptions, for in excess of 4500 minerals, each with up to 99 individual fields, these can be searched in either single or multiple ways, including the use of ‘wild-cards’. Fields Include:- Species name, group, varieties, habit, occurrence, locality, formula, colour, streak, lustre, refractive index, density, hardness, fracture, tenacity, cleavage, twinning, crystal system, Dana, Strunz, JCPDS, IMA, Hays and publication references, etc. etc. (note. not all fields will have data in them as it is not available). The Gemstone database e-GL© is a collection of scientific and general descriptions, for in excess of 800 gemstones, each with extensive individual fields, these can be searched in either single or multiple ways, including the use of ‘wild cards’. The Rock database e-RL© is a collection of scientific and general descriptions, for in excess of 390 rocks, each with extensive individual fields, these can be searched in either single or multiple ways. Including the use of ‘wild cards’. The Elements database e-EL© is a collection of scientific and general descriptions, for the elements, each with extensive individual fields, these can be searched in either single or multiple ways, including the use of ‘wild cards’. The Publication database e-PL© is a collection of information on major earth science publications, these can be searched in either single or multiple ways, including the use of ‘wild cards’. (This can also be used as an address book). The Collection database e-SL© is the collection cataloguing program using the above reference databases. With this program you catalogue your collection, using pull down menus for inserting mineral, gemstone, rock and location data. Once catalogued these can be searched in either single or multiple ways, including the use of ‘wild cards’. The collection data is fully open and is located in an Excel™ spread sheet. Navigation Navigation through the program is by the use of the ‘mouse’ to activate menu buttons, which open various forms into which you type your requirements to either enter new or modified data or to open reports. Searching The databases are all searchable, eg. by name, chemical element, locality, etc, etc. in either single or multiple ways, including the use of ‘wild cards’, utilising the built in forms.with up to 36 positive and 2 negative criterion. Updating of databases All the fields in all the databases are able to be updated as more recent or new data becomes available. This is done with the built in forms. Printing of data All references and collection information can be printed using the built in forms in both landscape and portrait. Printing of Labels Labels are able to be formatted automatically from collection or reference data using the pull down lists. Edited and printed in individual or in sheet lots. there are 6 preformatted sizes to suit a variety of needs. Tables, Forms and Reports There are 36 tables, 61 forms and 36 reports included in this program. Pictures, Inserting and Viewing Insertion of digital pictures is by placing their file in the respective folder, Viewing of Photographs (digital) is by automated links to your installed viewer. Included with this Db are 1400+ Digital pictures of 200+ species. Installation The program automatically installs from the CD. Any difficulties should be reported to support@gemlite.com.au Required software to support Ed's Db v3 Microsoft Access™ 97/2000/XP (or higher) Microsoft Excel™ 97/2000/XP (or higher) Microsoft Internet Explorer™ 5.01 (or higher) Microsoft Windows™ 98SE/NT4/2000/XP Registration The program once installed must be registered. It will only work for 28 days in trial mode unless registered. A trial CD-ROM or product registration can be organised through the Enquiry & Purchase Form. Conditions of Licensing Refer to Ed’s Db v3 - Conditions of Licensing

Contact Us: info@gemlite.com.au