Access 2000 VBA Handbook
1st Edition
Published on 5. August 1999
Book
Paperback/Softback
846 pages
978-0-7821-2324-1 (ISBN)
Description
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
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
More details
Edition
1., Auflage
Language
English
Place of publication
New York
United States
Publishing group
John Wiley & Sons Inc
Target group
Professional and scholarly
Illustrations
illustrations
Dimensions
Height: 23 cm
Width: 19 cm
Thickness: 50 mm
Weight
1440 gr
ISBN-13
978-0-7821-2324-1 (9780782123241)
Schweitzer Classification
Other editions
New editions
Susann Novalis | Dana Jones
Access 2002 VBA Handbook
Book
11/2001
1st Edition
Sybex Inc.,U.S.
€57.90
Article is exhausted, reprint undefined
Person
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.
Content
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.
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.