Advantages

  • Thread starter Catherine Duggan
  • Start date
C

Catherine Duggan

Hi
Im currently in my final year of a degree in England and am just wondering
if someone would be able to help with a quick question. What would you say
that the main advantages are of using Excel to produce a spreadsheet as an
analysis tool rather than access??

Any help would be much appreciated
 
J

Jackie L

Excel is a spreadsheet application whereas, Access is a database. When
creating a spreadsheet in Excel, you have the capability of copying fields
and expressions and dragging them down multiple rows. You can compare values
in one line to values in another.

There are many reasons to use a spreadsheet instead of a database but
basically, the two products should not be compared since they have entirely
different purposes.
 
J

John Vinson

On Tue, 5 Apr 2005 03:41:05 -0700, "Catherine Duggan" <Catherine
Hi
Im currently in my final year of a degree in England and am just wondering
if someone would be able to help with a quick question. What would you say
that the main advantages are of using Excel to produce a spreadsheet as an
analysis tool rather than access??
Click to expand...

Very similar to asking what the main advantages of using a spanner to
tighten bolts, rather than using it to drive nails.

Excel is a spreadsheet program. It's designed to produce and work with
spreadsheets, and do spreadsheet analysis. Access is a relational
database program; it's designed to store, query, manage and report
data. They are different tools for different purposes.

Note that you *can* do some very basic database operations in Excel,
and you *can* do some limited spreadsheet-type calculations in Access.
But you can also drive nails with a spanner; that doesn't make it a
hammer!

John W. Vinson[MVP]
 
Top