Customer Reviews

Access 97 VBA Programming with CDROM

5 star:		(28)
4 star:		(15)
3 star:		(5)
2 star:		(5)
1 star:		(2)

 

 

This book is good, but it contains too much information. The book is overkill on Access VBA. More information than anyone can handle. The code examples can be too long. You can learn, but you have to stay awake and remain alert. If not you will fall asleep. I don't recommend it to beginners at all. For all beginners out there, stay clear of this book. If you don't you might end up hating Access VBA. I thought the book could have been written a lot shorter. I recommend this book to experienced users who want to read a few pages a day.

It seemed they assumed more than the beginner knows. Their explanations on why the code works did not provide a clear enough explanation for me to understand what is going on and left gaps that I am still stuggling to fill. Also: it would have been nice to better explain how you decide what variables are required and how you decide the syntax of the commands. All in all, the books starts out ok but then leaves the beginner in the dust as it continues. I would recommend the Step by Step book over this one.

It seemed they assumed more than the begginer knows. Their explanations on why the code works did not provide a clear enough explanation for me to understand what is going on and left gaps that I am still stuggling to fill. Also: it would have been nice to better explain how you decide what variables are required and how you decide the syntax of the commands. All in all, the books starts out ok but then leaves the beginner in the dust as it continues. I would recommend the Step by Step book over this one.

There does not seem to be a good book on VBA written, but this book is the best of a bad lot. If you have no programming or computer science background at all, then this book would be considered an intermediate text and you may wish to try one of the SAMS learning series books instead. However, if you have any background in programming, this book will help you acquire the nuances of using Visual Basic with Access.

The book takes a very practical approach of walking the reader through the various elements of how a VBA application is structured and developed. The chapters are: Designing Applications, Events, Creating Code, Flow Control, Objects, Recordsets, External Data, Reports, Advanced Techniques, Error Handling, Class Modules, Optimization, Libraries, OLE, Internet interfaces and miscellaneous notes. Using a consistent sample application, the reader is walked through each step in the construction of a VBA application.

I find that the use of single demo, which builds upon itself, to be much more effective that snippets of code and incomplete/unrelated examples. With little effort, many of the techniques in the sample code may be modified to fit your own needs.

Overall, the book is a good text as well as reference for sample code. It is not organized as a reference text (use the online help instead). As a systems integration professional, I have purchased this book for more than one of my junior programmers in order to get them started.

I'm a hobbiest programmer and recently purchased this book to start to work on databases. With little previous experience of VBA I have managed to now create quite sophisticated databases that pass information to other MS Office applications. I thought the chapters were very well written, and provide the depth of information that I needed. I would say this is an ideal book for anyone wishing to get a toe hold in this area of technology and a must buy for any serious would be programmer.

Over the past three years, I have been able to successfully complete several sophisticated projects in Access using SQL and macros- I stayed away from extensive use of VBA because you use what you are confident in. My new job as a DBA and developer required extensive use of VBA due to the complexity of reporting from several different databases. I needed a "quick-start" to increase my skill-set and this book gave me what I needed. Unlike other books on the subject- the authors provided easy to understand explanations and "hands-on" examples with the CD that came with the book. This isn't a beginning Access 97 reference- it's a GREAT beginning Access 97 VBA reference. You can immediately get techniques you can implement on your job, with results that will impress the end users. More importantly, it provides a good foundation of the basics to build on. THANKS.

This is not a true beginners book. The word "Intermediate" should appear somewhere on the cover. I am divided on this book, some chapters are fantastic, while others are terribly written. On the negative: the authors make constant reference to how easy this is, however they are forgetting that the readers of this book do not have the multi-year experience that they possess. Certain chapters are extemely complicated are clearly intended for seasoned professionals. They also spend considerable time on procedures that would likely never be used in the real world. On the positive: there is a great deal of information here, the chapter on recordsets in sensational. The authors and I agree that recordset (note this is a broad subject) manipulation is one of the most crucial issues in Access VBA development. After employing what I learned into my real world applications, it is clear why this subject is so critical. They did a great job of writing the chapters that cover recordsets (and all of its' subsets) as well as program logic (If/Then, Do/Loop, For Each/Next, Arrays, etc.). If you are truly a beginner to VBA then buy "Step by Step" first. I would warn that the reader should not be taken in by the word "Beginner" in the title. Do not buy this book unless you are serious about application development. If you can understand this book, then you are moving into an elite status. I would not recommend this book unless your goal is to be compensated (to at least some degree) for your Access programming skills.

This is not a true beginners book. The word "Intermediate" should appear somewhere on the cover. I am divided on this book, some chapters are fantastic, while others are terribly written. On the negative: the authors make constant reference to how easy this is, however they are forgetting that the readers of this book do not have the multi-year experience that they possess. Certain chapters are extemely complicated are clearly intended for seasoned professionals. They also spend considerable time on procedures that would likely never be used in the real world. On the positive: there is a great deal of information here, the chapter on recordsets in sensational. The authors and I agree that recordset (note this is a broad subject) manipulation is one of the most crucial issues in Access VBA development. After employing what I learned into my real world applications, it is clear why this subject is so critical. They did a great job of writing the chapters that cover recordsets (and all of its' subsets) as well as program logic (If/Then, Do/Loop, For Each/Next, Arrays, etc.). If you are truly a beginner to VBA then buy "Step by Step" first. I would warn that the reader should not be taken in by the word "Beginner" in the title. Do not buy this book unless you are serious about application development. If you can understand this book, then you are moving into an elite status. I would not recommend this book unless your goal is to be compensated (to at least some degree) for your Access programming skills.

I can't say how helpful this book has been in developing my VBA skills. I bought this book as a refrence, but I just finished reading it from cover to cover. This is a wonderful book for someone who has some Access knowledge, and wants to advance their skills. Great work!

This books is really an excellent books for novice and beginners as it is intended for.I advise anybody starting to learn basics of VBA programming using access 97. The authers did a greatjob.