Training at Blue Novation

 

 

Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.

Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.

Access VBA Introduction

This customised workshop is designed to give advanced users of Microsoft Access a solid grounding in the use of Microsoft Visual Basic to automate and enhance their Access applications.

Course Topics

Introduction

modules • objects • properties • procedures • events

Basics

adding a module • creating/running a procedure • stepping through a procedure

User Defined Functions

creating functions • using functions

Variables

data types • local vs public • manipulating strings • symbolic constants

Control Structures

if…then • select case • for…next • do…loop • nesting controls

Dialog Boxes

message boxes • using forms as custom dialog boxes

Handling Events

mouse events • keyboard events • data events • focus events • errors and timings • default events

User Interface

creating a main form • creating navigation forms • customising menus • customising toolbars

Testing & Debugging

the immediate window • setting break points • running selected portions of code • using the calls dialog box

Communicating with Other Applications

linking with Excel and Word

 

 

 

 

Course Dates

Course Dates

On Request

Course Duration

Customised Workshop (1 or 2 days)

Course Timings

9:30-16:30

Location

Ipswich

Prerequisites

A thorough knowledge of Access is essential: however, no knowledge of Visual Basic for Applications is needed.

Training Formats

Private course · tailored · 1 to 1 (instructor led)

Not found the course you are looking for?

 

We can create a tailored workshop to suit your
specific business requirements. Get in touch to find out more.

BlueNovation_logo_WA

 

 

Address: Contact us on:
NG7 Columba House, Adastral Park, 0345 11 88 150Call now
Martlesham Heath, Ipswich, IP5 3RE Email us[email protected]