Access Visual Basic for Applications

Symmons Madge Associates Ltd.
Belfast, Birmingham, Bristol, Cardiff, Dublin, Exeter, Glasgow, Slough, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' This intensive course is designed to introduce new Microsoft Access programmers to features and facilities of the VBA programming language; to encourage confidence, control and creative use of Microsoft Access by taking a structured look at VBA within desktop database environment; to help developers plan their applications systematically, efficiently and economically; to promote good design and to demonstrate different development techniques.

Course Outline:
The VBA Programming Environment

When to Use VBA Instead of Macros
VBA’s Development Environment
The Programming Environment
The Object Browser
Creating Procedures Programming in the VBA Language

Coding in Visual Basic for Applications
Using Variables and Expressions
Branching and Looping Commands
Indenting Code
Branching Commands
Using Arrays and Collections
Typing in Code
Optional and Named Arguments
Passing Arrays as Arguments
Code Compilation
Finding Bugs
Types of Error
Debugging Code
Error Handling in VBA

Ignoring Errors
Trapping Errors
Writing Useful Error Handlers
Logging Errors
Manipulating Data with DAO and SQL

Data Access Objects (DAO); DAO Hierarchy
Working with Objects and Collections
Opening Databases Programmatically
Database and Recordset Objects
Dynasets; Snapshots
Manipulating Data with VBA Methods
Finding Records in a Recordset
Editing Data in a Recordset
Transaction Processing Commands
Using Recordsets to Manipulate Imported Data
Creating, Using, and Deleting Queries from VBA
Changing Database Definitions through VBA
Using SQL to Manipulate Databases
SQL Data Modification Statements
Methods of Running SQL from VBA Code
Class Modules and Form-Event Procedures

Class Modules· Using a Class’s Properties and Methods
The PDM Example: Time Managing Multiple Projects
Using Form Events
Access Form Events and Properties
Code Behind Forms; Changing Form Properties
Soft Validation; Creating Validation Event Procedures
Value Derivation; Creating New Form Instances
Tying Forms/Reports Together
Using Form Class Modules ...''

Elements of this syllabus are subject to change.

Phone:01446 775959

School Address/Venue(s):

Vale Forge
North Road
Cowbridge
Vale of Glamorgan
CF71 7DF
United Kingdom

Jobs & Resumes: Belfast, Birmingham, Bristol, Cardiff, Dublin, Exeter, Glasgow, Slough
Houses & Roommates: Belfast, Birmingham, Bristol, Cardiff, Dublin, Exeter, Glasgow, Slough
Travel Agencies: Belfast, Birmingham, Bristol, Dublin,

Search other schools for Access Visual Basic for Applications training resources.

Management of Subcontractors
PPC 2000 Partnering Contract
The JCT 2005 Contracts
Building Conservation Thinking
HECRAS
Lotus Notes
Project
Access
Excel
PowerPoint
Visual Basic 6
Buildability
Concrete Technology and Construction for Engineers
Design and Construction of Minipiles
Construction Materials
Lean Construction

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.