Course Code

vbaaccessexcel
 

     Duration

21 Hours
 
 

     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
 

     Feedback (5)

I liked the examples and the way he explained.

Sandeep Parashar


The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.

Daria Rudin


Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.

Christine Weiler


The flexibility of the trainer and the ability to adjust the exercises to the questions raised during the training. The training did not have a rigid plan, the plan evolved during the training under the influence of my needs.

Paweł Imbir


Good knowledge of the lecturer

Marcin Doleżyk


The course could be tailored to suit your needs and objectives. It can also be delivered on your premises if preferred.


  
  
  


  

Online Price per participant 6000 AED

  

Classroom Price per participant 6000 AED

Starts

 

Ends

 

  Workday courses take place between 9:30 and 16:30

Location


  Show venue details


Number of Participants






Related Courses

Total Courses 4


Access VBA

  21 hours

Excel Advanced with VBA

  21 hours

Visual Basic for Applications (VBA) in Excel - Introduction to programming

  21 hours

Visual Basic for Applications (VBA) in Excel - Advanced

  14 hours

Visual Basic for Applications (VBA) in Excel (intermediate level)

  14 hours

Visual Basic for Applications (VBA) for Analysts

  21 hours

Excel and VBA Programming for Audit and Finance Professionals

  28 hours

 

Analysing Financial Data in Excel

  14 hours

 

Excel For Statistical Data Analysis

  14 hours

Working with spreadsheet in Microsoft Excel

  14 hours

Excel Advanced

  14 hours



Discounted Public Courses



This site in other countries/regions