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

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.

Great book take you from basics to advanced code concepts.

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.

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

i am working my way through the examples in each chapter and have encountered a number of places where the code was simply wrong or was missing a critical line that would make it work as expected.expect to have to consult other sources for assistance. sometimes the info appears later in the book but you have to dig for it and/or get lucky.

These books in this series are not cheap but if you are serious about learning VBA or, you just need the code for a real world project you are working on then get this. All the code you need is given at least one comprehensive example. If you are like me, you can tweak code thats already written but your not quite at the point of remembering all the syntax from scratch then...... This is for you! Sometimes you just dont have the time or incline to follow a proper learning curve this will let you jump to the code you need and you can adapt it to suit your needs, not the best way to be fair but none the less youll keep you boss happy.

This book covers the subject in such extensive details that I am amazed. I will continue to read through it and learn everything that I can. Author is very knowledgeable!

Muy extenso, lleno de código y muy bien explicado

This book was not designed for, or modified for Kindle. A typical page from the book is broken down into about 6 or more pages resulting in about 8 lines per page in the Kindle version. This makes it extremely hard to read where even short code listings of 10 lines or less are usually split over two pages. The two screen shots show two separate whole pages of the Kindle version. Also there is no link provided to download the sample files which are referred to in the book.While $39.99 CDN for the Kindle version seems like a good price compared to the $88.00 for the Print version, in reality this should be priced more like $5.00 for what it is worth.

I paid £11 for express delivery and I am a Prime member ! The main issue is the CD included is broken and missing half !! There is no way of contacting the seller to ask for a replacement.