Access Programming with VBA
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
2 Days
This two day course is designed to provide delegates with the knowledge to manipulate Access 2000/2003 and gives developers greater opportunities to create rich desktop applications for end users. An improved programming model gives easier access to office functionality allowing for the delivery of powerful custom desktop solutions.
Facilities
Location
Start date
Start date
About this course
Before attending this course, students must have: Attended appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required.
Reviews
Course programme
Overview
This two day course is designed to provide delegates with the knowledge to manipulate Access 2000/2003 and gives developers greater opportunities to create rich desktop applications for end users. An improved programming model gives easier access to office functionality allowing for the delivery of powerful custom desktop solutions.
Examination information
There is no examination associated with this course.
Prerequisites
Before attending this course, students must have:
Attended appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required.
Course outline
Module 1: 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
Module 2: 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
Module 3: Understanding Objects, Properties, Methods and Events
Understanding Objects and Collections
Understanding Properties
Understanding Methods
Understanding Events
Module 4: 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
Module 5: Using Variables, Arrays, and Constants
Declaring Variables
Declaring Arrays
Declaring Constants
Declaring Object Variables
Module 6: Using Functions, Message Boxes, and Input Boxes
Using Intrinsic Functions
Using Message Boxes
Using Input Boxes
Module 7: 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
Module 8: 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
Access Programming with VBA