Access - vba
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
define event driven programming. identify and manipulate objects and collections. declare and use variables and understand their scope. implement control structures such as if.then and for.next to control program flow. use data access objects to view and manage data. debug code and trap errors
Facilities
Location
Start date
Start date
Reviews
Course programme
after completing this course, participants will be able to:
- define event driven programming
- identify and manipulate objects and collections
- declare and use variables and understand their scope
- implement control structures such as if.then and for.next to control program flow
- use data access objects to view and manage data
- debug code and trap errors
- reasons for using access vba-event driven programming; code in modules and behind forms and reports; sub procedures and function procedures ;
- code creation-creating simple code; declaring and using variables; understanding the scope and life time of variables; using operators in code; string manipulation; using macro actions in code
- control structures-creating if.then.elseif blocks; creating select.case statements; using do.until and do.while loops; using for.next loops
- objects and collections-understanding the object hierarchy, collections and objects; using object properties and methods;understanding data access objects; declaring and setting object variables; using recordsets for reading and editing
- debugging code-suspending execution and stepping through code; using the immediate window; error handling code
- automation-creating automation objects; accessing linking and embedding objects.
Access - vba