MS Access question

Chartman of the Bored

Board Regular
Joined
Apr 24, 2002
Messages
83
This is probably a dumb question, and yes I know this is an Excel forum, but why would someone need to learn to use MS Access if they were already proficient in Excel (besides the fact that Excel is limited to 64000 rows or something)? In other words, what can Access do (or do better) that Excel can't?

And can anyone recommend a comprehensive intro book to Access? I've seen a few popular ones (Mastering Access, Using Access, and the Access Bible), but don't know which to get.

Thanks
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Access is great for databases, and creating reports.

Excel has the ability to be more proficient in calculations and formulas than what access is limited to.
 
Upvote 0
If you get into many records then Access is much faster at retrieving info. You can also use SQL with Access. With VB or VBA you can actually use SQL with Excel as well. I'm learning both. Excel seems to have some decent built in database workings...
Use Access to store your data and Excel to play with it.
Tom
 
Upvote 0
No. Not really any up to date recommendations.
I'm using a book by Que publishing for Access 97. I don't have the book in fromt of me at the moment.
It's been good enough for me so far.
Tom
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

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
Back
Top