 |
 |
Beginning Access 2002 VBA
by Robert Smith, Dave Sussman, Ian Blackburn, John Colby, Mark Horner
List Price: $49.99
Our Price: $34.99
ISBN: 0764544020
Publisher: Wrox (February, 2003)
Edition: Paperback
Sales Rank: 300,163
Average Customer Rating: 2.5 out of 5
|
Buy now directly from Amazon.com
|
|
 | |  |
|
| | Customers Reviews: | | |
| |
Rating: 2 out of 5
Try it out, Why it didn't work?
It is not for beginners. It should be called "An Introduction to Access VBA", because it is very theoretical, and the authors seem not have the knowledge of the difficulties the beginners in programming are faced, when trying to run the code by simply copying it from the text.For example, in the ulterior version refering to Access 97, if you dont have the cursor on the name of the procedure or function you wont get it running when the run button or run menu is clicked. That is an information that a beginning book should teach to beginners. This version, refering to Access 2002, is enlarged by new interesting contributions, like to specify records that should be reported using a filter form.I like the way Wrox books are formated, but this book miss revision in text and code.As a beginner in VBA, I can bear errors in text, but when neither the code on the book or on the CD runs, I am disappointed and I would advise only skilled programmers willing to find out why the code didn't work to buy the book.Until a full revision be done, beginners dont buy it. I am longing for a Microsoft Team Access 2002 VBA Step by Step, or a Beginning Access 2002 VBA by John Connell.
Rating: 2 out of 5
Good Start, but loses it about 150 pages into the book
I knew how to do all the basics in access, Make forms, reports, basic queries, and basic access pages--so I got this book hoping to expand on the one area i was foreign to--VBA. The first 150 pages were great, very clear and like any WROX book, they do these 'do it yourself' examples where they make you type out some code. After roughly page 150, I began to get sucked into a quagmire of theory and less and less practical application. I went into this book hoping to answer the single question 1. What practical uses of VBA can i employ in my bio-tech work environment? As I proceeded into the book I realized that I was being lost in theory and -0- practical application. The book sure tells you what an Array is, what Functions are, Methods, operators, etc--but you know what? I sure wish there were some practical examples! good lord, there is an entire chapter on the history of DAO stuck in the middle of useful information. This book for the most part is a massive amount of theory which is used in THEIR context, not one that one could think 'hey..that might be useful!'---on page 226 I realized I had found something that might be useful to me: a way to count how many records are in a table. Excellent. It only took 226 pages to get there. But other than that--I have 250 pages of information stored in my brain and can't think of any practical use for them! The book has a large 'ice cream' database that it uses for examples, but its really really just not very helpful. Its method of teaching I think contains way too much theory and far too little practical training and experience. If you already know VBA or another language, sure this will be a decent review--but if you don't know any language well like me, but you DO know access fairly well minus the VB aspect, this book will leave you clueless at the entrance of chapter 5. My favorite line? Page 228 "You should be getting a feel for the VBA code by now, so we won't explain every line that we write" Ah, wonderful--not only am I left in the dust due to excessive amounts of theory which I have not been able to use, but now they're not going to explain every line. Anyway, I usually like the Wrox books--like their javascript book, but this one is just terrible. If you are new and you want something to help you with the fundamental uses of VBA and its practical application, LOOK ELSEWHERE. If you want a reference book on how specific areas in VBA work--this book will be a decent refresher. Ethan
Rating: 5 out of 5
Excellent book to use to come up to speed
A number of books out there look at Visual Basic for Applications, but this is the only one so far that focuses on the newest version of Access. I found this book to be invaluable in cutting through the clutter and getting me straight to the practical applications of VBA. The authors take you through basic programming tenants but don't dwell on them. Rather they jump into examples that are very interactive and instructive. Their examples are clear and are good starting points to expand from on your own. It is not an exhaustive reference, but you benefit from it more if you have some decent Access experience. If you don't know a database, you are not going to learn here. But in just a few weeks after reading this book, I find myself going again and again into the examples as starting points for my own projects. And it is amazing how a little bit of programming will impress the users. There are a couple of mistakes in the book that can inhibit your code from running. In addition, the database supplied has dates of 1998 and 99, but the book uses dates in 2001, so you have to adjust your code in order to get results. And unfortunately WROX has shut down its errata area so you can't really get help with these problems. So don't assume if your code doesn't work, it is your fault. This is where the code on the CD can be helpful - if it doesn't run right it's the program, not the programmer. Overall with a little patience and work, you can get a huge amount of help from this book.
| | |
 | |  |
|
|
| Please note: |
Checkout and payment processing is done safely and securely through Amazon.com. |
| Prices (as shown) are subject to change without notice and cannot be guaranteed. |
|
| |
View My Shopping Cart
Email this page to a friend
Correction/Comment/Suggestion Regarding This Page?