Customer Reviews

Beginning Access 2000 VBA

5 star:		(12)
4 star:		(8)
3 star:		(2)
2 star:		(5)
1 star:		(1)

 

 

This is a solid book, nicely written, and the authors have obviously put a lot of thought and good effort into it. However, in it's introduction, the authors advise that you don't really need to know anything about programming in order to understand the book. In my experience that's not correct. While a beginner can understand parts of the book, you soon get the feeling that you are in over your head. It gets into fairly complex code quite quickly. It would be a great book if you are taking a class or have a teacher to explain the parts that need clarification. But for a beginner like myself trying to learn VBA on my own, it's too much too soon. Another thing that this book (or any book) could do to help you learn is provide a lot of problems at the end of each chapter for you to try and apply what you learned, sort of the way we learned algebra in high school.

Evan Callahan's Book, Step By Step Microsoft Access VBA is a much more basic beginner's book. It takes you by the hand and gets you writing code quickly. It does not take you very far into VBA, but does get you going.

The next book I'd recommend is VBA Handbook by Susan Novalis. It's a much more gentle intro than is Sussman's book. In fact, after you learn Novalis' book you will probably be ready for Sussman's book.

I previously bought Access 97 VBA and recently ran into problems in Access 2000. After realizing that I was lost just enough to do damange to myself and my job, I bought this book. It explains the differences between ADO and DAO, which was the cause of most of my troubles, very well. As was the case with the 97 version, the examples clearly show how to do most of the things that I wanted to accomplish. This is listed as a beginning book but I think I'd recommend having some programming experience first. This is a nice companion to the 97 version or just a good place to start in on extending the functionality of Access 2000 with VBA.

This book can really improve your skills in vba if you're new to it; it is the book to own to start programming with VBA.
it is assumed that you have some base knowledge on database and Access objects but nothing more; even power users will find some interesting tips.
Very well written.

This book tries to cover too many things, from basic VB syntax to API. You won't learn how to use VBA for practical purposes from this book because it covers too many, too shallow.

Also, I believe this book is too hard for absolute VBA beginners.

This is a very helpful book. HOWEVER, contrary to the description on the book itself, it is NOT for anyone new to programming. If you are familiar with programming, already know Access and want to learn VBA, then it's for you. If you do not have any prior programming experience at all, start with John Smiley's books to get your feet wet, THEN jump into this book! For those ready for it, however, I recommend the book highly.

Looking for a start in Access programming or a VBA reference that gives you the straight skinny in a readable format without oversimplifying the material? Look no further. Without a doubt, this book is the best introductory programming book I have ever read (and I've read quite a few). I've read some comments already about the lack of ADO information, but remember, this is a beginning-programming level book. ADO comes after you get a handle on code, structure, format, and terminology. All in all, I can't give enough praise to this book. A great reference all around. Wrox does it again!

This is a great book that covers many important aspects of VBA and access programming. The title "Beginning" of this book, however, is a bit misleading, because the pace is probably too fast for people who are new to coding. The exercises at the end of each chapter usually require the readers to use new things not covered in the book, so most of the time, I would have to look at the answers first, and then try to understand how the problems are solved. Therefore I feel that the authors are trying to jam in as much information as they possibly can on the topics within limited space. Fortunately the explanations for the codes are well done, and the author stick to their promise that this is a book about the VBA, not 'How-to-use-access'. The authors stick with DAO all through the book and leave out ADO entirely. I agree with them on that decision, so that one can really get a good feel for DAO and not lose focus trying to learn 2 technologies at once. If you can go through this book and understand the concepts and details, I would recommend, as the next step, a developer's reference, such as Access 2000 Developers' Handbook from Sybex.

This book is an intermediate reference which I would NOT recommend to the absolute beginner. Get Evan Callahan's book of nearly the same title. THEN get this book because I have found it to be an invaluable reference. Great how-to examples for every common programming task. You WILL be a true Access geek when you get through this book. For graduation, treat yourself the Developer's Handbook. You'll actually understand what's in it.

Do you really want to learn code? Do you even know what DAO and ADO are? When you do get behind Forms into VBA do you know what all that syntax means? Are you writing your own Functions? Do you know what every line of this code means? If you answer 'no' to any of these questions, get this book. It is great! You'll learn the nuts and bolts of Access 2000 and VBA. You will have to apply yourself some. I now know what this code means because I wrote it (and dozens and dozens of more lines) and you can too! (the code got messed up by the review formatting)

Private Sub SaveThisRecord_Click() Dim db As Database Dim rec As Recordset Set db = CurrentDb() Set rec = db.OpenRecordset("tbljobhoursdetail") rec.AddNew rec!EmployeeID.Value = Me![Text2].Value rec("job#").Value = Me("txtjob#").Value rec!DateWorked = Me!txtDateWorked.Value rec.Update rec.Close End Sub

I have about 12 books on Access development in my bookcase and this is one that I can't stop reading. Why? Because it's done like I think a good beginners book should be. Many books contain a lot of babbling and not enough 'good' examples. This one is different.

Hundreds of useful examples, well explained, waiting to be typed (or used from the CD) can be found. The book explains very well their choice of using DAO over ADO, I thing it's a very good idea. As far as I'm concerned, I thing it's one of the best solid introduction to Access VBA you can find. As an Access teacher, I found some very good concepts and approaches in their projects.

You're very familiar with Access interface? Was exposed to VBA a little? Willing to bring your apps to new heights? Want to see some examples? Then this book IS for you. The pace is reasonable, the writing is great, there are easy to more complex concepts explained. As the title implies, this is a beginning VBA book, not a developer's handbook. But don't be misled by the word 'Beginning', there is serious stuff in there like Class objects, networking issues and approaches to solving good problems.

You're tired of books saying, you could do this or do that without explaining how? This book is not like that. Finally, a book that left out that Northwind omnipresent database and came up with something different!