MS Access question

Chartman of the Bored · May 12th, 2002, 07:36 PM

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

Qroozn · May 12th, 2002, 07:41 PM

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.

Tom Schreiner · May 12th, 2002, 08:30 PM

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

Chartman of the Bored · May 12th, 2002, 11:27 PM

Sounds good. Thanks.

Anyone got any book recommendations/preferences for Access?

Tom Schreiner · May 12th, 2002, 11:44 PM

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

May 12th, 2002, 07:41 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	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. __________________ Colin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 12th, 2002, 07:36 PM	#1
Chartman of the Bored Board Regular Join Date: Apr 2002 Location: Palo Alto, CA Posts: 75	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

May 12th, 2002, 08:30 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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

May 12th, 2002, 11:27 PM	#4
Chartman of the Bored Board Regular Join Date: Apr 2002 Location: Palo Alto, CA Posts: 75	Sounds good. Thanks. Anyone got any book recommendations/preferences for Access?

May 12th, 2002, 11:44 PM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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