Access 2003 VBA Basic

Raising the Bar
Sydney, NSW, 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

Macro Overview
Creating Macros
Assigning Macros
Creating More Complex Macros
Converting Macros To VBA Code
Macros Versus VBA
Macros and VBA Quick Reference

VBA Essentials

Programming Environment Overview
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

Understanding Modules In Access
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

Overview Of Variables
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

The Act Of Communicating
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
Decisions Overview
Creating An In-Line If
Creating A Block If
Multiple If
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:(02) 9929-8845

School Address:

Suite 501, Level 5
65 Walker St
North Sydney NSW 2060


Jobs & Resumes: Sydney
Houses & Roommates: Sydney
Travel Agencies: Sydney

Search other schools for Access 2003 VBA Basic training resources.

Access 2003 Basic
Access 2003 Intermediate
Access 2003 Advanced
Excel 2003 VBA Basic
Excel 2003 Advanced
Excel 2003 Intermediate
Excel 2003 Basic

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: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.