Beginning Access 2000 VBA Paperback – Apr 3 2000
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
From the Publisher
This book is for the Access user who already has a knowledge of databases, and the basic objects of an Access database, who now wants to learn how to program with VBA. No need of prior knowledge of programming required. --This text refers to an out of print or unavailable edition of this title.
From the Back Cover
Access 2000 is the fifth version of the hugely successful desktop database from Microsoft. When it was first released in 1992, Access immediately gained praise for its ease of use and power. Each release of Access has added features and increased usability, and with Access 2000 we now have a unified development environment for the whole of the Office 2000 suite of applications. Visual Basic for Applications (VBA) is the programming language that gives Access its real power, allowing you to automate complex tasks and create applications with more scope and flexibility than is possible with its default forms and macros. VBA has a simple syntax allowing even complete novices to learn programming with very little effort, and this book illustrates the concepts with plenty of examples and exercises.
Who is this book for?
This book is for users who already have a basic knowledge of databases and the basic Access objects, such as tables, queries, forms and reports. You now want to expand on your existing knowledge of Access and wish to learn how to program in VBA. You dont need any prior programming experience, although a basic knowledge of Access macros would be helpful.
What does this book cover?
- Constructing a substantial example application with VBA
- Mastering the foundations of Visual Basic for Applications
- Understanding the concepts behind classes and objects
- How Automation can be used to link Office applications
- Creating custom objects using the Class Module feature
- How to debug your programs and implement robust error handling
- Adding support for multiple users
- Publishing your Access database on the Internet
- How to optimize and add polish to your finished database application
Top Customer Reviews
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.
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!
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
Most recent customer reviews
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 morePublished on May 24 2004 by Kelvin Dickenson
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 several... Read more
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...anyway, this book is just pure gold! Read morePublished on March 5 2004 by Tiffany Norman
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 morePublished on Sept. 12 2003 by ex12ex34ax311ab10
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 morePublished on March 18 2003 by AlexanderBanning
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 morePublished on Nov. 15 2002 by Jake Ledgerwood
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 morePublished on May 23 2002 by calvinyw
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... Read more
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... Read more
Look for similar items by category
- Books > Computers & Technology > Databases > Beginning & Introductory
- Books > Computers & Technology > Microsoft > Applications > Office 2000
- Books > Computers & Technology > Microsoft > Development > VBA
- Books > Computers & Technology > Microsoft > Development > Visual Basic
- Books > Computers & Technology > Software > Databases
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages