|
Access VBA Course
Not for the faint harted! This course will make your database all singing and dancing. With our Access VBA, you will learn to apply more advanced sql statements, VB routines and database administration automation using subroutines and functions.
After the course, you will be able to:
- Understand the VBA Environment
- Create Subroutines and Functions
- Understand all VBA Structures
- Apply DAO Model
Audience - You must be able to create and apply all database objects, understand macros and events. If you are not sure, please contact us
Course Duration - This is a 2 day Access VBA course
Course Dates - This course can run on any date you request
Course Versions - All versions from 97 to 2007
|
|
|
 Access VBA Course Content
VBA Dicussion
- What is it, and Why use it?
- The Environment
- Working with Modules
- Converting macros to vba modules
Coding Syntax
- VBA Syntax, Objects, Methods, Properties, Variables and Events
- Getting Help
Names Macros and AutoKeys
- Creating names macro groups
- Creating toolbars from names macros
- Assigning macros to key combinations
Control and Looping Structures
- Desicion Making Structures - If, Elseif, Select Case
- Looping Structures
Error Trapping and Debugging
- Breakpoints
- Stepping Code
- The Immediate Window
- Creating Error Traps
Data Access Objects
- The Workspace Session
- Manipulating Recordsets
- Creating Queries, Creating Tables
- Active X Controls
|
|
|
More Access Courses
Training Formats and Locations
- Onsite Training - We come to you
- Our London city based training center
- One to One - Dedicated to your needs
- Classroom - for groups up to 8
- All our courses are instructor led, and closed to you.
read more
Course Cost
- This course is charged at £595 per group of 8 per day
- One to One is charged at £450 per day
- All prices exxclude VAT
- No travel cost except outside M25
Why choose us?
- Experienced trainers
- Best rates for groups and One to One courses
- Most flexible cancellation terms
- Easy payment terms
- Simple pricing structure
- After course support by your trainer
- Free Training Needs Analysis
read more |
