• Author:
  • Novalis, Susann
• Subject:
  Business Applications
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  22/07/1999
• Price:
  $74.99
• <  Buy this book  >

Want to get the most out of Access? Then you need to know VBA.

Access 2000 is here, and never has the power of Access depended so much on VBA programming. This makes the Access 2000 VBA Handbook essential reading if you want to use Microsoft's popular database product to its full advantage. If you're an Access user, you'll benefit from step-by-step coverage of VBA basics that will simplify your work. If you're a developer, you'll master the high-end techniques introduced in the latest release-so you can stay on top of your job.

You'll learn how to:
* Create databases and projects
* View and print reports
* Run queries to find specific records
* Automate complex and time-consuming procedures
* Synchronize forms and tables
* Understand the ADO and DAO models
* Customize the user interface
* Access data using OLE DB and ODBC
* Create VBA procedures for navigating a database or project
* Use object properties and methods to write VBA procedures
* Create relationships between forms
* Execute commands using SQL statements in VBA code
* Use ActiveX controls in your VBA procedures

Susann Novalis, Ph.D., is a Professor of Mathematics and Associate Dean of the College of Science and Engineering at San Francisco State University. She is the author of Access 97 Macro & VBA Handbook and Automating Microsoft Access with Macros, both from Sybex. Her work has also appeared in Access Visual Basic Advisor and Internet Advisor magazines.

Introduction.

Chapter 1: Automating a Database without Programming.

Chapter 2: Getting Started with Objects and Events.

Chapter 3: Introducing the Access Object Model.

Chapter 4: Communicating with Forms.

Chapter 5: VBA Programming Essentials.

Chapter 6: Understanding the DAO and ADO Object Models.

Chapter 7: Writing Procedures.

Chapter 8: Using Variables.

Chapter 9: Controlling Execution.

Chapter 10: Dealing with Errors in VBA.

Chapter 11: Navigating with Access VBA.

Chapter 12: Maintaining Data with Access VBA.

Chapter 13: Working with Groups of Records Using Access VBA.

Chapter 14: Creating and Modifying Database Objects.

Chapter 15: Expanding Access.

Glossary.

Index.