Course
Length: Two or Three Days
Fees: Training at Client Offices: One delegate: £495 per-day + VAT
Additional delegates attending: £100 each per-day + VAT
Manuals available @ £35 each (optional)
Overview: On completion of this course delegates should be
able to:
 | To create and use custom functions and
sub procedures within modules |
| To create event procedures in form and
report modules and be aware of the scope of event procedures |
| To debug code and be able to add
error-handling features to their code |
This course assumes delegates have an advanced
working knowledge of
Microsoft Access including creating macros.
The VBA Programming Environment
| When to use Visual Basic for Applications instead of Macros |
| Visual Basic for Applications Development Environment |
Programming in the VBA Language Code Compilation
| Finding Bugs |
Error Handling in VBA
| Ignoring Errors |
| Trapping Errors |
| Writing Useful Error Handlers |
Class Modules and Form-Event Procedures
| Using Form Events |
| Code Behind Forms |
| Changing Form Properties |
| Creating New Form Instances |
Manipulating Data through Data Access Objects and SQL
| Data Access Objects (DAO) |
| Opening Databases Programmatically |
| Database and Recordset Objects |
| Manipulating Data with VBA Methods |
| Finding Records in a Recordset |
| Editing Data in a Recordset |
| Using Recordsets to Manipulate Imported Data |
| Creating, Using and Deleting Queries from VBA |
Changing Database Definitions through VBA
| Using SQL to Manipulate Databases |
If you have other questions, please contact us at
enquiry@it-uk.com or
complete
our response form |
