ABN 76 104 620 484
 
 
 
 
Microsoft Office Courses | Soft Skills | Pricing
Contact Us
| Home | Trainer Profiles
   
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
  • On Your Own

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
  • On Your Own

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
Using Variables in 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.
RtB-logo-small