Learn Access 2003 VBA With The Smart Method | 
 enlarge | Author: Mike Smart
Publisher: The Smart Method Ltd
Category: Book
List Price: $21.99
Buy New: $19.79
You Save: $2.20 (10%)
New (15) Used (5) from $19.79
Rating:  5 reviews
Sales Rank: 210313
Media: Paperback
Edition: First
Pages: 296
Number Of Items: 1
Shipping Weight (lbs): 1.6
Dimensions (in): 11.6 x 8.2 x 0.7
ISBN: 0955459907
Dewey Decimal Number: 005
EAN: 9780955459900
ASIN: 0955459907
Publication Date: January 26, 2007
Shipping: Eligible for Super Saver Shipping
Availability: Usually ships in 24 hours
| |
| Similar Items:
|
| Editorial Reviews:
Product Description
This unique book provides the easiest possible route to mastering professional VBA programming techniques for Microsoft Access. Both absolute beginners and IT professionals will love this book as it is crammed with great tips and insights into building quality data centric application . No previous exposure to VBA is assumed but, to get the most out of the book, you should already be quite competent with interactive Access. The format of the book is quite special, every lesson has been designed to fit onto two facing A4 pages so that you learn Access VBA in many small, easily digested, focused lessons. The book was originally only available for students taking The Smart Method's popular Access courses. Now it is available to all, both as a self-study guide and also for teachers wishing to use our unique teaching method to run their own Access VBA courses. The emphasis throughout the book is on solid, professional coding practices and techniques. Students are gently introduced to a set of design rules which summarise best-practice for developing Access applications. Needless technical jargon is avoided and everything you need is explained in a simple and no-nonsense way. Instead of simple code snippets the book takes on the task of developing a high-quality Access application entirely from scratch. By the end of the course the student has a working and complete application that can be used as the basis for real-world commercial projects.
|
| Customer Reviews:
 Access 2003 with the Smart Method March 7, 2008
Ahmad Ahmad (Washington, DC)
Excellent Book. First time I ever saw such an excellent book. I wish I had similar books for other products.
 Overall good with a few foibles February 23, 2008
Kevin R. Araki (Juneau, AK USA)
0 out of 1 found this review helpful
The layout, the sequence, and the reason I purchased the book was well worth the money. All of the items to keep in mind when creating an Access Application were well laid out and easy to read. I have just a couple of nit-picky things to comment on...
In the preface it mentions that the book was written in England, but uses American English Yet in a variety of places in the book, I would read "colour" instead of color, and yet it had the spelling "color" as well. There was another example of British spelling and American mix as well, but I can't recall it off-hand (I think "realised" / "realized"). I don't mind the British spelling, but it just should be consistent throughout the book.
Another nit-picky thing: Throughout the book concatenation was done like this: [DirectorLastName] & "," & [DirectorFirstName]. This will put the Last Name, comma, and First Name right next to each other like so: Brooks,Mel. It should have been [DirectorLastName] & ", " & [DirectorFirstName]. Then the director would have looked like so: Brooks, Mel. Yes, I know this is minor... but it is consistent :-)
One final rant, that is not so minor. The index is not well cross-referenced. Here's an example: there is a nice exercise about what to do when data entry does not match an item in the "one side of the relationship." This is known as a "NotInList" event. But the index does not show "NotInList" (maybe that is appropriate, since "NotInList" should not be in the index list, or something like that), but I found the index to be lacking in other cross-reference as well. I don't have the book with me right now, but I could find other examples of lackadaisical indexing.
Overall it has the information that I bought the book for (I'm an Access instructor), but I think it could have gone through a bit of polishing before publishing... therefore four stars, not five stars.
More programming books should be like this one November 30, 2007
Jack Malki
2 out of 2 found this review helpful
I own lots of Access books, some good and some not so good. This book is outstanding. I feel as if I am in a classroom taking a step by step course from an excellent teacher.
The only minor problem I have found is that the database that you download from the internet has a couple of minor differences from what is described in the book, but it was not a big problem. The real joy of this book is that it so clearly and easily explains what you are doing and why. I wish more books were written in this format and with such clear, informative instruction.
This book is best suited to those who know the basics of Access and want to move on to more professional programming. It's also good for people like me who know VBA programming to some extent but want a more solid foundation or wish to fill in the gaps.
Great Book with great practice included. October 18, 2007
Patrick Bailey (Boston, MA, USA)
This is a great learning tool with downloadable databases and instructions. There is nothing better than hands on learning when it comes to VBA.
Learn Access 2003 VBA With The Smart Method June 10, 2007
Pizzo (New England)
8 out of 8 found this review helpful
Pros - The book offers the opportunity to build an enterprise level application where it can be modified to suit individual needs. I like the fact that it takes you through an entire project so each lesson builds on the previous one, there is no disconnect. Other material teaches in pockets not correlating skills or lessons with one another, this one does an excellent job at interweaving them all.
Cons - It is advertised as a beginner's book but it immediately dives into showing you a skill once and then expecting for you to replicate it under a different scenario almost immediately. If you are not comfortable with access from a database development standpoint this can prove to be frustrating. I would recommend starting with something else like "Access VBA Programming for the absolute beginner" ISBN 1-59200-723-6.
Otherwise the book is a good all around training tool that will help you further knowledge on VBA for applications.
Luis
|
|
|
