Access VBA

Oak Tree Management & Training Ltd.
Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham, United Kingdom

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

Course Description:

'' This course is designed with the developer in mind. It focuses on the practical design and development issues relating to the production of bespoke systems. Access databases can be transformed into powerful, user friendly and safe applications. This course teaches not just the syntax of VBA for Access, but how to implement the language to get results. We emphasize the development of solutions can be easily modified to fit any database and how to program applications in a minimum of time.

Course Objectives
By the end of the course the delegate will be able to:

Plan and design robust systems
Build multi user applications
Design advanced queries, data entry forms and reports
Build secure applications
When to use VBA instead of macros
Course Contents
(Course Topics may vary at the Trainer’s Discretion)

Review of Macros
What is Visual Basic for Applications?
Introduction to the programming environment
Modules & Procedures
Creating & Opening a Module
Module Window Toolbar & Keys
Creating Functions & Procedures
Function & Sub statements
Event Procedures
Access Objects, Methods & Events
Applying Methods to & Opening Objects
Data Handling techniques
Objects & collections
Form & Field handling
Referencing Objects Literal, Syntax, Collection & Intrinsic
Defining Recordsets, Dynasets & Workspaces
Form, Report & Control Object Events & Properties
Application Initiated Events
Order of Events
Foreground & Background Processes
Variables
What is a variable?
Declaring Public, Private & Static Variables
Dimensioning Variables
Scope Statements
Data Type Conversion Functions
Object Variables
Data Access Object Model
DBEngine & Workspace Objects including ODBCDirect
Creating Database Object Variables including the OpenRecordset Method
Processing data using SQL commands Testing & Debugging Applications
Starting, Halting & Tracing Execution
Resolving Compile and Run-time Errors
Working with Breakpoints
Using the Debug Window
Error Handling & Trapping
On Error Statement & Err Object
Control Structures
IF…Then…Else statements
Select Case statements
For…Next loop statements
Do…Loop statements
While…Wend statement
With statement
For Each statement
Declaring & Calling DLL Routines
Security
Passwords
Wizard
Using MDE files
Replication overview
...''

Elements of this syllabus are subject to change.

Phone:(01284) 763040

School Address/Venue(s):

Park Farm Business Centre
Fornham St Genevieve
Bury St Edmunds
Suffolk
United Kingdom
IP28 6TS

Jobs & Resumes: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Houses & Roommates: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Travel Agencies: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Nottingham

Search other schools for Access VBA training resources.

Lift Truck Operator
IOSH Supervising Safely Certificate
Fire Marshals & Fire Risk Assessment
Fire Marshal and Practical Fire Extinguisher
Cranes & Lifting Operation
Confined Spaces
Health and Safety in Health and Social Care
Health & Safety in the Workplace
Access Foundation
Access Intermediate
Access Working with Queries
Acrobat
Illustrator CS
InDesign CS
PageMaker 7
Photoshop CS2
Crystal Reports - Advanced
Crystal Reports

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: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.