Access vs Excel

  • Thread starter Thread starter Elle
  • Start date Start date
E

Elle

I have monthly data regarding the number of house sales,
prices and location of sales in a particular area. I need
to create three monthly reports, one dealing in land
sales, one in city dwellings and one in rural units. Each
record has a code to identify it in this respect.

Each report then needs to be broken down under different
regions within the state.

Then, broken down monthly, we need to use house price
data, and number of sales to create averages, running
totals for the period to date, median prices and also a
count of how many sales fall within four price brackets.

My basic problem is that I'm not sure that Access has the
ability to perform so many calculations. I would normally
do this in Excel, but the data is downloaded from an
external source and I'd guess I'd need to reapply the
formulae each time I downloaded a fresh sheet. I thought
it might be easier to import them into Access then run
specific queries on them each time.

I hope this makes some kind of sense.
 
Access would have no problem handling what you describe. You are quite right
that it would be simpler to do in Access. Anytime you need to see the same
data in several different ways (groupings, filters, report orientation), it
is likely that Access will be a better solution than Excel.

Allan Thompson
APT Associates/ FieldScope LLC
MS Office Automation ~ Reporting Systems
www.fieldscope.com http://www.fieldscope.com
 
Back
Top