Microsoft Access 2019 Programming by Example with VBA, XML, and ASP Kindle Edition

I needed a resource to get me up to speed on whats new in access after doing .net for decades. This book fit the bill. I was glad to see the old paradigms are still there along with newer abilities. This will guide you to using this often overlooked powerhouse of a platform ... Access.

This is a thick book AND it is extraordinarily complete. It absolutely delivers what it promises and more about Access, VBA, XML, and ASP--as well as the Microsoft Jet engine (remember that one?), DAO, and ADO database engines. I have probably 10 books on Excel and Access (as well as VB, VS, C#, VBA, python, and more). This is one of the only books I've bothered myself to review because it truly is a good learning tool. If you're a 'super beginner' to software, you might want to start with another book before this one. Another rare quality of this text is that it goes well beyond the beginner level and is more of an intermediate text in my opinion--a difficult to find source with tons of well-researched code snippets and information..

I got the Kindle edition book as I needed an ADO(X) / DAO refresher to get a functional multisite beta out in a couple of weeks - it was very helpful.Parts II/III on DAO ADO(X) & DDL are very thorough, ADO especially is badly documented by microsoft with sketchy info available via google. These sections were very useful, especially as my app needs to manage low bandwidth, poor quality connections to remote server less sites. Batch updates, and temp storage of recordsets / tables client side etc.However If someone purchases this book as a general VBA ref though I think they will be disappointed, there are probably better options out there. Except for Parts II & III It isn't particularly well structured or thorough, it jumps straight from explaining what a variable and If then statement is in part 1, to detailed DAO / ADO / in part II & III. Part IV primarily deals with form / report events, part V Macros and part VI is a very basic intro to ASP and XML.also not great in the Kindle Version was the typesetting and layout. The code was in paragraph text and pretty difficult to follow. It also seems that the sample code for the exercises was not properly tested simple stuff such as defining a class property as read only with only a 'Get' statement (with explanation as to why it's read only) then a little further on attempting to 'set' the property from a standard module instancing the class!. If this was a one off - no biggie, but it seemed that a significant number of the samples had these sort of bugs in. It appears that no code checking and correction by the publisher was carried out.

I bought this as a look up resource and stayed to read it as an inspiration of ideas. Coming out of retirement after 20 years, this mafe re-entry a joy.

Great book take you from basics to advanced code concepts.

Had to upgrade very old access application with a lot of vba code and old style menus and toolbars. I would give it only 4 stars. But for an up-to-date quick and detailed reference, I’m giving it 5 stars.

if you are an Microsoft Access user for a while and have been programming your applications this book is for you, it will expand your knowledge and make it clear all that you already know

Manufacturing defect makes it difficult to turn pages.