VBA For Access & Excel Training Course

Course Code

vbaaccessexcel

Duration

21 hours (usually 3 days including breaks)

Requirements

Delegates should be comfortable using Excel formula, sorting filtering, charts, pivot tables et cetera. With Access, they should be able to maintain tables, queries, forms and reports.

Overview

The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.

Course Outline

Introduction to VBA

  • Introducing the VBA environment
  • VB Editor
  • Using Project Explorer
  • Toolbox
  • Modules
  • Procedures and Functions
  • Comments

Principles and concepts of programming

  • Data types, variables and constants
  • Program flow control
  • If…Then… Else
  • Do…Loop, While and Until
  • For…Next statements 
  • Input / Output, Message boxes, Input boxes
  • Code behind forms, Form controls manipulation
  • Passing arguments, Returning Values

Debugging

  • Run Time, Design Time, and Break Mode
  • Breaks and Watches
  • Local Window
  • Immediate Window

Access - Object-Oriented Programming

  • Access object model
  • Objects, Collections
  • Events
  • Methods and properties
  • Data Access Object Library

Access User Interface Design

  • Programming event procedures
  • Dynamic combo boxes
  • User inputs
  • Interface design considerations
  • Menus

Access SQL & Database Design

  • Filtering – various Where clause options
  • Deriving data - calculated fields
  • Inner table joins
  • Outer table joins
  • Sub-queries – filtering, virtual tables and columns,
  • Creating – adding rows directly or via queries
  • Updating and Deleting - directly and via sub-queries
  • Creating and Dropping tables
  • Creating relationships
  • Use of primary and foreign keys

Excel - Object-Oriented Programming

  • Excel object model
  • Objects, Collections
  • Events
  • Methods and properties

Excel – Programming Analysis Routines

  • Sorting, filtering and distributing data between worksheets and workbooks
  • Using VBA to control charts
  • Using VBA to control pivot tables
  • Using VBA to control What If scenarios
  • Importing from external files, internet et cetera

Error Handling

  • Stepping through code
  • Finding syntax errors
  • Using Debug.Print
  • Building error-trapping routines

Testimonials

★★★★★
★★★★★

Related Categories

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Latvia!

As a Business Development Manager you will:

  • expand business in Latvia
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!