Floodlight uses cookies to ensure you get the best experience. Learn more GOT IT

> > >

Microsoft Access VBA (2 days)

Insight IT Training Limited

(5)

1 reviews
Reviews collected from IDP Connect

£792 PER DAY

What will I learn?

Price: the price opposite is a total per day, click on View Course for full price details

Benefits of Microsoft Access VBA Course

This Microsoft Access VBA course has been designed to give experienced Access users the skills they need to understand the basics of VBA Programming. The course is 100% hands-on, with exercises to practice the skills as you learn them.

Now that you are beyond the basics, you can dive right into our Microsoft Access VBA 2 day course. You will learn and understand procedures and functions, working with objects and record sets. We will cover topics such as using expressions, variables and intrinsic functions, debugging and error handling.

Course Content

Getting Started

  • Introduction to VBA
  • Recording & Running a Macro
  • Understanding the VB Editor
  • Using the Menu Bar
  • Using the Standard Toolbar
  • Editing Code
  • Using Help

Procedures and Functions

  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures & Using the Immediate Window
  • Creating a Function Procedure
  • Naming Procedures
  • Organising Code & Procedure
  • Working with the Code Editor

Understanding Objects

  • Understanding the Object Browser
  • Understanding Classes & Objects
  • Navigating the Object Hierarchy
  • Referencing Objects
  • Understanding Collections
  • Working with the Application Object
  • Understanding the Form Object
  • Working with Properties
  • Using the With Statement
  • Working with Methods
  • Understanding the DoCmd Object
  • Working with Events
  • Understanding the Order of Events

Using Expressions, Variables and Intrinsic Functions

  • Understanding Expressions & Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Working with Variable Lifetime
  • Considering Variable Scope & Lifetime Together
  • Using Intrinsic Functions
  • Understanding Constants
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes

Controlling Program Execution

  • Understanding Control-of-Flow Structures
  • Working with Boolean Expressions
  • Using the If..End If Decision Structures
  • Using the Select Case…End Select Structure
  • Using the For…Next Structure
  • Using the For Each…Next Structure
  • Using the Do… Loop Structure
  • Branching Structures

Working with Recordsets

  • Declaring & Creating Object Variables
  • Working with the ADODB Recordset Object
  • Specifying a Recordset Cursor Type
  • Looking Records for Updating
  • Specifying a Recordset Cursor Location
  • Using the Cache Size Property
  • Understanding Recordset Cursor Properties

Debugging

  • Understanding Errors
  • Debugging Code & Tools
  • Setting Breakpoints
  • Setting Break Expressions
  • Using Break Mode during Run Mode
  • Stepping through Code
  • Determining the Value of Expressions

Error Handling

  • VBA’s Error Trapping Options
  • Trapping Errors with the On Error Statement
  • Understanding the Err Object
  • Writing an Error-Handling Routine
  • Working with Inline Error Handling

What do I need to know?

Trainees should have attended the advanced Access course or have a good working knowledge of table creation, basic query and report writing functions and relational database concepts. No programming experience is needed.

Course info

closeIcon

Qualification Explained

No qualification

This means that the course doesn't come with any kind of qualification. You might do it for the experience or just to learn a skill

Certificate of attendance/completion/achievement (no assessment element)

This means you'll get a certificate at the end to prove you've completed the course. You won't have to do any exams, you'll just be given something to show you turned up and learnt something

Functional Skill

The Functional Skill qualification is awarded to people who have completed a course that shows them how to apply maths and/or English to real life situations. You will be assessed in order to achieve this

Basic skill

This essentially means you'll come away with a basic ability at literacy and numeracy. These qualifications and courses are often for adults who didn't reach a high enough level in these in school

Pre-apprenticeship at Level 1

Pre-apprenticeship courses are aimed at getting you ready to do an apprenticeship. If you hold one of these qualifications, it will help you take the next step when you're ready

NVQ Level 1 and relevant components

NVQ stands for National Vocational Qualification and will cover skills needed in a particular area of work. Level 1 NVQs teach the basics and will provide you with a starter to study more. They're equivalent to GCSEs grades D-G

SVQ Level 1 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ level one covers skills needed in a particular area of work. Level 1 SVQs teach the basics and will provide you with a starter to study more. They're equivalent to GCSEs grades D-G

Scottish National Qualification - Standard Grade

National Qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This level is the first and most basic level of National you can do

Scottish National Qualification - Access 3

National qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This level is the first and most next level up from the most basic level of National qualification you can do

Scottish National Qualification - Intermediate 1-2

National qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This is the 'intermediate' level of National you can do

GCSE or equivalent

GCSE stands for General Certificate of Secondary Education and sit at levels 1 and 2 on the QCF. This means they give you a grounding in a subject that will prepare you for further education or work

Welsh Baccalaureate Diploma

Delivered by course providers in Wales, this qualification is at the same level as GCSEs and often chosen as an alternative

Vocational related qualification (VRQ)

This term encompasses any qualification that you can achieve that will be focused on preparing you for a specific workplace

Young Apprenticeship/Apprenticeship at Level 2

Intermediate apprenticeships are the equivalent to GCSEs grades A* to C. They are workplace-based qualifications where you learn by doing (and get paid too!) and only spend a short time in college

