Access vs. Excel

william2002

New Member
Joined
Sep 19, 2006
Messages
6
I am getting ready to post a database and derive charts from that database. The size of the database is approximately 6.5 mb (quite a large file). The problem is I will need to analyze this database with "grouping." Thus, I would likely have to use a pivot table in excel or use an Access query. I don't know which application would be best b/c I am somewhat familiar with excel but not at all familiar with Access. Can anyone sort out the strengths and weaknesses of each program and possibly suggest the best?

thanks in advance
william
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,351
Office Version
  1. 365
Platform
  1. Windows
William

That's quite a broad subject and there are many advantages/disadvantages to both applications.

In Excel you probably would use a pivot table to summarize data by groups.

In Access you would probably use an aggregrate (Totals) query and/or a crosstab query.

In Access you can create charts, but they don't have the same flexibility/functionality as charts in Excel.

However what you can do is automate one application from the other.

For example you could store the data in Access and then use code in Excel to pull it into a worksheet and create the charts.
 

Forum statistics

Threads
1,171,273
Messages
5,874,763
Members
433,070
Latest member
omartarek

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top