VBA For Access Training

This VBA for Access training course is designed for experienced users of Access' advanced features, who wish to extend their knowledge to include the use of Visual Basic for Applications (VBA) within Access.

Prerequisites

This course is for those who possess and advanced understanding of Microsoft Access and are looking to expand their knowledge even further. Ideally, the delegate will have some knowledge of macros in relation to Office applications.


Course Objectives

After attending this VBA for Access course, delegates will be able to:

  • Use VBA for Access for advanced automation features
  • Write and understand Visual Basic code
  • Use VBA to manipulate and edit a database

Who is this course for?

This course is for those who possess and advanced understanding of Microsoft Access and are looking to expand their knowledge even further. Ideally, the delegate will have some knowledge of macros in relation to Office applications.

Where Code is stored

  • Standard modules
  • Class modules

Development Environment

  • Adding Code to a Form or Report
  • Types of Procedures
  • Entering Code

Running Code

  • Run mode and Design mode
  • Running Code from the development environment
  • Running Code from the host application

Reusing Code

  • Exporting a file
  • Importing a file

Using VB for Applications Using Variables

  • Lifetime and scope of variables
  • Using and writing sub-procedures
  • Using and writing Function procedure

Controlling Programme flow

  • Conditional structures
  • Looping structures
  • Trapping errors

Debugging

  • Using the break mode
  • Using the VB Editor debug features

Using Standard VB

  • Input Boxes
  • Message Boxes
  • Standard VB Functions
  • Functions in your Code

Access Object Module Forms and Form Events

  • Reports and Report Events
  • Creating a Workspace Using the Microsoft Jet Engine
  • Retrieving a Recordset
  • Navigating Records
  • Updating Records
  • Adding Records
  • Querying Data

Using VB

  • Using VB Objects, Methods and Properties to manipulate, read, edit and update data in a Database

Just a quick line to let you know how much Ilesh and myself gained from the excellent VBA course we recently attended at your offices. Your facilities are excellent and we were most impressed by the trainer's depth of knowledge and ability to restructure the course dynamically to ensure that we obtained the most relevant training. The two days were not only very informative but also good fun!

Alan Hill - GlaxoSmithKline

Keypoints

keypoints accredited

Duration:1 Day

VBA For Access Training Calendar

Filters

Select Your Course

Select Your Location

Select Delivery Method

VBA For Access Training

Sorry! Our team is updating this schedule!


----- OR -------

Please reach us at+44 20 4571 2395 or info@siliconbeachtraining.co.uk or for more information about the schedule

VBA For Access Training

Sorry! Our team is updating this schedule!


----- OR -------

Please reach us at+44 20 4571 2395 or info@siliconbeachtraining.co.uk or for more information about the schedule

VBA For Access Training

Complete the steps below to receive a quote or more information

Enter Your Details

What is your name?*
user
Course Name
course

How Many Employees Need Training?

Enter More Details

call
company
address
message

When Would You Like to Take the Course?

VBA For Access Training

Sorry! Our team is updating this schedule!


----- OR -------

Please reach us at+44 20 4571 2395 or info@siliconbeachtraining.co.uk or for more information about the schedule

meeting

Upcoming Dates

Onsite Training

Our Onsite/In-house Training method is most selected by organisations, as it allows them to train their employees at their choice of place. We can also tailor the course content to focus on your needs.

Leading Path to Success

step-1

Find a course and let us know how you would like to learn.

Step 1

step-2

Select your preferred method of training for the course.

Step 2

step-3

Confirm your seats.

Step 3

step-4

Get an excellent experience with our qualified instructors.

Step 4

step-5

Acquire skills and achieve your career goals.

Step 5

460+

Courses

92+

Locations

126K+

Learners

Some Facts Worth Shouting About

To win in this competitive world, you need to be constantly moving forward, and Silicon Beach Training is the one that can help you. Our courses are highly engaging as we have high-quality and certified training courses for both individuals and organisations that are structured in easy to digest modules. We don't compromise on the quality of our trainers. We have:

Our Clients

With extensive experience working with large organisations, national and local government, universities, charities, SMBs and individuals we believe that no client is too big or too small. This creates a diverse atmosphere on our scheduled courses with the opportunity to discuss solutions for a wide range of problems. We excel at developing bespoke training solutions for prestigious clients including EDF Energy, Sport England and Tesco PLC.

Banco Central Do Brasil

Nationwide Building Society

EDF Energy

EDF Energy

Sport England

Sport England

Tesco PLC

Tesco PLC

Imperial College London

Imperial College London

Request info Get Free Advice Quick Enquiry
LOADING