Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Frequently Bought Together
Product details
|
More About the Author
Product Description
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.
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.
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.
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.
Inside This Book
(Learn More)
First Sentence
By the end of this book you will have constructed a professional-grade Access application. Read the first page Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
By the end of this book you will have constructed a professional-grade Access application. Read the first page Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
8 of 8 people found the following review helpful
Format:Paperback
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.
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.
3 of 3 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
I am surprised at the number of positive 5 * reviews this text has received as I did not find it that helpful. I have just finished working through it and I found it rather mediocre for the following reasons:
I found that I did not understand a lot of the language, e.g. taking a line at random: "Access can automatically de-reference object variables when they go out of scope...". Even though the concept of scope was explained earlier, I still need someone to explain what the rest of the sentence is getting at... This would be fine in a classroom setting, but not so good for self-study. This happened a lot.
I found the idea of creating a database for movies a rather useless example (though of course someone else might find it directly relevant) and there was too much emphasis on making the application look good rather than finding elegant solutions and shortcuts to common problems using code.
All in all it is ok if you want to familiarize yourself with access and some vba but don't expect the moon (as other reviews suggest).
I found that I did not understand a lot of the language, e.g. taking a line at random: "Access can automatically de-reference object variables when they go out of scope...". Even though the concept of scope was explained earlier, I still need someone to explain what the rest of the sentence is getting at... This would be fine in a classroom setting, but not so good for self-study. This happened a lot.
I found the idea of creating a database for movies a rather useless example (though of course someone else might find it directly relevant) and there was too much emphasis on making the application look good rather than finding elegant solutions and shortcuts to common problems using code.
All in all it is ok if you want to familiarize yourself with access and some vba but don't expect the moon (as other reviews suggest).
9 of 10 people found the following review helpful
Format:Paperback
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.
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.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Access 2003 VBA
This book is not meant for a serious access vba programmer. If you really want to create access vba software, please look for an alternative. Read more
Published 5 months ago by mansi
Access 2003 VBA
As a novice to access I wanted to learn more and this book was exactly what I needed. It takes you through step by step- very easy to follow and yet in a way you can apply the... Read more
Published 11 months ago by SAM
Good introduction to Access
Although I have been using Access for several years, I needed to extend my knowledge to allow better applications to be built. Read more
Published 15 months ago by Mr. Stuart J. Lines
Should be 6 stars - and I HATE "teach yourself" books!
I'm an ex-professional Mainframe (the big computers which used to be at the heart of Businesses) programmer.
I now do voluntary I.T. Read more
I now do voluntary I.T. Read more
Published 15 months ago by Steve Ayton
good book, simple to read
I was hoping to learn more about coding vba, but this book is more like building forms, controls which is also quite useful. In fact, you need the forms to work on the procedures.. Read more
Published on 20 April 2010 by jy6668
Good Book
This book is easy enough to follow without going into too much detail, instead there are plenty of exercises to do in order to learn, which I find more interesting and better for... Read more
Published on 27 Mar 2010 by C. Whiteoak
Best ever Access VBA Book
I have just finished this book and found it to be the best Access VBA book I have ever read. Working through the exercises was an excellent way to get to grips with VBA and I will... Read more
Published on 29 Jan 2010 by Mr. S. Bakewell
Excellent tutorial - but not for absolute beginners
I've been teaching myself Access over the last six months or so and this is definitely the best book that I've read on the subject. I can't recommend it highly enough.
Published on 1 Jan 2010 by The Beta Chimp
Brilliant book and fast service
Very pleased with the book so far and the service was fast recommend both the book and service..
Published on 26 Oct 2009 by Mrs. J. Blankley
Highly Recommended
This is the way that self-teach books should be written. Easy to pick up and follow. It takes you step by step and is written in flowing narrative language which doesn't leave you... Read more
Published on 11 Sep 2009 by Douglas Powrie
Listmania!
|
|
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
