Product Description

This unique book provides the easiest possible route to mastering professional Microsoft Access VBA programming. Both IT professionals and absolute beginners will love the book as it avoids needless technical jargon and concisely explains everything you need to know in a simple and no-nonsense way. The author has over 25 years experience in database design, application development, project management and education. The emphasis throughout the book is upon solid, professional coding. The reader is gradually introduced to a set of design rules that summarise best-practice for developing Access applications. Instead of simple code snippets the book takes you through the process of creating a high-quality, sophisticated, robust Access application entirely from scratch. By the end of the course you will have a working and complete application that can be used as the basis for your own real-world projects. The massive A4 format packs up to 50% more information onto each page allowing each skill to be presented as an easily digested, focused lesson across two facing pages of A4. The Smart Method develop and run IT courses and have provided consultancy and training services to many of the world's largest companies in England, Europe and America. This book is also used as the basis of The Smart Method's Access VBA course. If you need to teach Access VBA this book is equally useful as courseware.

Product Details

• Amazon Sales Rank: #30232 in Books
• Published on: 2009-03-01
• Original language: English
• Number of items: 1
• Binding: Paperback
• 296 pages

About the Author
Mike Smart is the founder of The Smart Method Ltd who develop
and run IT courses. Mike has trained delegates from many of the world's
largest companies in England, Europe and America (see back cover of book
for more details). Mike's unique teaching method is fun, absorbing and
virtually 100% effective.

Customer Reviews

The best Access book I've read
I would recommend this book to anyone wanting to learn Access VBA. The lessons were very easy to follow, and after reading it I've been able to do a lot of things with Access that I didn't think were possible before. I've also found it to be very valuable as a reference tool.

It certainly requires you to be well versed in working with Access using the Wizards and knowing how to create tables, queries and forms etc., but it's perfect for an advanced Access user who wants to make professional database applications.

The perfect VBA book!
This book is everything I wanted and more!

Finally a book which doesn't assume you know absolutely everything about Access before launching into VBA! This book breaks you in gently, with step by step instructions for each example in plain english, which you can follow without an in depth knowledge of Access itself.

It does require that you have a basic understanding of how to create tables, queries, forms and reports using the wizards, but I would assume that most people diving into Access VBA are already somewhat familiar with that.

Personally, my knowledge was a bit sketchy, having mostly self-taught through changing things in existing code and breaking them until they worked, then going to forums to ask others how to fix things, however the approach taken in this book really worked well. It allows you to read about a new bit of code, then see it work, and then try it out in an example at the end of the section. Suddenly lightbulbs were firing off all over the place .. "ahhh, so THAT'S why that bit of code wouldn't work the other month!!"

All the way through there are code examples and screenshots, so that if you do get completely lost you can work back and figure out what you're confused about, re-read the examples, check over the sample code and hopefully figure it out.

I actually noticed a couple of minor errors in the book which meant my code wasn't working, and was amazed to receive a reply back from Mike within 24 hours, correcting the word which was wrong and hence allowing my code to work (woohoo!) - the first time I've ever had a reply back from an author when highlighting or suggesting something in their book. Mike was very keen to receive feedback which is a really good thing, in my opinion.

I would definitely DEFINITELY recommend this book to people starting out in VBA - I now understand how the "guts" of Access works and can start to write my own code rather than fiddle about with things until they break, which is a huge saving in time and frustrations!

I'll definitely be using this as a reference guide for some time to come, and passing it on to other colleagues who want to learn about the subject area - can't recommend it highly enough.

A rare gem
I have a shelf full of "teach yourself books" all proclaiming to help me use the software featured on their covers. Not all are successful and some I have even given up on after a few pages. However not this book! Its clear teaching style make it a "must have" for anyone interested in expanding their knowledge of Access VBA.

As a teacher myself I know how difficult it can be to deliver information but the author has done this very successfully. The A4 size makes it possible to deliver a lesson on a double page spread; clear instructions and screenshots complement each other and the effective use of white space allow the reader to absorb the information without a struggle.

I look forward to some of the other titles planned in this series.