|

 |
Access VBA Level 2
Course Outline
| DURATION |
1 Day
NOTE: This is the
second day of a 2-day course |
| 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.
|
| INTENDED FOR |
Those
requiring a good understanding of the features available in the
MS Access VBA language. The course can be attended as tow
separate days.
|
| DESCRIPTION |
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.
|
| COURSE DATES |
Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
| Weekday |
Wed, 8-Sep-10 |
09:30 - 16:30 |
£200 |
| | Weekend |
Sat, 18-Sep-10 |
10:00 - 16:30 |
£200 |
| | Weekday |
Fri, 8-Oct-10 |
09:30 - 16:30 |
£200 |
| | Evening |
Mon, 11-Oct-10 and Tue, 12-Oct-10 |
18:30 - 21:30 |
£200 |
| | Weekday |
Tue, 2-Nov-10 |
09:30 - 16:30 |
£200 |
| | Weekend |
Sat, 13-Nov-10 |
10:00 - 16:30 |
£200 |
| | Weekday |
Wed, 8-Dec-10 |
09:30 - 16:30 |
£200 |
| | Weekend |
Sat, 11-Dec-10 |
10:00 - 16:30 |
£200 |
| | Weekend |
Sat, 15-Jan-11 |
10:00 - 16:30 |
£200 |
| | Weekday |
Wed, 19-Jan-11 |
09:30 - 16:30 |
£200 |
| | Any |
One-to-One Tuition Any Date - Fully Customisable |
09:30 - 16:30 |
£400 |
|
|
More
on Forms and VBA
-
Export
Reports to Word, Excel, email
-
Use the
Calendar Control
-
Using
Combo and List boxes
Error
Handling in VBA
Manipulating Data through Data Access Objects
-
Data
Access Objects (DAO)
-
ActiveX
Data Objects (ADO)
-
Handling
Databases
-
Database,
Recordsets and Dynaset Objects
-
Finding
and Editing Records in a Recordset
|