Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Access 2010 Programming with VBA Course

Access 2010 Programming with VBA Training Course


Course Description: : Access 2010 Programming with VBA training expands on knowledge of Access 2010. Advanced users can use VBA to write rich solutions with advanced data manipulation and user control.

Upon completion of the course, users will be able to:

  • Understand and use the development environment
  • Work with procedures and functions
  • Understand and navigate objects, hierarchies, the DoCmd object and order of events
  • Use expressions, variables and intrinsic functions
  • Control program execution and use branching structures
  • Work with record sets, including DAO
  • Debug code
  • Handling errors

Training Dates

Access 2010 Programming with VBA
Locations: Available Nationwide
Class Date(s): 10/11/17 - 10/13/17
Course Fee : $1195


Access 2010 Programming with VBA
Locations: Available Nationwide
Class Date(s): 11/6/17 - 11/8/17
Course Fee : $1195


Access 2010 Programming with VBA
Locations: Available Nationwide
Class Date(s): 12/6/17 - 12/8/17
Course Fee : $1195


Access 2010 Programming with VBA
Locations: Available Nationwide
Class Date(s): 1/2/18 - 1/4/18
Course Fee : $1195


Access 2010 Programming with VBA
Locations: Available Nationwide
Class Date(s): 1/31/18 - 2/2/18
Course Fee : $1195


Access 2010 Programming with VBA
Locations: Available Nationwide
Class Date(s): 2/26/18 - 2/28/18
Course Fee : $1195


Access 2010 Programming with VBA
Locations: Available Nationwide
Class Date(s): 3/28/18 - 3/30/18
Course Fee : $1195


Access 2010 Programming with VBA
Locations: Available Nationwide
Class Date(s): 4/23/18 - 4/25/18
Course Fee : $1195


Course Syllabus

Getting Started
Introduction to Programming in Access
Why Program in Access?
Understanding the Development Environment
Using Visual Basic Help

Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Organizing Code and Procedures
Working with the Code Editor

Understanding Objects
Understanding Classes and Objects
Navigating the Access Object Hierarchy
Understanding Collections
Using the Object Browser
Working with the Application Object
Understanding the Form Object
Working with Properties
Using the With Statement
Working with Methods
Understanding the DoCmd Object
Working with Events
Understanding the Order of Events

Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Working with Variable Lifetime
Considering Variable Scope and Lifetime Together
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes

Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the For...Next Structure
Using the For Each...Next Structure
Using the Do...Loop Structure
Guidelines for use of Branching Structures

Working with Recordsets
Declaring and Creating Object Variables
Working with the DAO Recordset Object

Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Setting Break Expressions
Using Break Mode during Run Mode
Stepping through Code
Determining the Value of Expressions

Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling

Appendix - Working with the ADO Recordset Object

Onsite access Training
Small Group Package (up to 6 students)
  • A Microsoft Certified Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1600 (over 10% off our Individual Training rates)
  • Additional students can be added for $150/person
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1600 (Flat Rate)

Medium Group Package (up to 12 students)
  • A Microsoft Certified Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2400 (over 33% off our Individual Training rates)
  • Additional students can be added for $125/person
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2400 (Flat Rate)

Large Group Package (up to 18 students)
  • A Microsoft Certified Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 42% off our Individual Training rates)
  • Additional students can be added for $100/person
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100 (Flat Rate)





Alabama
Birmingham
Huntsville
Mobile
Montgomery

Arizona
Phoenix
Scottsdale
Tucson

Arkansas
Bentonville
Fayetteville
Little Rock
Little Rock west

California
Bakersfield
El Segundo
Elk Grove
Fresno
Glendale
Irvine
Los Angeles
Los Angeles West
Orange
Petaluma
Pleasanton
Redwood City
Riverside
Sacramento
San Diego
San Diego downtown
San Francisco
San Jose
Walnut Creek
Woodland Hills

Colorado
Boulder
Centennial
Colorado Springs
Commerce City
Denver
Fort Collins
Grand Junction
Lakewood
Loveland

Connecticut
Cheshire
Danbury
East Granby
Hartford
Shelton
Stamford

Delaware
Wilmington DE

Florida
Boca Raton
Brandon
Clearwater
Daytona Beach
Fort Myers
Ft Lauderdale
Jacksonville
Kissimmee
Lake Mary
Lakeland
Land O Lakes
Melbourne
Miami
Miramar Beach
Naples
Orange Park
Orlando
Orlando Downtown
Orlando Northeast
Palm Beach Gardens
Pensacola
Sarasota
St Petersburg
Tallahassee
Tampa
Vero Beach

