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

Academy Class Logo

Php And MySQL (Beginner)

Upon successful completion of this course, students will have proficient knowledge of Php And MySQL. Our PHP And MySQL certification training online can be done live, online or in class.

by Academy Class [Claim Listing ]
Silicon Beach Training Logo

WordPress Custom Themes Training

WordPress Custom Themes Training is a practical course delivered in the style of a workshop. The web design training course teaches candidates how to customise and integrate their own design ideas using WordPress.

by Silicon Beach Training [Claim Listing ]
Computeraid Ltd Logo

Adobe Animate

Our Adobe certified training team will take you through the journey of understanding the Animate environment, through to using basic animation, layer control, effects and more. You’ll leave the course with the experience and know-how to create professional looking animations for different intents...

by Computeraid Ltd [Claim Listing ]
EQV (UK) Ltd Training Logo

Microsoft Visual Basic for Excel – VBA

The use of Visual Basic in Excel unlocks the true power of this application. Create powerful yet user friendly applications that will be capable of running critical business processes.

by EQV (UK) Ltd Training [Claim Listing ]
Xchange Training Logo

WordPress Training

If you are a looking to expand your skills to create great looking websites or blogs we have the WordPress course to suit you!

by Xchange Training [Claim Listing ]

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