Microsoft Access Visual Basic for Applications

Course Number: ACC-VBA

Build sophisticated applications in the environment Access provides.

• Vendor: Microsoft
• Category: Software Development Courses
• Outline: Microsoft Access Visual Basic for Applications PDF
• Prerequisites
• List Price
• Upcoming Classes

Description

This course will teach programming concepts and how to add simple functionality to a Microsoft Access database using Microsoft Visual Basic for Applications. 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); and create a custom switchboard for an Access application.

Prerequisites

Before beginning this course, students should be able to:

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

Six months of experience using Microsoft Access is recommended.

The student should also be comfortable with Structured Query Language (SQL). They should be proficient in writing select statements, update statements and where clauses. Students should attend the course SQL Fundamentals of Querying or have the equivalent knowledge.

List Price

$1450.00

Upcoming Classes

Available classes for Microsoft Access Visual Basic for Applications

Start Date	End Date	Class Status	Days	Location
04/12/2010	04/14/2010	Seats Available	Consecutive days	Sacramento CA	Enroll
06/01/2010	06/03/2010	Seats Available	Consecutive days	Sacramento CA	Enroll