Outstanding delivery !!! The pace is perfect and the instructors can easily customise the content to your business...
More Testimonials »
Access 2010 Programming with VBA
Delivery Options
- Live Online Training - Public Class (): $675.00 (Register)
- Customized Onsite Training (3 days): Request a Proposal
| Class Date and Time |
Price
|
|
|---|---|---|
|
$675.00
or 3 vouchers
vouchers
|
||
| $675.00 or 3 vouchers vouchers | ||
| $675.00 or 3 vouchers vouchers | ||
| $675.00 or 3 vouchers vouchers | ||
| $675.00 or 3 vouchers vouchers |
Class Description
Class Overview
This advanced Access 2010 training class targets people who intend to design databases at an advanced level and/or improve existing Access databases.
Class Goals
- Learn to manage Access 2010 relational databases.
- Learn advanced form customization techniques.
- Learn to optimize and administer Microsoft Access 2010.
- Learn to manage relational databases.
Class Outline
- Getting Started
- Introduction to Programming in Access
- Why Program in Access?
- Understanding the Development Environment
- Using Visual Basic Help
- Working with Procedures and Functions
- Understanding Modules
- Creating a Standard Module
- Understanding Procedures
- Creating a Sub Procedure
- Calling Procedures
- Using the Immediate Window to Call Procedures
- Creating a Function Procedure
- Naming Procedures
- Organizing Code and Procedures
- Working with the Code Editor
- Understanding Objects
- Understanding Classes and Objects
- Navigating the Access Object Hierarchy
- Understanding Collections
- Using the Object Browser
- Working with the Application Object
- Understanding the Form Object
- Working with Properties
- Using the With Statement
- Working with Methods
- Understanding the DoCmd Object
- Working with Events
- Understanding the Order of Events
- Using Expressions, Variables, and Intrinsic Functions
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Working with Variable Scope
- Working with Variable Lifetime
- Considering Variable Scope and Lifetime Together
- Using Intrinsic Functions
- Understanding Constants
- Using Intrinsic Constants
- Using Message Boxes
- Using Input Boxes
- Controlling Program Execution
- Understanding Control-of-Flow Structures
- Working with Boolean Expressions
- Using the If...End If Decision Structures
- Using the Select Case...End Select Structure
- Using the For...Next Structure
- Using the For Each...Next Structure
- Using the Do...Loop Structure
- Guidelines for use of Branching Structures
- Working with Recordsets
- Declaring and Creating Object Variables
- Working with the DAO Recordset Object
- Debugging Code
- Understanding Errors
- Using Debugging Tools
- Setting Breakpoints
- Setting Break Expressions
- Using Break Mode during Run Mode
- Stepping through Code
- Determining the Value of Expressions
- Handling Errors
- Understanding Error Handling
- Understanding VBA's Error Trapping Options
- Trapping Errors with the On Error Statement
- Understanding the Err Object
- Writing an Error-Handling Routine
- Working with Inline Error Handling
Class Materials
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
- Instructor-led Online course technical requirements and setup instructions.
- WebEx system requirements for Instructor-led Online delivery option.
- Onsite course technical requirements and setup instructions.
Client Success
Join The Team
- Learn how you can become a Webucator Trainer
- Career Opportunities
Locations
- Where We've Trained
- We have trainers all over North America.
Compare Us
Watch 3-minute Demo Video
of Live Online Training:
of Live Online Training:
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.