While Excel is a fantastic spreadsheet application. It is not a database
application. yes, I know it has data sorting and grouping features. it can
even import and/or connect to data from an actual database.
I don't want to step on any toes here, but I have seen way too many excel
spreadsheets treated like databases. just one very basic problem that you
can run into using a spreadsheet this way is the constant retyping of common
data. one typo could cause a vital piece of information to not show up in a
search.
Again, Excel is a fantastic application, I use it often when what I need is
a spreadsheet. But, what kajal is looking for here is definitely a
database, whether is built in Access, Filemaker, SQL Server, or some off the
shelf product that addresses the needs presented (which is possible).
Cheers,
Gary Acord
-----Original Message-----
From: Museum discussion list [mailto:[log in to unmask]]On
Behalf Of Jay Heuman
Sent: Friday, March 01, 2002 1:07 PM
To: [log in to unmask]
Subject: Re: software
Hi Kajal,
I'm a big advocate of MS Excel! Excel is not a traditional
and limited spreadsheet. It is capable of mathematical
function (addition, subtraction, multiplication, division,
averaging, etc.), database functions (searching and sorting
data), and graphing. So, with a bit of work in setting up
charts/graphs (with the necessary formulae), you would be
able to easily track basic information AND calculate and
graph results.
Sincerely,
Jay Heuman, Visitor & Volunteer Services Coordinator
Joslyn Art Museum, 2200 Dodge Street, Omaha, NE, 68102
342-3300 (telephone) 342-2376 (fax) www.joslyn.org
> -----Original Message-----
> From: Museum discussion list
[mailto:[log in to unmask]]
> On Behalf Of Kajal Ghoshroy
> Sent: Friday, March 01, 2002 11:56 am
> To: [log in to unmask]
> Subject: software
>
> We are looking for a software to create a database for
live
> animal general statistics (such as weight, length, DOB
etc.)
> as well to use it for daily maintenance of animal heath.
We
> have tried "MS Access" but did not have mush success. If
> any of you can send me a suggestion, we would appreciate
> your help.
>
> Kajal Ghoshroy
=========================================================
Important Subscriber Information:
The Museum-L FAQ file is located at
http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed
information about the listserv commands by sending a one line e-mail message
to [log in to unmask] . The body of the message should read "help"
(without the quotes).
If you decide to leave Museum-L, please send a one line e-mail message to
[log in to unmask] . The body of the message should read "Signoff
Museum-L" (without the quotes).
=========================================================
Important Subscriber Information:
The Museum-L FAQ file is located at http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed information about the listserv commands by sending a one line e-mail message to [log in to unmask] . The body of the message should read "help" (without the quotes).
If you decide to leave Museum-L, please send a one line e-mail message to [log in to unmask] . The body of the message should read "Signoff Museum-L" (without the quotes).
|
