Microsoft Access 2003 VBA Programming

	In this course you will learn how to extend the functionality of Access using a programming language called Visual Basic for Applications (VBA). With VBA you can create code which will allow you to automate the functionality of your database You will learn how to use the individual elements of this powerful programming language in order to design, develop and run VBA code.
	Duration: 1.0 day(s) Price: £258.00 + VAT	Download Course Content   Download Course Files

Locations

Infero Ltd is based in the Lace Market in Nottingham. Training courses take place at the following locations including Nottingham, Derby, Loughborough, Mansfield, Chesterfield, Burton-on-Trent, Lincoln, Leicester, Sheffield, Stoke-on-Trent, Tamworth, Wolverhampton, Walsall, Birmingham, Solihul, Coventry, Nuneaton, Peterborough, Grantham.

Target Students

The target students for this course are those individuals who regularly use Access and wish to extend its capabilities through programming.

Prerequisites

Microsoft Access 2003 Application Development or equivalent experience.

Delivery Method

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

Course Objectives

Upon successful completion of this course, students will be able to:

• Work with objects, use Object Browser, identify collection objects, and use the Controls collection.
• Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another.
• Use decision structures and use loop structures.
• Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query.

Course Content

Lesson 1: Visual Basic Editor

Objects.
Object Browser.
Collections.

Lesson 2: Programming basics

Data.
Scope.

Lesson 3: Control structures

Decision structures.
Loop structures.

Lesson 4: ActiveX Data Objects

Getting started with ActiveX Data Objects.
Working with ActiveX Data Objects.

Lesson 5: VBA debugging tools

Errors in code.
Debugging techniques.
Handling run-time errors.