Access Programming Using VBA

by ALX Claim Listing

The course provides an introduction to programming in MS Access using Visual Basic for Applications (VBA). Students learn language syntax, discover how to automate tasks in Access, create custom functions and perform activities not easily available in any other way from Access.

£450

Contact the Institutes

Fill this form

Advertisement

ALX Logo

img Duration

3 Days

Course Details

The course provides an introduction to programming in MS Access using Visual Basic for Applications (VBA). Students learn language syntax, discover how to automate tasks in Access, create custom functions and perform activities not easily available in any other way from Access.

 

Agenda

  • Introducing MS Access – Quick review of the basics

    • How it all works? Forms, Tables, Queries, Reports.

  • Working with macros.

    • Recording a macro.

    • Running a macro.

    • Understanding events and event handlers.

  • Introducing Visual Basic for Applications (VBA).

    • Data types. Variables. Operators.

    • Flow-control instructions. Conditional instructions. Loop instructions.

    • Procedures and Functions.

  • Introduction to object-oriented programming.

    • Classes.

    • Objects.

    • Attributes, Methods, Events.

  • Data manipulations in VBA.

    • Creating queries.

    • Transactions.

  • Importing data from various sources.

  • Error handling. Good practices.

 

Audience And Prerequisites

The course is intended for experienced Access users who feel that standard functions and features of program are insufficient for their needs.

Before attending this course, students must have:

  • An intermediate level of experience in using Microsoft Access 2007.

  • Basic knowledge of SQL language is useful, but not necessary.

No prior programming experience is necessary.

 

Certificates

Course participants receive completion certificates signed by ALX.

  • London Branch

    1 Long Lane, London

Check out more Visual Basic courses in UK

Futuretech Info Vision Limited Logo

Web Developer Specialist (IT Training Bundle 8)

This course covers the essentials of programming and coding side of web site production and design. It includes Hypertext Markup Language (HTML), Cascading Style Sheets (CSS), JavaScript, PHP, Drupal and MySQL.

by Futuretech Info Vision Limited
  • Price
  • Start Date
  • Duration
NILC Training Logo

React Web Development

React is a popular client-side development library from Facebook. React makes it easy to create reusable components and render them in a web page or in a native mobile application.

by NILC Training [Claim Listing ]
Verhoef Training Logo

Visual Basic Programming

This introductory course is designed for those who wish to use Visual Basic and the .NET Framework to create applications and utilities.

by Verhoef Training [Claim Listing ]
City Lit Logo

Web Development

Our web development short courses are designed for both beginners and more experienced learners. Whether you're about to take your first steps in the world of web design or just want to learn how to update a company website,

by City Lit [Claim Listing ]
CCW Training Academy Logo

Web Development Training

CCW Offer a variety of Web Development courses that cover everything that is required for new developers of websites and web services. With web services becoming essential for organisations of all kinds and varieties, there is high demand for these services.

by CCW Training Academy [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy