MS Access VBA Course Outline
COURSE INFORMATION
Duration: Two Days: 9am - 4:30pm
Price: $780
Book: Enquire or make a course booking
TARGET AUDIENCE & PURPOSE
This Access VBA Course is for highly skilled developers who wish to add high end automation.
OBJECTIVES
By the end of this course participants should be able to:
- Create and assign macros
- Understand the advantages and disadvantages of using macros
- Use forms and modules in the VBA editor
- Create and work with subroutines and functions
- Create and work with variables
- Communicate with the user through input boxes and message boxes
- Program decision structures using IF and CASE statements
- Develop a variety of programming loops for repeating operations
- Use the DoCmd object
- Use ADO to handle working with data in your programs
- Use the debugging features of VBA to locate and identify errors
- Develop error-handling routines to prevent errors.
PREREQUISITES
This course assumes a sound knowledge of the standard features of Access covered in the Introduction and Advanced courses.
COURSE CONTENT
| Development Basics The Access Development, Environment, The Importance Of Splitting, Databases, Maintaining Links, Using The Database Splitter, Using Queries For Reports & Forms, Access Run-Time, Understanding Client / Server Macros & VBA Macro Overview, Creating Macros, Assigning Macros, Creating More Complex Macros, Converting Macros To VBA Code, Why You Shouldn't Use Macros 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 Subroutines Understanding Modules In Access, The Anatomy Of A Module, Creating A Subroutine, Creating A Function, Calling Procedures, Passing Parameters, Returning Values, Scoping Procedures 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 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 & Buttons, Message Box Functions, Responding To Different Buttons |
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 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 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 ActiveX Data Objects - Tables ADO Overview, Setting References Using VBA, Create & Remove a Table with ADO, Populate a Form using ADO, Dealing with an Empty Table ADO Forms & Recordsets Overview of ADO With Forms & Recordsets, Navigating Records in a Form, Adding, Finding, Updating and Deleting a Record Debugging VBA Debugging Overview, 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 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 |