Microsoft Access
Part 3

Contact Us
Feed Back Form
E-Mail Us

Tel:
024 7637 2073

To return to the Microsoft Access Course Index please Click Here

A.K.Solutions: Microsoft Access Part 3 Course Content
Introduces VBA (Visual Basic for Applications).  Contains many examples of inserting VBA code behind forms and their controls to get Microsoft Access to do those things that seem impossible.  More on understanding Form Properties. Relating tables (Header , Detail) and getting to grips with Referential Integrity.   Main / Subforms / Totaling subform detail, plus Controls on forms.

• Validation expressions

  • More on validation expressions

  • Some limitations to field validations

• Introducing Visual Basic for Applications (VBA)

  • Using VBA to validate data

  • Why use VBA?  How easy is it to learn?

  • Writing some simple VBA procedures

  • Compiling and saving the VBA

  • Using command buttons on forms to execute VBA

  • Creating bespoke command buttons

  • Modifying table field values using VBA

  • Using VBA to validate data

  • The Before Update and After Update events

  • Using the Cancel argument of a Before Update event

  • Declaring and using variables in VBA (Dim/Private/Public)

• Header and Detail tables

  • Setting up a Main and Sub form for use with Header and Detail tables

  • More on relationships between tables, using referential integrity

  • Totaling detail records on a the Main Form

  • More on basic Form Design

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.

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

E-Mail Us

Contact Us
Feed Back Form

Tel:
024 7637 2073

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