Access Programming using VBAAccess-VBA

Currently there are no scheduled dates

Available on demand, at time and place convenient to you, for groups of at least 3 participants.

exempt from VAT

Price: £ 990

refreshments included

computer station included

Categories: Databases and SQL, Access, VBA

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.

Duration

3 days

Agenda

  1. Introducing MS Access – Quick review of the basics
    • How it all works? Forms, Tables, Queries, Reports.
  2. Working with macros.
    • Recording a macro.
    • Running a macro.
    • Understanding events and event handlers.
  3. Introducing Visual Basic for Applications (VBA).
    • Data types. Variables. Operators.
    • Flow-control instructions. Conditional instructions. Loop instructions.
    • Procedures and Functions.
  4. Introduction to object-oriented programming.
    • Classes.
    • Objects.
    • Attributes, Methods, Events.
  5. Data manipulations in VBA.
    • Creating queries.
    • Transactions.
  6. Importing data from various sources.
  7. Error handling. Good practices.

For open training, the course materials are prepared for MS Office 2010. Other versions (2013, 2007, 2003) are available on request. Contact us for details.

Download as PDF

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.

There are currently no entries

Enter your e-mail address and we will notify you about future dates

Question?

Ask us anything about this training

* I hereby give my consent to the processing of my personal data by ALX Training Ltd. for the purpose of this request.