Microsoft Access 2007 VBA Training

This Microsoft Access VBA 2007 training courses is designed for delegates planning to create and support customised databases in a business environment.

Prerequitites: This course requires a sound working knowledge of Access including creating tables, queries, forms, reports and relationships. No previous programming experience is necessary. According to the audience’s abilities and requirements the course will be tailored at the trainer’s discretion.

This 2-day Microsoft Access 2007 VBA training course covers the following areas:

Introduction
- VBA v Macros
- Converting Macros to Modules
- Button Wizard

Visual Basic Editor
- Overview of Menus and Toolbars
- Project Explorer
- Local, Immediate and Watch Windows
- Short cuts
- Object explorer

Programming Basics
- Objects, Properties and Methods
- Comments
- Code Layout
- Location of Code

Programming Structures
- Sub and Function Statements
- Decision Code
- If Statements
- Select Case Statement Loops - Do; For; For Each
- With Statement
- Msgbox and Inputbox

Variables
- Types of Variables
- Using Parameters
- Variable Lifetime and Scope

Working With Forms
- Referring to Form Controls
- Form and Control Events
- Controlling Controls

Accessing Data
- Using SQL statements
- Using ActiveX Data Objects (ado) to work with other data sets

Error Handling
- Trapping Errors
- Err Objec
- Debugging Techniques

Development Process
- Modular Code
- Flow Control
- Test Plans
- Gold Plating

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable.

On successful completion of this Microsoft Access 2007 VBA training course delegates will be
able to use VBA to custom build applications.

Please request information to find out the cost of this Microsoft Access 2007 VBA training course.

Enliten IT provides a wide range of information technology training

• IT Training (End user, Technical, Developer)
• Development (Databases, Web sites, Templates)
• Soft Skills Training
• Consultancy

Enliten IT is a vendor independent IT training services business. Enliten IT have over 23 years of experience in delivering training on Microsoft, Adobe, Oracle, IBM/Lotus, Quark, AutoDesk, Corel, Business Objects and other vendor’s software packages. Enliten IT has trained customers throughout the UK, in Switzerland and Hong Kong.

Enliten IT specialise in a flexible training approach, offering customised solutions, as we recognise that staff training and skills development are fundamental to the growth and development of businesses. Our tailored training programmes are clearly designed, relevant and focused to meet the specific needs of our customers.

In House Training anywhere in the UK with our Mobile Classroom

Enliten IT provide In House / On site training courses, that can be completely customised to your organisation, and are delivered on your site, in your working organisation. Additionally Enliten IT has invested in creating a mobile classroom that is proving to be a flexible and effective training solution for companies all over the UK. Transform your conference/meeting rooms into a classroom in a matter of minutes and be more productive by investing in your staff skills. Our mobile classroom of laptops means that training can be delivered on-site anywhere in the UK, and is an extremely cost-effective way of meeting a training need.

Starting with a Training Needs Analysis designed to target training with pinpoint accuracy, we will transfer the knowledge and skills required by your staff to help them perform their jobs more effectively.

Trainers that are all members of the Institute of IT Training (IITT)

Enliten IT pride themselves in providing quality value for money solutions.All Enliten IT trainers are members of the Institute of IT Training (IITT) - the main standards body for IT Trainers in the UK covering all aspects of training, development and delivery. You can be aassured your training will be quality as Enliten use only the best trainers and consultants, who are not only technically adept within their areas of expertise, but  are also versed in educational methodologies thereby ensuring your staff get the most out of their training experience.

Find our more about Enliten IT and how they can provide you and your organisation with specialist IT training courses here.