This two-day course is intended for Microsoft Access users who wish to develop personal applications with the help of Visual Basic.

Delegates must be proficient in the use of Access. Previous programming experience is not necessary although some experience of the use of macros and events within Access will be an advantage.

Click here for a printable version of Access Visual Basic Course Outline:

Course Content:

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.