Ready to jump back into Access - book recommendation?

[ghh3rd]

Ready to jump back into Access -- left off at Access 2000, and was very fluid with it. Now everyone seems to be using Access 2010. Any recommendations for a good/great book that covers 2010?

Thanks - Randy

[DavidT]

I've always liked the WROX Access books. Access 2010 Programmer's Reference.

[ghh3rd]

I've always liked the WROX Access books. Access 2010 Programmer's Reference.

Thanks for the reply -- 2007/2010 seems so much different -- I need a good way to get up to speed in learning how to move around it the new versions. I can still get around in 2000 with my eyes closed -- these 'new fangled' versions are enough to drive me nuts! :-)

[Dal Jeanis]

Yes, there are a lot of changes that make it feel and act very different. Try the free tutorials over at FunctionX http://www.functionx.com/access/

[ItsMe]

Maybe simply reading a beginner book will introduce you to some of the interfaces. It is what I do with new versions of software. I won't bother with the exercises, but not necessarily gloss over it either. Access step by step is rather basic. Then you can use the other books more as a reference.

http://www.amazon.com/Microsoft-Acce.../dp/0735626928

[DavidT]

no problem. here are some things that took me a while to figure out. I skipped 2007 from 2003 and understand your pain.

• just accept that the database container is now a sidebar.
• go to File> Options> Current Database and displays the navigation bar and set the option for the search field (really nice feature)
• don't mess with pivotcharts (deprecated in 2013) and stick with MSGraph objects
• don't convert your MDB, create a new ACCDB and import objects. Make sure when importing forms and reports to NOT include custom menus and toolbars (not really supported).
• if you are going to create your own ribbon/popup menus, this is a great resource http://www.accessribbon.de/en/
• the default right click menus do not show up in the ACCDR format (run time version of the file) so you may have to create custom ones.
• access security no longer exists (yay!?!)
• understand trusted locations (to avoid security messages)
• there is a trick to moving columns on datasheets and having them stick http://www.access-programmers.co.uk/...d.php?t=231625

good luck!
DavidT

[ghh3rd]

no problem. here are some things that took me a while to figure out. I skipped 2007 from 2003 and understand your pain.

• just accept that the database container is now a sidebar.
• go to File> Options> Current Database and displays the navigation bar and set the option for the search field (really nice feature)
• don't mess with pivotcharts (deprecated in 2013) and stick with MSGraph objects
• don't convert your MDB, create a new ACCDB and import objects. Make sure when importing forms and reports to NOT include custom menus and toolbars (not really supported).
• if you are going to create your own ribbon/popup menus, this is a great resource http://www.accessribbon.de/en/
• the default right click menus do not show up in the ACCDR format (run time version of the file) so you may have to create custom ones.
• access security no longer exists (yay!?!)
• understand trusted locations (to avoid security messages)
• there is a trick to moving columns on datasheets and having them stick http://www.access-programmers.co.uk/...d.php?t=231625

good luck!
DavidT

__________________________________________________ __________________________________________________ ____

Wow, lots of good information from everyone - thanks!