MS Access 2013 VBA Course Information
Duration: Two Days: 9am – 4:30pm Price: $800
| Software & Version | Course Length | August 2015 | September 2015 | October 2015 | November 2015 | December 2015 | Booking |
|---|---|---|---|---|---|---|---|
| Access VBA | 2 Days Course | – | 21 & 22 September | – | – | – | Book Course |
Course Booking
Target Audience & Purpose
Access VBA 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.
Course Inclusions
- Comprehensive learning materials incl. exercise files
- 12 months post course telephone support
- ‘Certificate of Attendance’
on completion of course - Morning & afternoon tea
Course Prerequisites
This course assumes a sound knowledge of the standard features of Access covered in the Introduction and Advanced courses.
MS Access 2013 VBA Course Content
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
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 And 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 and 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
Forrest Training
Roving one-on-one trainer
Microsoft Office Courses
- Windows 10 Training
- Computer Fundamentals Course
- Microsoft Access Training
- Microsoft Excel Training
- Microsoft Office Training Schedule
- Microsoft Office Upgrade Training
- Microsoft OneNote Training
- Microsoft Outlook Training
- Microsoft PowerPoint Training
- Microsoft Project Training
- Microsoft Publisher Training
- Microsoft Visio Training
- Microsoft Word Training
Microsoft Training & Certification
Desktop – Non Microsoft Courses
Professional Development Courses
- Business Etiquette Training
- Change Management Training
- Creative Problem Solving Training
- Customer Service Training
- Effective Business Writing Training
- Effective Communication Skills Training
- Leadership and Influence Training
- Management Fundamentals Training
- Negotiation Skills Training
- Presentation Skills Training – Presenting with Confidence
- Project Management Training
- Time Management Training