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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
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,136,926
Messages
5,678,605
Members
419,775
Latest member
joh93

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