Access - Programming in VBA 2000/2002

Drake Training
Adelaide, Brisbane, Canberra, Melbourne, Perth, Sydney, Australia

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

Course Description:

'' Development Basics
The Access Development Environment
The Importance of Splitting Databases
Maintaining Links
Using the Database Splitter
Using Queries For Reports And Forms
Access Run-Time
Understanding Client/Server
Development Basics Quick Reference

Macros And VBA
Creating Macros
Assigning Macros
Creating More Complex Macros
Converting Macros To VBA Code
Why You Shouldn’t Use Macros
Macros and VBA Quick Reference

VBA Essentials
The Role of Forms
Creating a Startup Form
Understanding Modules
Code Behind Forms
Standard Code Modules
Standard Vs Class Modules
Naming Conventions
VBA Essentials Quick Reference

VBA Subroutines
The Anatomy of a Module
Creating a Subroutine
Creating a Function
Calling Procedures
Passing Parameters
Returning Values
Scoping Procedures
VBA Subroutines Quick Reference

Variable VBA
Creating String Variables Option Explicit
Working with Numbers
Dealing with Overflows
Working with Decimals
Working with Dates
Default Values
Scoping Variables
Local Variables
Module-Wide Variables
Passing Parameters
Passing Parameters By Value
Variable VBA Quick Reference

Interactive VBA
Creating a Simple Input Box
Creating More Elaborate Input Boxes
Global Positioning
Simple Message Boxes
Creating Larger Messages
Breaking a Message Line
Customising Icons and Buttons
Message Box Functions
Responding To Different Buttons
Interactive VBA Quick Reference

Decisive VBA
Creating an In-Line If
Creating a Block If
Multiple If

Decisive VBA - Continued
Multiple If Using Text
Using Case Statements
Value Ranges in Case Statements
Case Statements with OR
Asking Yes/No Questions
Decisive VBA Quick Reference

Looping VBA
Program Loops
Creating a While Loop
Taking Care of Counters
Creating an Until Loop
For Each Loops
Exiting from Loops
For Next Loops
Looping VBA Quick Reference

The DoCmd Object
Overview of DoCmd
Navigating with DoCmd
Moving Through Records
Filtering Records with DoCmd
Opening a Form with DoCmd
Opening a Report with DoCmd
Closing a Form
Creating Variable Reports
The DoCMD Object Quick Reference

ActiveX Data Objects - Tables
Overview of ADO
Setting References Using VBA
Creating a Table with ADO
Removing a Table Using ADO
Populating a Form Using ADO
Dealing with an Empty Table
ActiveX Data Objects Quick Reference

ADO Forms & Recordsets
Overview of ADO with Forms & Recordsets
Navigating Records in a Form
Finding a Record
Updating a Record
Deleting a Record
Adding a New Record
ADO Forms & Recordsets Quick Reference

Debugging VBA
Overview of Debugging
Setting a BreakPoint
Setting Additional Breakpoints
Stepping Through a Procedure
Viewing the Call Stack
Using the Locals And Immediate Windows
Adding a Watch
Deleting a Watch
Debugging VBA Quick Reference

Handling Errors in VBA
Error Handling Overview
Understanding Common Errors
Creating a Simple Error Handler
Understanding the Error Object Model
More Elegant Error Handling
Resuming from Errors
Forcing an Error
Creating Custom Errors
Handling Errors Quick Reference ...''

Phone:1300 362 262

School Address:

Level 40, 55 Collins Street
Melbourne VIC 3000, Australia



Jobs & Resumes: Adelaide, Brisbane, Canberra, Melbourne, Perth, Sydney
Houses & Roommates: Adelaide, Brisbane, Canberra, Melbourne, Perth, Sydney

Time Management
Turning Difficult Customers Into Loyal Customers
Accelerated Six Sigma Black Belt
Business Writing
Coaching Skills for Managers
Powerful Presentations
Conflict Resolution
Influencing and Negotiating
Lead, Manage and Develop Teams
Train the Trainer
Access Level 1
Access Level 2
Acrobat
Illustrator
InDesign
Photoshop
Excel - Programming in VBA 2000/2002
Microsoft Excel Level 1
Microsoft Excel Level 2

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.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!