Click Here for Course Booking Information or Call us on             0845 257 9950

 

 

  Inspire - Inform - Improve  

Microsoft Access

Visual Basics

Where Code is Stored

  • Standard Modules
  • Class Modules

Development Environment

  • Adding Code to a Form or Report
  • Types of Procedures
  • Entering Code

Running Code

  • Run mode and design mode
  • Running code from the development environment
  • Running Code from the host application

Reusing Code

  • Exporting a File
  • Importing a file

Using Visual basic for Applications

  • Using Variables
  • Lifetime and scope of variables
  • Using and writing sub procedures
  • Using and writing Function Procedures.

Controlling Programme flow

  • Conditional Structures
  • Looping Structures
  • Trapping Errors

Debugging

  • Using the break mode
  • Using the debug features of the VB editor

Using Standard Visual Basic functions in your code

  • Input Boxes
  • Message Boxes
  • Standard Visual Basic Functions

Access Object Module

  • Forms and form events
  • Reports and report events
  • Creating a Workspace using the Microsoft Jet Engine
  • Retrieving a recordset
  • Navigating records

Updating records

  • Adding Records
  • Querying Data

Using VB Objects, Methods and properties to manipulate, read, edit and update data in a Database