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

Stay Ahead Logo

Web Development 1 with HTML, CSS and JavaScript

The Web Development 1 with HTML, CSS and JavaScript course comprises sessions dealing with HTML, CSS and JavaScript - the three core languages of web development.

by Stay Ahead [Claim Listing ]
Elite Training Logo

M20486 – Developing ASP.NET Core MVC Web Applications

In this 5-day course, the professional web developers will learn to develop advanced ASP.NET Core MVC applications using .NET Core tools and technologies.

by Elite Training [Claim Listing ]
  • Price
  • Start Date
  • Duration
New Horizons Birmingham Logo

Adobe Dreamweaver CC - Part 1

In this course, you will learn to maintain and administer your website with Dreamweaver’s site and page management tools.

by New Horizons Birmingham [Claim Listing ]
IT Professional Training Logo

Web Application Development (Full Stack Developer)

This Web application Development course is quite comprehensive and suitable for you even if you have zero programming experience, this course will take you from beginner to mastery.

by IT Professional Training [Claim Listing ]
Ace Design and Education Logo

HTML & CSS

Learn how to code your site from scratch with HTML & CSS. You'll be learn the building blocks of web development and experience the accomplishment that comes of turning code into a beautifully designed site!

by Ace Design and Education [Claim Listing ]

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