|
|
|
Access 2000 Programming
Version 9.0
Prerequisites
Appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required.
|
| Duration 3 day(s) |
Getting Started
- Introduction to Programming in Access
- Why Program in Access?
- Creating a Macro
- Understanding Modules
Creating a Standard Module
- Understanding the Development Environment
- Using the Project Explorer
- Using the Properties Window
- Using the Code Window
- Working with Procedures and Functions
- Understanding Procedures
- Creating a Sub Procedure
- Creating a Function Procedure
- Calling Procedures and Functions
- Using the Immediate Window
Working with Code
- Understanding Objects, Properties, Methods and Events
- Understanding Objects and Collections
- Understanding Properties
- Understanding Methods
- Understanding Events
Understanding the Access Object Hierarchy
- Understanding Access Objects
- Using the Object Browser
- Controlling the Application Object
- Understanding the Forms Collection and Form Object
- Understanding the Controls Collection and Control Object
Using the With Statement
- Understanding the Reports Collection and Report Object
- Understanding the DoCmd Object
- Using the Screen Object
- Using Variables, Arrays, and Constants
- Declaring Variables
- Declaring Arrays
- Declaring Constants
- Declaring Object Variables
Using Functions, Message Boxes, and Input Boxes
- Using Intrinsic Functions
- Using Message Boxes
- Using Input Boxes
Controlling Program Execution
- Using Control Structures
- Working with Conditional Expressions
- Using the If...Then...End If Structure
- Using the If...Then...Else...End If Structure
Using the Select Case...End Select Structure
- Using the Do...Loop Structure
- Using the For...Next Structure
- Debugging Code
- Understanding Errors
- Using Debugging Tools
- Stepping Through Code and Setting Break Points
- Understanding Error Events
- Understanding the Err Object
Using the On Error Statement
- Writing an Error Handling Routine
- Compiling All Procedures
WACP90 ONLINE - 11/19/1999 0:00:00
|
