Keep in mind that Excel is not a relational database software. Relational
databases allow the user to use the so-called Boolean operators ("and",
"or," "but not," etc.) to prepare reports that can be very useful in the
management of a collection. This becomes more relevant as the collections
grow bigger.
For instance, if the user wants to know how many volutids from Australia are
in the collection, or what percentage of the collection was actually
collected before a given year, a relational database would allow for those
searches (queries in database lingo), whereas a spreadsheet-type software
like Excel wouldn't.
Cheers,
José
________________________________________________________
José H. Leal, Ph.D., Director and Curator
The Bailey-Matthews Shell Museum
Editor, The Nautilus
www.shellmuseum.org <http://www.shellmuseum.org/>
3075 Sanibel-Captiva Road
Sanibel, FL 33957 USA
(239)395-2233
fax (239)395-6706
P Please consider the environment before printing this e-mail
From: Conchologists List [mailto:[log in to unmask]] On Behalf Of
marlo krisberg
Sent: Wednesday, April 21, 2010 1:07 PM
To: [log in to unmask]
Subject: Re: [CONCH-L] data base recommendations
Here's another discussion on the subject:
http://z14.invisionfree.com/Conchologist_Forum/index.php?showtopic=23
From: Dr James Emmett <[log in to unmask]>
To: [log in to unmask]
Sent: Wed, April 21, 2010 1:07:04 AM
Subject: Re: [CONCH-L] data base recommendations
I am about to restart the almost impossible task of cataloging my collection
in a form that doesn't involve little scraps of paper, cardboard, the backs
of receipts, and other lame excuses for a data base. I could use some help
with a standard format and minimum body of information needed to formalize
my pretty but disorganized beach gleanings of the past umpteen years.
Ideally a search and sort mechanism would be helpful as well as a digital
photo of the prize . I am sure you have discussed this ad nauseum. If the
answer to my query lies in the archives of CONCH L a hint as to where i
should look would be much appreciated.
I can be reached off list at Jewrh@ comcast.net <http://comcast.net/>
thanks for your patience
Jim
----------------------------------------------------------------------
[log in to unmask] - a forum for informal discussions on molluscs
To leave this list, click on the following web link:
http://listserv.uga.edu/cgi-bin/wa?SUBED1=conch-l&A=1
Type your email address and name in the appropriate box and
click leave the list.
----------------------------------------------------------------------
|
