Microsoft Access 2010 VBA Programming Inside Out 1st Edition

Bought this used (arrived in great shape) because it has some advanced concepts that is hard to find in a single product and I was wanting to get into OOP more. This is NOT a beginner's programming book - it assumes you're very well-acquainted with Access and VBA already. It does give you some great ideas on how to do more esoteric functions in Access (connectivity to other files, file handling, Office Integration etc.) as well as how to make simple list controls work better for you (something I'd never thought of), to even drawing dynamic graphics on a form (well, sorta).The book even specifically addresses something I was originally after -- How to make a 'wrapper' class module that allows you to define bulk form control event handling. Unfortunately, the way the book presents this, the way is to make calls for every control -- which is almost pointless, since a form with 15 custom controls would need 15 custom calls. However, using the methods introduced PLUS some StackOverflow tips (which were not working in Access) PLUS a few hours of programming and thinking on my part -- and I've got it down and the solution is beautiful.That's just one small negative so far -- There's a lot of good stuff in the book, lots of code typed out in the pages so you don't have to hunt down the sample files if you're lazy (they still exist) -- and the errata pages are only like 6, which isn't bad at all -- all found online at the link given in the book.Yes, in 2020, this book is still relevant because of the concepts of VBA introduced -- I DO wish the book tackled how to develop an iron-clad way for Access to always pop up a window in the middle of the screen (they don't address that bug -- given that it's a Microsoft book I believe) but otherwise it's a good reference. Anyone who's used pop-up windows in Access, especially on multi-monitor setups, probably feels my frustration.

I am impressed with the information. It does require a little more knowledge of VBA, however, than just walking into this with no knowledge at all. Two things to look at before getting into this book:1) The first two videos of the "Wise Owl Tutorials" video series on VBA. These are done for Excel, so after the first two videos, the language is different. However, the incredibly well presented information on the syntax and layout of programming in general (specific, in this case, to VBA) is completely invaluable. Also, it is worthy of note that the VBA Editor window is identical on ALL MS Office products. Here is the playlist: https://www.youtube.com/playlist?list=PLNIs-AWhQzckr8Dgmgb3akx_gFMnpxTN5 (several of the videos are good general info that will be helpful, so you don't HAVE to stop after the first two! :) )2) You MUST understand the naming conventions that are used in this book! It will COMPLETELY lose you if you don't know a LOT about Access and the naming conventions that are normal. The best and most complete list of normal naming conventions for Access has been assembled by "Reddick", and can be found here: http://www.xoc.net/standards/rvbanc.aspEnjoy this book! With the examples you can download from MS (referenced on the back cover and inside), you can practice and learn very well. This is good!

I am a certified MS Access 2003 developer and needed a book to help with my clients wanting to upgrade the apps I had written for them. This book really had a wealth of great information. I have dozens of sticky notes on it marking areas that I could use in current projects. I also appreciate the downloadable PDF version of the text and code samples ready to copy into my modules. After scanning the book so I knew what was in it, I have used the PDF version to search for things the most.

This book is one of the most well-written tech book I've ever read. The organization of the material is very logical and the presentations about each topic are very concise, yet precisely written. A few books have even presented erroneous code examples but I haven't found any inaccuracies in this book... which is amazing for such a large amount of information.

When I bought this book, I did not realize it would cost me over $100. I must have been asleep when I bought it. It is a good book, but I am disappointed in its price.

I read the reviews of this book and was still hopeful that it would be helpful. I guess I was looking for more of a tutorial (which I can't seem to find). I consider myself to be an intermediate (albeit self-taught) user of Access. I have also taken a Visual Basic class. I understand the concepts in the book but after three chapters, I don't feel even remotley ready to tackle even the most rudimentary project. I'll keep trudging through.

A very useful book but as with all software books, it would have been better if a few real users of different levels of expertise had been able to read it as it was written because some articles/paragraphs assume you know more than you know. But I have an older VBA programming book for another Microsoft Office program which often helps me understand some of the information in this book. And that is usually the case with these type of books for today's software. You really need two books from different publishers to really grasp the whole information about using a new complicated piece of software. It is too bad that software companies seem to let people from the development group write the manual that comes with the program whether it is a book or a PDF file, or an e-manual. (e-manuals really suck because they could be but usually are not, updated.)

A fantastic book on VBA for access 2010, great examples. It covers everything for beginners and experts alike. Really improved my vba programming technique and introduced some great features. If you are involved in vba programming this book is a must have.