Access VBA Level 1
Course Outline

DURATION 1 Day

NOTE: This is the first day of a 2-day course
PREREQUISITES

A sound knowledge of Windows and MS Access including, table creation, query and report writing functions, macro development and relational database concepts gained from practical experience or by prior attendance on an "Access Advanced User" course is essential.

INTENDED FOR

Those requiring a good understanding of the features available in the MS Access VBA language. The course can be attended as tow separate days.

DESCRIPTION

This course has been designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access.  The course is aimed at those with little or no previous programming background, although experienced programmers wishing to learn VBA will find it a quick and valuable introduction to the language.  Throughout the course the theme of adopting good programming practices will be encouraged and advice will be given on planning applications systematically, efficiently and economically.  The techniques covered are typical of those encountered in a business database application; focusing in particular on triggering VBA from objects such as queries and forms.

COURSE DATES Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekday Tue, 7-Feb-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 25-Feb-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 5-Mar-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 26-Mar-12 and Tue, 27-Mar-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 3-Apr-12 09:30 - 16:30 £180.00 +VAT
Weekend Sat, 28-Apr-12 10:00 - 16:30 £200.00 +VAT
Weekday Fri, 25-May-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 26-May-12 10:00 - 16:30 £200.00 +VAT
Weekday Thu, 7-Jun-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 25-Jun-12 and Tue, 26-Jun-12 18:30 - 21:30 £200.00 +VAT
Weekday Wed, 4-Jul-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 28-Jul-12 10:00 - 16:30 £200.00 +VAT
Weekend Sat, 25-Aug-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 27-Aug-12 09:30 - 16:30 £200.00 +VAT
Weekday Fri, 14-Sep-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 24-Sep-12 and Tue, 25-Sep-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 25-Oct-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 27-Oct-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 5-Nov-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 5-Nov-12 and Tue, 6-Nov-12 18:30 - 21:30 £200.00 +VAT
Weekday Fri, 7-Dec-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 26-Dec-12 and Thu, 27-Dec-12 18:30 - 21:30 £200.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable
09:30 - 16:30 £400.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

 

 

An Introduction to VBA

  • Macros versus Visual Basic for Applications

Visual Basic for Applications Development Environment

  • VBA Objects and the Browser

  • VBA Procedures

VBA Language, Syntax and Code Compilation

  • VBA Coding

  • Variables and expressions

  • Branching and Looping

  • Comments and Indents

Deciding on Code location

  • Public Modules

  • Private Modules

  • Writing your Functions

  • Using functions in Queries and Forms

Form-Event Procedures

  • Using Form Events

  • Code Behind Forms

  • Changing Form Properties

 

 




Home | Contact | Terms and Conditions