VBA Excel/Access
Course
In Poole
Description
-
Type
Course
-
Location
Poole
-
Duration
2 Days
The course will concentrate primarily on Excel for the examples but will also use Access. Most of the concepts are directly transferable between the applications. Suitable for delegates wishing to extend their knowledge of the Microsoft Application suite. No programming experience is assumed but any experience that delegates may have will be advantageous
Facilities
Location
Start date
Start date
Reviews
Course programme
Introduction to VBA
· Variables
· Data types
· Arrays
· User defined types
· Constants
Testing for conditions and repeating actions
· Conditions
· Loops
Writing re-useable code
· Event procedures
· Functions and Subroutines
· Parameters
· Scope
What is an object model?
Writing data to files
· Updating values in an Access database
· Updating cell values in an Excel worksheet
Working across applications
VBA Excel/Access