With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with ActiveX Data Objects (ADO), perform database tasks with Jet/Access Structured Query Language (SQL), and export/import Access data to and from XML both manually and programmatically.
The book, which covers the latest release of Access and earlier versions, is divided into five parts: an introduction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. The text will show you how to write and debug your programming code with the Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, and collections; code a “message box” and reprogram characteristics of a database; query and manipulate your database from a Web browser with Active Server Pages (ASP) and many more practical techniques.
Good for nuts and bolts VBA in Access
By Russ Gifford on Jun 29, 2013
This book will take you beyond the 'snippets' of VBA you have been writing in Access and move you into actual modules. Priceless if you are trying to move into a world where your constructs are MORE like a true program with a database attached. I have been impressed by this author's books.
By Brian Doersom on Apr 11, 2013
I have been looking for an ACCESS VBA programming book and never found anything that was even close to what I wanted. This is defintely it! Examples are good, details on what you are doing is great! Overall, I would recommend this book to anyone that would like to learn VBA!
Very Good Articulation
By John Dimartino on Mar 23, 2014
I enjoy a good technical publication when it's articulated based on reality and not class room idealistic scenarios. This book does present the material systematically, and does make practical use of the Application's features, functions and methods and explains properties, and classes.
Great book. Covers the topics from basics to advanced
By Carl S. Robitaille on Jun 29, 2013
This book takes you from the very start, if you need it, into the more advanced topics that you can use for first-class applications.
By Kenneth D. Smith on Oct 06, 2014
Incorrect price and pub date
By Roger Breedlove on May 18, 2012
The price of this book is $49.95 and the publication date is May, 2012. It is an update of the author's previous books on MS Access.
So good so far...
By Robert N. White Iv on Apr 03, 2013
I've started building an Access app for my company about six months ago. (I had no clue of what Access even was at the time!) Since, I have become very familiar with the workings of Access and am ready to go to the next level. We'll see! I'm about 100 pages in and the lessons are thorough and easy to follow. The lessons have already answered numerous questions I didn't know I needed to ask! If you are already familiar with Access and need a VBA boost, I would say get this book.
An excellent nuts and bolts VBA tutorial.
By Tenmile on Feb 22, 2015
I've been programming with VBA in Microsoft Access for years. Like many, I just taught myself by muscling my way through problems and writing code that worked through trial and error, picking up a lot of bad habits and missing a lot of fundamentals along the way. Make no mistake, "Microsoft Access 2010--Programming by Example" is not written for the previous me. This is a tutorial meant to be followed chapter by chapter, using the examples either keyed in by the reader or downloaded from the supplied disk. What I love about this book is its straightforward, logical organization, and its excellent (so far, I am only several chapters into it and have only found one error) presentation of code that runs as it should, with complete explanations of what is going on under the hood. It does not stray from the fact that it is working in the Access environment. Normally I chafe at being taught fundamentals, but I love it when the fundamentals are taught as part of the "hunt" and not as an annoyance to get through. Although I am early into the book I have already lost several deeply ingrained bad habits and have a number of ideas of how to improve code I have already written. I will point out one thing. I had taken a break from programming for the last couple of years and had not been aware that Microsoft had changed its "Help" feature for Developer applications. Instead of the, in my opinion, highly annoying, and basically stupid "online" help feature that Microsoft has been using for its applications, it has switched to "offline" help for developers. This means that the "Help" feature is now actually useful--in fact very useful--to the extent that a programmer no longer needs a hardbound paper reference book while writing code. Therefore, the fact that "Programming by Example" is not in itself the best syntax reference book I have seen is no flaw: such books are for my purposes no longer needed. Again, this book is meant to be followed like a tutorial, not used as a "lookup" book. If you don't want to spend time going through the exercises, look elsewhere. But from my experience, you will not find a better tutorial work. I recommend this book to any newbie to VBA who is working with Access 2010, and to any experienced VBA coders like myself who want to go back and straighten out their basics.