Access 2002 VBA Handbook

-Programmers improve database productivity with this task-oriented guide to using macro and VBA programming to create custom database applications. --Building on a basic knowledge of Access, this book takes users to the next level, providing covera

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

Access 2002 VBA Handbook......Page 1 Who Should Read This Book......Page 6 Organizing Your Work......Page 7 New Access 2002 Features......Page 8 Analysis Tools......Page 9 Endnotes......Page 10 Overview......Page 11 Using the Task Pane......Page 12 Creating Navigation Paths with Switchboards......Page 14 Exploring the Application......Page 22 Examining the Wizard's Work......Page 29 Exploring the Standard Module......Page 31 Exploring the Procedure for a Command Button......Page 34 Using the Command Button Wizard......Page 37 Using Hyperlinks to Navigate......Page 40 Storing Hyperlinks as Data in a Table......Page 42 Creating a Label Hyperlink......Page 44 Creating a Clickable Image......Page 45 Creating a Command Button Hyperlink......Page 46 Using the Web Toolbar......Page 47 Designed specifically for Access power users, not experienced programmers, this task-oriented guide will help readers build on their Access experience and develop the VBA programming skills needed to create custom database applications