Beginning Access 2000 VBA with CD-ROM

Beginning Access 2000 VBA with CD-ROM

3.8 6
by Robert Smith, Dave Sussman
     
 

View All Available Formats & Editions

What is this book about?

Access 2000 is an important part of the Office 2000 program suite, and is available on both the Premium and Professional editions of Office 2000. Access has traditionally been the Office suite database program par excellence. It still remains that way, but with Office 2000 the face of Access is changing. This book will look at the

…  See more details below

Overview

What is this book about?

Access 2000 is an important part of the Office 2000 program suite, and is available on both the Premium and Professional editions of Office 2000. Access has traditionally been the Office suite database program par excellence. It still remains that way, but with Office 2000 the face of Access is changing. This book will look at the traditional role of Access and its future uses in the Office suite.

Using VBA (Visual Basic for Applications), the user can program his or her own programs in what is essentially a subset of the Visual Basic programming languages. This is tremendously powerful, as it allows you to create great User Interfaces (forms etc), as a front end to actual database storage and manipulation. This continues to be one of the great strengths of programming Access VBA.

This book updates, expands and improves Beginning Access 97 VBA Programming, in an Office 2000 setting. All the great tutorial content, teaching people how to program with VBA in Access is there, but now majorly rewritten to take account of Office 2000.

  • Updated to take account of the Office 2000 facilities
  • Constructs a substantial example application with VBA
  • Database theory taught in the Wrox Beginning style

What does this book cover?

In this book, you will learn how to

  • Construct a substantial example application with VBA
  • Master the foundations of Visual Basic for Applications
  • Understand the concepts behind classes and objects
  • Understand how Automation can be used to link Office applications
  • Create custom objects using the Class Module feature
  • Debug your programs and implement robust error handling
  • Add support for multiple users
  • Publish your Access database on the Internet
  • Optimize and add polish to your finished database application

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 don't need any prior programming experience, although a basic knowledge of Access macros would be helpful.

Read More

Product Details

ISBN-13:
9780764543838
Publisher:
Wiley
Publication date:
05/01/1999
Series:
Beginning Series
Edition description:
BK&CD-ROM
Pages:
896
Product dimensions:
7.22(w) x 9.08(h) x 1.96(d)

Meet the Author

Robert Smith and David Sussman have been programming in Access since it was first released. Using their experience they teach you how the power of Visual Basic® for Applications can transform ordinary databases into great applications.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Beginning Access 2000 VBA with Cdrom 4 out of 5 based on 0 ratings. 7 reviews.
Guest More than 1 year ago
Good text for those just beginning Access 2000 user. However, little instruction offered on how to integrate VBA code modules into a single application, for example, how to use code to control form layout and data. You will need an additional book for advanced Access VBA application programming.
Guest More than 1 year ago
This book is GREAT. Once I started reading it, it was as if I were in a classroom setting. I found that as I was reading, if something seemed a little complicated or I had questions, if I kept reading they would answer the questions in the very next paragraph. I truly enjoyed the tutorials and found everything broken down in terms I could easily understand. I highly recommend this to anyone who wants to get the most out of Access 2000!
Guest More than 1 year ago
I've been teaching Access for several years and recommend this book in every class I teach... it is absolutely phenomenal. It's not designed to be a reference book - but if you're a beginning programmer looking for a book that will explain what you need to know to build great Access apps (including the whys and the concepts), this is the book for you!
Guest More than 1 year ago
I recently taught a class at the local junior college using this book. I think it's a GREAT textbook. So did the students. It's clear, it's easy to follow. The examples follow a single project all the way through the book, so they actually make SENSE. Each thing builds on what you've already learned. Very solid work these authors have done.
Guest More than 1 year ago
It is a good book with a lot of concepts for experianced developers. If Access is the main database application you use and are experiance with, then this is the one!
Guest More than 1 year ago
This book is an excellent book for experienced Access power users who want to take the next step in professional Access development. Concepts are laid out and explained very clearly and cogently in a tutorial fashion. The book is indeed intended to be used as a tutorial and not so much as a reference book. Once again, it is another excellent computer book from WROX. I also recommend that the reader also be familiar with Visual Basic, as this will speed up the learning curve. Readers who are not familiar with VB will have some difficulties.
Guest More than 1 year ago
This book isn't the book for quick reference.You will have to read form the beginning of the book to the end before you really get what you need. Oops! I forgot to mention the index.The indexing are also poor.