VBA in Access 2002 3 Days £695

 
 
 
Target Audience:
Access 2000 developers who need a good understanding of the potential available using the VBA language.
Prerequisites:
A thorough understanding of Microsoft Access 2000, including designing & running macros and events gained through attendance on the Advanced course or commensurate knowledge gained through experience.
  • When to use VBA instead of macros
  • The VBA Development Environment
  • Coding in VBA & Writing Procedures
  • Using Variables and Expressions
  • Branching and Looping Commands
  • Typing in Code & Indenting Code
  • Using Arrays and Collections
  • Optional and Named Arrangements
  • Passing Arrays as Arguments
  • Code Compilation
  • Finding Bugs & Debugging Code
  • Types of Erro
  • Ignoring Errors & Trapping Errors
  • Writing useful Error Handlers
  • Logging Errors
  • Active X Data Objects (ADO)
  • ADO Programming model
  • ADO Objects
  • ADO Collections
  • ADO Methods
  • ADO Events
  • ADO Properties
  • Using ADO
  • Connect to a Data Source
  • Start a Transaction
  • Create an SQL Command
  • Execute the SQL Command
  • Manipulate Recordsets
  • Class Modules
  • Using a Class's Properties Methods
  • The PDM Example; Time Managing Multiple Projects
  • Form Events and Properties
  • Using Form Events
  • Code Behind Forms; Changing Form Properties
  • Soft Validation; Creating Validation Event Procedures
  • Value Derivation; Creating New Form Instances
  • Tying Forms/Reports Together
  • Using Form Class Modules

    		•