How Far Can You Go with Access 2002?
The answer depends on your knowledge of VBA programming. If you really want to get the most out of Access, the Access 2002 VBA Handbook is essential reading. If you are an experienced user of Access, you get the step-by-step instruction you need to be dramatically more productive. And if you are a more experienced developer, you get the advanced VBA programming skills you need to build the Access applications your users require. Coverage includes
* Running queries to find specific records
* Automating complex and time-consuming procedures
* Importing data from existing data sources
* Synchronizing forms and tables
* Understanding the ADO and DAO models
* Understanding the essentials of Visual Basic for Applications (VBA)
* Customizing the Access user interface
* Creating procedures to change Access's default error-handling processes
* Accessing data using OLE DB and ODBC
* Creating VBA procedures for navigating a database or project
* Writing VBA procedures using object properties and methods
* Creating relationships between forms
* Executing commands using SQL statements in VBA code
* Using ActiveX controls in your VBA procedures
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Editions-Typ
Illustrationen
Maße
Höhe: 22.9 cm
Breite: 19.3 cm
Dicke: 51 mm
Gewicht
ISBN-13
978-0-7821-4013-2 (9780782140132)
Schweitzer Klassifikation
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 2000 VBA Handbook and Access 97 Macro & VBA Handbook, both from Sybex. She has also published articles in Access Visual Basic Advisor and Internet Advisor. Dana Jones is a consultant with MCW Technologies, a Microsoft Solution Provider, and has written for SmartAccess.
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 ADO Object Model.
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.
Appendix A:Glossary.
Appendix B:Data Access Object (DAO) Model.
Index.
