Re: Access or Excel?
- From: "WhiteRat" <whiterat85@xxxxxxxxxxx>
- Date: Tue, 8 Dec 2009 07:48:22 -0600
Thank you all for your input. These are the sorts of considerations I was
hoping to have pointed out, and they will help us in our decision-making
process.
"WhiteRat" <whiterat85@xxxxxxxxxxx> wrote in message
news:%23NhsQM1dKHA.2460@xxxxxxxxxxxxxxxxxxxxxxx
Hi All,
I've meddled with spreadsheets and databases for years, but mostly just
for fun and curiosity. I now have a fairly large project at work, and I'm
looking for advice regarding whether Access or Excel would be my best
option.
For starters, most of us at work, myself included, have Office 2007
installed, and have XP SP3. There are a few here still running 2003, so
most of the work we do is in "compatibility mode". The nature of the work
that we do is to collect biologic data (blood chemistries, hematology,
body weights, food intake etc.) over periods of time ranging from days to
months. What we want to be able to do with the data we collect is to show
results in various configurations. We might want to show all of the serum
glucose values for a particular subject, or group means for subjects over
a period of time. Or we might want to show food intake, body weight and
serum glucose levels for individual subjects or groups of subjects over
time, listed sequentially, or by gender, by age, or other sorts of
parameters. We also would like to be able to produce graphs for
presentation of this data.
We currently enter our data into Excel, and pretty much just configure the
spreadsheet to capture all of our raw data as it comes in. But currently,
our summary tables etc. are quite simple, mostly just showing summaries
for groups of subjects for particular parameters and at an individual time
point. We want to be able to do much more with our data, particularly for
reporting. At this time I'm just asking for some more expert advice with
respect to whether we should be expanding what we already do with Excel,
or would we be better off starting up a database in Access. I know that
there is a large amount of overlap, and that we could probably use either
one to do the job, but I'm looking for relative strengths and weaknesses
for either choice.
Also, we have some smart folks here, none that I'm aware of that have a
lot of database experience, but a few who are quite proficient with Excel.
I'm sure if there were a strong reason to move to a full fledged database
at this time however, that we'd have a plenty who would be interested in
getting up to speed with Access.
Thanks for reading all this, and thanks in advance for any opinions/advice
David
.
- References:
- Access or Excel?
- From: WhiteRat
- Access or Excel?
- Prev by Date: Form Viewing Problem
- Next by Date: RE: Sending email to multiple recipients
- Previous by thread: Re: Access or Excel?
- Next by thread: Sending email to multiple recipients
- Index(es):
Relevant Pages
|
