Mastering Microsoft Access 2000 (VBA) Programming

Course 1300: Videos equivalent of 5 days intense instructor led training
One user license for 1 month and media available via internet downloads for only $199.00

Introduction

This course will teach programming concepts and how to add simple functionality to a Microsoft Access database using Microsoft Visual Basic® for Applications.
At Course Completion

At the end of the course, students will be able to:

• Use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Access applications to write custom functions and event-driven procedures.
• Validate data.
• Find and trap errors.
• Gain access to and manipulate data in tables using ActiveX® Data Objects (ADO) and Structured Query Language (SQL).
• Create a custom switchboard for an Access application.

Microsoft Certified Professional Exams

This course will help the student prepare for the following Microsoft Certified Professional exam:

• To be determined.

Prerequisites

Before beginning this course, students should be able to:

• Design a relational database.
• Use Microsoft Access to:
• Create a database with multiple tables, forms, and reports.
• Create queries.

Recommended:

• Six months of experience using Microsoft Access
• Completion of course 1539, Mastering Database Fundamentals Using Microsoft Access 2000

The course materials, lectures, and lab exercises are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites.
Course Outline

Day 1

Module 1: Introduction to Programming

Topics

Overview of a Microsoft Access application
Writing procedures
Working with variables
Controlling program flow
Calling procedures
Getting help

Lab

Introduction to programming

Skills

Students will be able to:

• Use Visual Basic Editor to add code to applications.
• Declare and use variables.
• Use built-in functions to obtain values from users.
• Create and call Sub procedures.
• Use conditional statements to control the flow of programs.
• Use Visual Basic Help.

Module 2: Responding to User Actions

Topics

Overview of the class application
Adding event procedures
Working with events
Using objects, properties, and methods
Using the DoCmd object

Lab

Responding to user actions

Skills

Students will be able to:

• Create an event procedure.
• Add an event procedure to a form.
• Respond to user actions programmatically.
• Perform specific tasks using the DoCmd object.

Module 3: Validating Data

Topics

Overview of data validation
Validating data without using code
Validating data by using code

Lab

Validating data

Skills

Students will be able to:

• Differentiate between data validation at the table level, form level, and code level.
• Use the built-in validation tools in Microsoft Access.
• Write Visual Basic for Applications code to validate data.

Day 2

Module 4: Using Functions and Understanding Scope

Topics

Using functions
Understanding scope

Lab

Using functions and understanding scope

Skills

Students will be able to:

• Create custom functions.
• Create private and public variables.

Module 5: Using Debugging Tools

Topics

Stepping through code
Viewing variables

Lab

Using debugging tools

Skills

Students will be able to:

• Set breakpoints to stop program execution.
• Run selected portions of code.
• Test data and procedures in the Immediate window.
• Monitor variable values in the Locals window.
• Add and edit watch expressions.

Module 6: Handling Run-Time Errors

Topics

Types of errors
Run-time errors
Adding error handlers

Lab

Handling run-time errors

Skills

Students will be able to:

• Trap run-time errors.
• Create error handlers.
• Create a template to write procedures.
• Use the Err object.

Day 3

Module 7: Looping Through Code

Topics

Overview of looping structures
Do loops
For loops
Interrupting the execution of a loop

Skill

Students will be able to:

• Create loops to control the flow of programs.

Module 8: Working with Records

Topics

Overview of record sets
Retrieving data
Structured Query Language (SQL)
Manipulating data

Lab

Working with records

Skills

Students will be able to:

• Retrieve data using SQL and ADO record sets.
• Manipulate data using SQL and ADO record sets.

Module 9: Completing Your Application

Topics

Reviewing your application
Enhancing the user interface
Packaging for delivery

Lab

Finalizing your application

Skills

Students will be able to:

• Use good coding practices.
• Customize a switchboard form.
• Hide code by creating an MDE file.
• Package an application for distribution.

For more information or to give feedback, send e-mail to info@GuideToLearn.com or call 714.809.2719