Georgia
Alpharetta
Atlanta Buckhead
Augusta
Columbus GA
Duluth
Kennesaw
Macon
Savannah

Idaho
Boise

Illinois
Chicago
Gurnee
Joliet
Naperville
Northbrook
Oakbrook Terrace
Peoria
Rockford
Schaumburg

Indiana
Carmel
Evansville
Fort Wayne
Indianapolis
Indianapolis downtown
South Bend

Iowa
Cedar Rapids
Des Moines
Quad Cities

Kansas
Lenexa
Topeka
Wichita

Kentucky
Erlanger
Lexington
Louisville

Louisiana
Baton Rouge
Lafayette
New Orleans

Maine
Portland ME

Maryland
Annapolis
Baltimore
Bethesda
Columbia MD
Frederick
Greenbelt
Owings Mills
Rockville
Towson

Massachusetts
Boston
Braintree
Danvers
Mansfield
Newton
North Andover
Norwell
Springfield MA
Westborough
Woburn
Worcester

Michigan
Ann Arbor
Franklin MI
Grand Rapids
Kalamazoo
Lansing
Livonia
Novi
Pontiac
Traverse City
Troy

Minnesota
Bloomington
Minneapolis
Minneapolis downtown
Rochester MN
Woodbury

Mississippi
Gulfport
Jackson

Missouri
Columbia MO
Kansas City
Lees Summit
O Fallon
Springfield
St Louis
St Louis downtown

Montana
Great Falls

Nebraska
Lincoln
Omaha

Nevada
Carson City
Henderson
Las Vegas
Reno

New Hampshire
Bedford
Concord
Londonderry
Nashua

New Jersey
Bridgewater
Jersey City
Morristown
Mt Laurel
Paramus
Princeton
Red Bank

New Mexico
Albuquerque

New York
Albany
Bohemia
Buffalo
Harrison
Melville
Mt Kisco
New York City - Grand Central Station
New York City - Lower Manhattan
New York City - Penn Station
Poughkeepsie
Rochester
Syracuse
Uniondale

North Carolina
Asheville
Charlotte
Charlotte Downtown
Charlotte North
Fayetteville
Greensboro
Hickory
Morrisville
Raleigh
Wilmington

North Dakota
Fargo
Grand Forks

Ohio
Akron
Beachwood
Blue Ash
Canton
Cincinnati
Cleveland
Columbus
Columbus Downtown
Dayton
Dublin
Independence OH
Norwood
Toledo
Westlake
Youngstown

Oklahoma
Edmond
Oklahoma City
Tulsa

Oregon
Beaverton
Eugene
Medford
Portland
Salem
Tualatin

Pennsylvania
Allentown
Conshohocken
Erie
Harrisburg
Huntingdon Valley
Lancaster
Malvern
Morgantown
Philadelphia
Pittsburgh
Pittsburgh downtown
State College
University Center
Wexford
York

Rhode Island
Providence
Warwick

South Carolina
Cayce
Greenville
Mount Pleasant

South Dakota
Sioux Falls

Tennessee
Chattanooga
Franklin
Knoxville
Memphis
Nashville

Texas
Addison
Amarillo
Austin
Austin downtown
Bryan
Corpus Christi
Dallas
El Paso
Fort Worth
Grapevine
Houston
Houston North
Irving
Katy
Keller
League City
McAllen
Midland
Plano
Plano Frisco
San Antonio
San Antonio downtown
Sugar Land
The Woodlands
Waco

Utah
Provo
Salt Lake City

Vermont
Shelburne

Virginia
Alexandria
Arlington VA
Charlottesville
Fairfax
Fredericksburg
Lynchburg
Manassas
McLean
Newport News
Norfolk
Reston
Richmond
Roanoke

Washington
Bellevue
Bellingham
Bothell
Kennewick
Mukilteo
Olympia
Puyallup
Seattle
Spokane
Tacoma

Washington DC
Washington DC
Washington DC - Union Station

West Virginia
Martinsburg

Wisconsin
Brookfield
Glendale WI
Green Bay
Madison
Madison east
Milwaukee

Wyoming
Casper
Cheyenne


Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills, Computers - Training, Arlington Heights, IL