Programming

Access 2016/2013/2010 VBA Programming (2007 Upon Request)

This course is designed to help individuals new to Visual Basic learn the basics of programming in Access, create dynamic forms only possible through VBA, execute actions through conditional statements and loops, and understand and debug code.

Dates & Times

CourseDate & TimeLocationCost
Access 2016/2013/2010 VBA Programming (2007 Upon Request)January 24 - 8:30 - 4:30LathamRegister
Access 2016/2013/2010 VBA Programming (2007 Upon Request)February 26 - 8:30 - 4:30LathamRegister
Access 2016/2013/2010 VBA Programming (2007 Upon Request)April 3 - 8:30 - 4:30LathamRegister

Course Outline

Corporate and NYS discounts do not apply for this course.

This course is appropriate for individuals who need a better understanding of Visual Basic, or who need to automate more complex actions for users of their database. Prior knowledge of Visual Basic is not required.

Includes:
Comprehensive reference manual with participant guide and exercises
Visual Basic Command Reference card, created by MicroKnowledge specifically for this course
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Visual Basic Editor

  • Using Objects
  • Changing Properties
  • Using Methods

Lesson 2: Programming basics

  • Working with Data
  • Understanding Scope

Lesson 3: Control structures

  • Decision structures
  • Loop structures

Lesson 4: ActiveX Data Objects

  • Getting started with ActiveX
  • Data Objects
  • Declaring and Opening Recordsets
  • Using Recordset Methods

Lesson 5: VBA debugging tools

  • Understanding Errors in Code
  • Using Debugging Techniques
  • Handling Run-Time Errors