Course Description

Course name

VBA for Access 2007

Course code

ACCVBA2007

Audience

Access users who need to learn where, when and how to code VBA.

Prerequisites

Folks that have a working knowledge of Access and its basic functionality.

Objectives

Upon successful completion, the participant will be able to:

· Declare and define scope of data and code.

· Code in Access VBA language constructs.

· Test an application and Debug an Access Application, displaying variable contents and setting breakpoints in the code.

· Build and invoke a function from an Access Form.

· Create and use RecordSets to manipulate records
  • Explore object collections
  • Develop and execute event and general Procedures .
  • Learn how to create simple loops
  • Handling errors within Visual Basic

Duration

2 days

Delivery method

Classroom Interactive/workshop