Microsoft Access
Visual Basic

Contact Us
Feed Back Form
E-Mail Us

Tel:
024 7637 2073

Home Page

To return to the Microsoft Access Course Index please Click Here

A.K.Solutions: Visual Basic behind Microsoft Access Course Content
This 2 day course expands on the knowledge gained in Part 3.   No previous programming knowledge is required as all is explained.  Enhance your Microsoft Access databases with the functions and procedures you will learn on this course.

  • The basics

    • Declaring variables, Mathematical operators, Formula, Constants

    • Comments, Indenting code

    • Use of Option Explicit

  • Modules

    • Class Modules

    • Standard Modules

  • The Visual Basic Editor

    • Tour of the VBE window

    • Project Explorer, Properties

    • Code window

    • Immediate window

  • Obtaining Input from User

    • Using Message Box and Input Box functions

    • Validating input

    • Preventing data mismatch errors

  • Compiling and Saving

    • Compile on demand, Background compile

    • Customising the toolbar to include compile button

    • Testing code

  • Use of Variables in procedures

    • Global variables

    • Private variables

    • Static variables

  • Events

    • Using events in Forms

    • Validating fields with VBA

    • Before Update / After update and Exit events

    • Canceling events

  • Form controls

    • Enabling, Disabling controls using VBA

    • Handing control to other controls on a form

    • Bound versus unbound controls

  • Getting help in VBA

  • Creating functions

    • Declaring functions

    • Passing arguments

    • Local variables

  • Writing code

    • Loops

    • Using strings

    • Use of the Me. object in Class modules

    • Testing code in the immediate window

  • Error Trapping

    • Debugging code

    • The Locals Window

    • Setting a Break point in your code

    • Using mouse hover

    • Clearing break points

    • Running the code

You may print this page by selecting File Print in your Browser Window

Before taking this course.
All candidates are advised to have a good working knowledge of Microsoft Access.

See Access Part 3 which introduces VBA.

To contact A.K.Solutions:- enquiries@aksolutions.co.uk

Go_Top

E-Mail Us

Contact Us
Feed Back Form

Tel:
024 7637 2073

Home Page

Copyright © 1994 - 2006 A.K.Solutions. All rights reserved.   Revised: January 13, 2006.