Access VBA Level 1
Course
In Southwark
Description
-
Type
Course
-
Location
Southwark
-
Duration
1 Day
This course has been designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access. The course is aimed at those with little or no previous.
Important information
Government funding available
Facilities
Location
Start date
Start date
About this course
A sound
knowledge of Windows and MS Access including, table creation,
query and report writing functions, macro development and
relational database concepts gained from practical experience or
by prior attendance on an "Access Advanced User" course
is essential .
Reviews
Course programme
This course has been designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access. The course is aimed at those with little or no previous programming background, although experienced programmers wishing to learn VBA will find it a quick and valuable introduction to the language. Throughout the course the theme of adopting good programming practices will be encouraged and advice will be given on planning applications systematically, efficiently and economically. The techniques covered are typical of those encountered in a business database application; focusing in particular on triggering VBA from objects such as queries and forms.
PREREQUISITES
A sound knowledge of Windows and MS Access including, table creation, query and report writing functions, macro development and relational database concepts gained from practical experience or by prior attendance on an "Access Advanced User" course is essential.
An Introduction to VBA
-
Macros
versus Visual Basic for Applications
-
VBA
Objects and the Browser
-
VBA
Procedures
-
VBA Coding
-
Variables
and expressions
-
Branching
and Looping
-
Comments
and Indents
-
Public
Modules
-
Private
Modules
-
Writing
your Functions
-
Using
functions in Queries and Forms
-
Using Form
Events
-
Code
Behind Forms
-
Changing
Form Properties
Access VBA Level 1