Beginning Access 2000 VBA: Amazon.ca: Robert Smith, Dave Sussman, David Sussman: Books

Product Description

Book Description

Access 2000 is the database of choice for the home and small business user. While its intuitive interface makes data storage and manipulation incredibly simple, you really need its underlying language to make the most of its features. The focus of the book is the programming language that underlies Access 2000 - Visual basic for Applications (VBA). VBA is the language that Microsoft is making standard across the whole Office suite of applications. VBA allows you to automate and secure your database, so your end-user need never know what goes on underneath. Its simple style allows even complete novices to programming to achieve impressive results with very little effort.

Ingram

For the Access user who already has a knowledge of databases and the basic objects of an Access database, here is a book that provides tips for creating and customizing an example Access 98 application with VBA and teaches readers to optimize their database to get the best performance out of it.

See all Product Description

Inside This Book (Learn More)
Browse and search another edition of this book.

First Sentence
You can achieve a great deal in Access without ever knowing anything about programming at all. Read the first page

Explore More
Concordance

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

Customer Reviews

28 Reviews

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

Average Customer Review

3.9 out of 5 stars (28 customer reviews)

Share your thoughts with other customers:

Create your own review

Most helpful customer reviews

1 of 1 people found the following review helpful:

3.0 out of 5 stars It's Good But Not For Absolute Beginners, Mar 6 2003

By A Customer

This review is from: Beginning Access 2000 VBA (Paperback)

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.

Help other customers find the most helpful reviews

Was this review helpful to you? Yes No

Report abuse

1 of 1 people found the following review helpful:

4.0 out of 5 stars Nice follow up to Access 97 VBA, Jan 3 2002

By

Craig Willford "kregerator" (St Paul, MN United States) - See all my reviews
(REAL NAME)

This review is from: Beginning Access 2000 VBA (Paperback)

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.

Help other customers find the most helpful reviews

Was this review helpful to you? Yes No

Report abuse

1 of 1 people found the following review helpful:

5.0 out of 5 stars Useful guide to improve skills, Nov 7 2001

By

Vladimiro Cerni (, BRESCIA Italy) - See all my reviews

This review is from: Beginning Access 2000 VBA (Paperback)

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.

Help other customers find the most helpful reviews

Was this review helpful to you? Yes No

Report abuse

Share your thoughts with other customers: Create your own review

› See all 28 customer reviews on Amazon.ca

Want to see more reviews on this item?

› Go to Amazon.com to see all 30 reviews 3.9 out of 5 stars

Most recent customer reviews

1.0 out of 5 stars How to make VBA impossibly confusing
The book seems to be written with the objective of showcasing how much the authors know about VBA without imparting any of this understanding to the reader. Read more

Published on May 24 2004 by Kelvin Dickenson

3.0 out of 5 stars Only two complaints
Overall, yes it is a very good book, but I have two issues with it.
1. The authors sometimes give code examples that use functions/syntax that are not explained until... Read more

Published on May 17 2004 by Joe

5.0 out of 5 stars I know..it's 2004 but this book f*cking rocks!
Yeah, I still use Access 2000, but so freakin' what? Can most folks really justify the cost of upgrading to Access 2002/2003? Didn't think so... Read more

Published on Mar 5 2004 by Tiffany Norman

5.0 out of 5 stars Pork loaf
Best book on VBA i've ever had the misfortune of reading. Not the most pleasant of subjects, but this book did a masterful job of presenting ideas, structures and syntax in a... Read more

Published on Sep 12 2003 by ex12ex34ax311ab10

5.0 out of 5 stars Detailed examples, clear progression, lucid explanations.
I felt this book was written for me. I received it, turned to chapter 8, and there in front of me was a solution I had been searching for weeks. Read more

Published on Mar 19 2003 by AlexanderBanning

5.0 out of 5 stars Where have all the Macros gone?
After developing in Access & SQL Server for a number of years, I was always intimidated by VB development and had made a conscious effort to develop "work-arounds" for my lack... Read more

Published on Nov 16 2002 by Jake Ledgerwood

4.0 out of 5 stars A book for people with no programming background
Maybe a good book for people with no programming background. For people coming from other programming languages, look elsewhere, unless you want to go through the basic concepts... Read more

Published on May 23 2002 by calvinyw

2.0 out of 5 stars Definitely NOT recommended for the beginner
I bougth this book and discovered that it was not for someone like me just learning Access VBA.

In fact I had to buy Access 2000 VBA Handbook by Susann Novalis (ISBN 0782123244)... Read more

Published on Feb 16 2002

5.0 out of 5 stars Best Yet
Thank You!

Your publication, Beginning Access VBA 2000 is just what I need to learn VBA. I have several other books on Access, but have not been able to learn how to use Visual... Read more

Published on Jan 21 2002 by Robert Pittman

2.0 out of 5 stars Not recommended for beginners
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... Read more

Published on July 29 2001 by Tom Fall