Provided by: Mullan Training

VB Access

Click here for more information or to take this course

home : Computer

Get More Information

Search for Training

Find Your Genius!

Training Provided by Mullan Training

This 2 day course is suitable for Advanced users of Microsoft Access responsible for managing very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.

PREREQUISITES

A high proficiency of Microsoft Access is essential, or completion of our Advanced MS Access course.

BENEFITS

At the end of the course the delegate will have covered the fundamentals of VBA, including:
working with procedures and functions
understanding objects
using expressions, variables and intrinsic functions.
mastering how to control program execution
working with forms and controls
working with the PivotTable object.
Debugging code
handling errors to ensure minimal downtime while building and effecting the program.

COURSE CONTENT

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

LOCATIONS

Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we can provide 8 laptops, projector & flipcharts).

ADDITIONAL INFORMATION

If you would like more information please do not hesitate to contact us.

For a course outline visit our website
www.mullantraining.com
or email us at
info@mullantraining.com
or telephone
0289032 2228

Training Avaliability and Delivery

This is primarily ilt training
	Computer Lab Work
	This class may involve group study
	Courseware may be available for purchase
	This class may be available at a classroom in Belfast, Co Antrim, or at one of these training facilities: Belfast, Antrim
	Contact Mullan Training for more information

Course Level:	introductory
Schedule:	2 days
Training Presented in:	English

Related Keywords: computer course vba training belfast northern ireland

Training Program Details

About Mullan Training - Training Provider

Mullan Training - Mullan Training are a computer training company in Belfast city centre. We can deliver computer training courses in our training suites OR in your own offices. We are an authorised Microsoft Office Specialist (MOS) Testing Centre so delegates can prepare for & sit exams with us. Courses we deliver include: - Microsoft Windows (inc Vista) - Microsoft Office (inc 2007) - Adobe (inc CS3) -...

More Training from Mullan Training

Click here for more information or to take this course

Custom Search

Training Directory \| New Training Seminars \| New Training Providers \| Search \| Site Map \| Promote Training \| Login \| Links

	Training-Classes.com by Skillbox® 07/19/08 Copyright 1998-2008 skillbox, inc. All rights reserved

Are you a Computer training provider?

You could be on this page today - for FREE!