First Certificate/Diploma

These qualifications, though usually based in a college or school, prepare you for the workplace by teaching you relevant practical skills alongside theory. They are equivalent to GCSEs

NVQ Level 2 and relevant components

NVQ stands for National Vocational Qualification and will cover skills needed in a particular area of work. Level 2 NVQs will require you have some knowledge in the subject and will take basic skills a little further. They're equivalent to GCSEs grades A*-C

SVQ Level 2 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ Level 2 build on the basics and will provide you with a starter to study more. They're equivalent to GCSEs grades A*-C

Advanced Apprenticeship at Level 3

Advanced apprenticeships are the equivalent to A Levels. They are workplace-based qualifications where you learn by doing (and get paid too!) and only spend a short time in college

GCE AS Level or equivalent

These are academic qualifications aimed at giving you higher expertise in certain subjects, preparing you for work or for further education

GCE A Level or equivalent

These are academic qualifications aimed at giving you higher expertise in certain subjects, preparing you for work or for further education

International Baccalaureate Diploma

This qualification is recognised worldwide and is equivalent to GCSEs. It covers a range of subjects

National Certificate/Diploma

These qualifications, though usually based in a college or school, prepare you for the workplace by teaching you relevant practical skills alongside theory. They are equivalent to A Levels

NVQ Level 3 and relevant components

NVQ stands for National Vocational Qualification and will cover skills needed in a particular area of work. Level 3 NVQs will require you have some knowledge in the subject and will take your learning to a higher level. They're equivalent to A Levels

SVQ Level 3 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ level one covers skills needed in a particular area of work. They're equivalent to A Levels

Scottish National Qualification - Higher

National Qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This is the 'higher' level of National qualification you can do

Scottish National Qualification - Advanced Higher

National Qualifications are based in Scotland and are taken by students in school and college, depending on the level. Like GCSEs in England, they cover a range of subjects and aim to prepare you for further education or work. This is the 'advanced higher' level of National qualification you can do

Access to Higher Education

This is a qualification aimed at preparing you for university if you don't have the traditional A Level/GCSE level of study. Usually focused on a specific subject it will get you ready to take a degree in that area on finishing

Foundation Art and Design

This qualification is aimed at getting you ready to take a degree in a creative subject. It is equivalent to a foundation degree

NVQ Level 4 and relevant components

NVQ Level 4 and relevant components

SVQ Level 4 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ level one covers skills needed in a particular area of work. Level 4 takes your learning to a much higher level. They're equivalent to undergraduate degrees

Higher Apprenticeship at Level 4

Higher apprenticeships are the equivalent to a foundation degree. They are workplace-based qualifications where you learn by doing (and get paid too!) and will only spend a short time in college

NVQ Level 5 and relevant components

NVQ stands for National Vocational Qualification and will cover skills needed in a particular area of work. Level 5 NVQs are usually for experienced managers in the workplace. They're equivalent to undergraduate degrees

SVQ Level 5 and relevant components

The same as an NVQ but for Scotland (stands for Scottish Vocational Qualification), the SVQ level one covers skills needed in a particular area of work. Level 5 SVQs take your learning to a much higher level - often for experienced managers. They're equivalent to undergraduate degrees

Nationally recognised qualification

This means the qualification you gain can be transferred to other locations in the UK and employers will be familiar with the level you've studied at

Professional or Industry Specific qualification

This term encompasses qualifications that you can use in the workplace of a particular industry. Usually awarded by professional and industry-based organisations, these qualifications will be familiar to employers in certain areas of work

Other External Awarded Qualification

This means the qualification is awarded by an external body. It may therefore include an assessed element

Course Provider Diploma/Certificate/Award (this must include an assessed element)

This means the qualification is awarded by the course provider but that you do get a real qualification at the end, it's just that they award it in-house. There will be an assessment to get this

Qualification

Certificate of Attendance/Completion/Achievement (no assessment element)

Study mode

Personalised

Level

Advanced

37 course options

Sort: Start date
Start date
Filter by: Location
Duration
Price

Who runs this course?

INSIGHT IT TRAINING

INSIGHT IT TRAINING

(5)

Insight IT Training provide high quality and flexible IT and Business Skills training courses (standard or tailored) and training solutions nationwide. We can come to you or you can come to us! We offer a different approach. By only providing private training we can work with you to deliver flexible, innovative and cost-effective training solutions in an easy and stress-free way. We will help you all the way from the initial enquiry through to delivery and, if needed, with post training support. We offer you great value because the training will be relevant to the trainee's needs and will meet their objectives by focusing on the topics that will be most relevant to their job roles. At the end of the training your staff will

Three things to check before you take a course
closeIcon

Three things to check before you take a course

Great! You've found a course. Still have a few questions? Here are the top three things you should ask the course provider before booking:

  1. What will I be able to do when I've completed the course?
  2. Do I need any previous experience or qualifications to take this course?
  3. Will I need any special equipment or clothing in order to complete it?

They'll also be able to help you with questions around payment plans, flexible learning, start dates and more.

Click the green 'GET COURSE INFO' button to get in touch with the them directly.

Other Access Software courses