Back to Search Results

Training Course Summary:

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

Pre-Requisites:

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

Training Course Overview/Content:

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.