COURSE FINDER

Access VBA Macros (Visual Basic for Applications)

£700 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 2 days

Trainer: S047OW

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Introduction

Access supports two different programming languages:

- The painting-by-numbers macros, which you can use to perform basic functions;
- The far more powerful VBA (Visual Basic for Applicatons) programming language.

If you're going to be using Access, we think you should be learning VBA - it's far more powerful, and is compatible with the programming languages used by other MS Office applications such as Excel and Word. On this two-day course you'll learn about the DoCmd object, variables, handling form events, linking to recordsets and much more!

Prerequisites

Delegates should only attend this course if they have a good working knowledge of Access basics, and if they are proficient computer users. Experience of programming, while useful, is not essential.

Course Contents

The VBA code editor

- Two ways to create modules
- Using Project Explorer
- Basic subroutines and comments

Messages and variables 

- The all-powerful DoCmd object
- Displaying messages
- Getting input from users
- Using variables

Creating functions

- Passing arguments
- Returning values

Visual Basic explained

- Objects and collections
- Methods and properties
- The Access object model
- Getting help in VBA

Attaching code to forms
 
- Attaching code to buttons
- Attaching code to events
- Making code not form-specific
- Manipulating form/control properties

Looping 

- The four types of loop
- Looping over all open forms
- Looping over controls
- Looping over Access Objects

Recordsets 

- Choosing ADO or DAO
- Adding data
- Editing data
- Deleting data

Debugging and error handling

- Stepping through macros
- Setting breakpoints
- Trapping for errors

Case studies
 
- Navigation buttons
- Creating a simple menu
- Validating forms
- Criteria forms

Linking to Excel and Word (*)
 
- Referencing other applications
- Manipulating Excel from Access

Modifying queries (*)
 
- Basic SQL statements
- Amending queries' SQL

Please note that any items marked with a * will be covered if time allows.

Course Times

Usually 9.30am - 4.30pm. Course times will be confirmed in the joining instructions once the course has been booked.
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
  • Corps Construct Logo
  • Safety & Health Logo
  • Hawks Logo
  • Know How Logo
  • SYNERGIETRAINING Logo
  • Induct Ltd Logo
  • Ace Safety Logo
  • 1UPACCESS Logo
  • BAM Construction Training Logo
  • Citrus Training Logo
  • 3B Training Logo
  • Astutis Logo
  • Construction Industry Training Providers Logo
  • Health Life and Safety Logo
  • MI Construction Training Logo
  • Innov8 Training Logo
  • BSI Training Logo
  • OM Safety Training Logo
  • TotalComms Training Logo
  • SDA Safety Logo
  • Construction Skills People Logo
  • Phoenix Health and Safety Logo
  • Harris Safety Training Logo
  • First Response Training Logo
  • Alliance Learning Logo
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Global Management Academy Logo
  • Illumine Logo
  • CCAS Health and Safety Logo
  • ROSPA Logo
  • PJH Safety Training Logo
  • OMS Logo
  • Tala Training Logo
  • PRS Health and Safety Training
  • SSG Training and Consultancy Logo
  • RB Services Logo
  • Safety Training Services Logo
  • Clarkson Evans Training Logo
  • Lighthouse Training Logo
  • The Building Safety Group Logo
  • ProSafety Logo
  • Total Training Solutions Logo
  • Kentec Training Logo
  • Total Electrical Training logo
  • NTSS logo
  • Frinton Training logo
  • Envesca logo
  • The Safety Maintenance Company logo
  • APT Health and Safety logo
  • Sandwell Training Association logo
  • PC Workshops logo
  • Zero Harm Training logo
  • R2 Training logo
  • The Bradley Group logo
  • Risk Health and Safety logo
  • Wise Global Training logo
  • Total Training Company Logo
  • Sibbald Training logo
  • Total Construction Training logo
  • UTN Training logo
  • Collective Safety Solutions logo
Telephone Hotline (footer image)

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

© 2020 Book My Course Limited. All rights reserved

Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy