Beginning Access 2002 VBA Paperback – Feb 13 2003
|New from||Used from|
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
From the Publisher
This book is for the Access user who already has a basic knowledge of databases, and the basic objects of an Access database, and now wishes to expand on their existing knowledge of Access by learning to program in VBA. No prior knowledge of programming is necessary.
This book will also be useful to readers who have programmed a little in other languages, perhaps Visual Basic or VBScript, and need a primer into VBA and its use within Access. --This text refers to an out of print or unavailable edition of this title.
From the Back Cover
If you are using Access and want to go to the next level, you need to learn VBA. As part of Visual Basic®, VBA allows you to use some of the tremendously powerful programming techniques. In this book, we show you how VBA gives you complete control over the way your users view and interact with your Access databases.
This is the next level of Access skills, presented to you here in a clear tutorial style.
This book is a revision of the best-selling "Beginning Access 97 VBA" and "Beginning Access 2000 VBA" books, reworked to provide a rich and comprehensive guide to programming Access 2002 with VBA.
Who is this book for?
This book is designed for people with experience using Access databases, who now want to learn how to program them with VBA. No prior knowledge of programming is needed.
This book is also a useful reference and tutorial for those with some VBA experience or knowledge of other programming languages.
In this book you will learn how to:
- Write your first VBA program how to structure code, control programs, respond to events, and use objects
- Create powerful Access user interfaces
- Publish your data on the internet using the improved functionality of Access 2002
- Debug your programs, and increase their performance and usability with robust error handling
- Improve the performance and security of your database by using the SQL Server® Desktop Engine
- Access your data efficiently with SQL, DAO, and ADO
- Add support for multiple users and integrate with other Office XP™ applications
"We picked up "Beginning Access 2000 VBA" because we needed to be productive quickly. This is the one book that will take you from playing with Access to programming in Access. This book became a favorite with those that had no programming experience and with our experienced programmers too. We ended up having to buy more copies."
Norm Yates (Network Manager, Maine Maritime Academy, USA) on the previous edition.
Inside This Book(Learn More)
In this chapter, we've worked our way through the process of creating part of an Access application with one aim in mind - to deliberately hit a brick wall. Read the first page
Front Cover | Table of Contents | Excerpt | Index | Back Cover
Top Customer Reviews
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.Read more ›
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.
If you want to expand your theoretical understanding of Access 2002 and can get this title at a good discounted rate, you may want to consider purchasing this title. However, if you want both theory and practice, this book has very little to offer.
Most recent customer reviews
All wrox books ship without CDs. You are supposed to download the code from their website.
Shame on you who can't be bothered to visit their site even once!
The book itself is GREAT! Lots of great concepts and tips, etc. The only problem is the book ships with a CD that does not have all of the chapter examples! Read morePublished on March 15 2004
Look for similar items by category
- Books > Computers & Technology > Databases > Beginning & Introductory
- Books > Computers & Technology > Microsoft > Development > VBA
- Books > Computers & Technology > Microsoft > Development > Visual Basic
- Books > Computers & Technology > Programming > Software Design, Testing & Engineering > Software Development
- Books > Computers & Technology > Software
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages