Access Books recomendations?

[FinancialAnalystKid]

Finally, after years and years of putting my education off on Access and its many uses, I have come to terms and decided that to improve myself as a Financial Analyst, I need to use Access to improve my efficiency.

I just read "How to do Everything with Access 2003" but it wasn't very good. I am previewing "Data Analysis with Access" right now and it seems like there is a ton of good information there.

Is there something better? Something that will get me from a beginner Access who can poke around Access and create tables and VERY simple queries in order to transfer that data to Excel? I'd like to someday soon - yeah - I can do that with Access instead of just using Excel for my analysis and data reporting.

Fortunately I don't run into large data sets but lately, I have been. So this is a big issue going forward.

 

[Richard Schollar]

The absolute best Access book I have come across is this:

http://www.amazon.co.uk/Desktop-Dev...=sr_1_8?ie=UTF8&s=books&qid=1241813141&sr=1-8

Buy it with the Enterprise version too. Handles very advanced topics (as well as relative basics). Deals with Access 2002 but most of this is applicable to Access 2007 too.

 

[SydneyGeek]

The Developer's Handbook series is top of the tree, for sure.
I have bought Microsoft Access Data Analysis and it's good. Also check out the Access Cookbook (2nd ed) by Getz, Litwin and Barron. Plenty of useful hints and tips.
And if you are using 2007, I recently bought Pro Access 2007 by Martin WP Reid. Especially useful if you intend to work with SQL Server at some stage.

Denis

 

[swayp11]

The absolute best Access book I have come across is this:

http://www.amazon.co.uk/Desktop-Dev...=sr_1_8?ie=UTF8&s=books&qid=1241813141&sr=1-8

Buy it with the Enterprise version too. Handles very advanced topics (as well as relative basics). Deals with Access 2002 but most of this is applicable to Access 2007 too.

I checked out the descriptions of the books, but in your own words what is the difference between the Enterprise and regular version?

Should I start with one? If not, Why together?

Thanks!

 

[SydneyGeek]

Regular is for desktop. Enterprise covers client/server (and therefore most of the ADO / SQL Server stuff). Both are good -- I ended up with 2000 Desktop and 2002 Enterprise.

Denis

 

[JP2112]

I'm enjoying Access 2003 VBA Programmer's Reference from WROX. Covers all the essentials, with lots of sample code.