www.onlc.com
Open in
urlscan Pro
2606:4700:3108::ac42:286d
Public Scan
URL:
https://www.onlc.com/outline.asp?ccode=WACP16&utm_campaign=RR&utm_medium=EB&utm_source=202305
Submission: On April 12 via api from US — Scanned from DE
Submission: On April 12 via api from US — Scanned from DE
Form analysis 8 forms found in the DOM
<form class="navbar-form" role="search">
<div class="input-group" style="position: relative;">
<section id="unibox-suggest-box" class="unibox unibox-n-section" role="listbox" aria-label="Search Suggestions" style="min-width: 839px; max-width: 839px; left: -657px; top: 34px;"></section>
<input type="text" class="form-control" placeholder="Search" name="q" id="searchBox" autocomplete="off" aria-label="Search query" role="combobox" aria-describedby="unibox-controls-description" aria-owns="unibox-suggest-box"
aria-controls="unibox-suggest-box" aria-expanded="false">
<div class="input-group-btn">
<button class="btn btn-default" type="submit" id="searchButton"><i class="glyphicon glyphicon-search"></i></button>
</div>
<span id="unibox-controls-description" style="position:absolute;width:1px;height:1px;padding:0;margin:-1px;overflow:hidden;clip:rect(0,0,0,0);border:0" class="unibox-sr-only" tabindex="-1">Use the up and down arrows to select a result. Press
enter to go to the selected search result. Touch device users can use touch and swipe gestures.</span><span id="unibox-status-message"
style="position:absolute;width:1px;height:1px;padding:0;margin:-1px;overflow:hidden;clip:rect(0,0,0,0);border:0" tabindex="-1" aria-live="polite" aria-atomic="true" role="status" class="unibox-sr-only"></span>
</div>
</form><form style="margin-top:3px; margin-bottom:3px; clear:both;">
<input type="hidden" name="def" value="online">
<input type="hidden" name="company" value="ONLINE">
<input type="hidden" name="number" value="WACP160522">
<input type="hidden" name="st_date" value="5/22/2023">
<input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> <input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form><form style="margin-top:3px; margin-bottom:3px; clear:both;">
<input type="hidden" name="def" value="online">
<input type="hidden" name="company" value="ONLINE">
<input type="hidden" name="number" value="WACP160621">
<input type="hidden" name="st_date" value="6/21/2023">
<input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> <input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form><form style="margin-top:3px; margin-bottom:3px; clear:both;">
<input type="hidden" name="def" value="online">
<input type="hidden" name="company" value="ONLINE">
<input type="hidden" name="number" value="WACP160717">
<input type="hidden" name="st_date" value="7/17/2023">
<input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> <input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form><form style="margin-top:3px; margin-bottom:3px; clear:both;">
<input type="hidden" name="def" value="online">
<input type="hidden" name="company" value="ONLINE">
<input type="hidden" name="number" value="WACP160816">
<input type="hidden" name="st_date" value="8/16/2023">
<input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> <input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form><form style="margin-top:3px; margin-bottom:3px; clear:both;">
<input type="hidden" name="def" value="online">
<input type="hidden" name="company" value="ONLINE">
<input type="hidden" name="number" value="WACP160911">
<input type="hidden" name="st_date" value="9/11/2023">
<input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> <input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form><form style="margin-top:3px; margin-bottom:3px; clear:both;">
<input type="hidden" name="def" value="online">
<input type="hidden" name="company" value="ONLINE">
<input type="hidden" name="number" value="WACP161009">
<input type="hidden" name="st_date" value="10/9/2023">
<input type="button" value="Enroll" onclick="enrollClick(this.form);" title="Click to sign up for this class."> <input type="button" value="Reminder" onclick="emremind(this.form)" title="Click to get an email reminder for this class.">
</form>Name: alert — POST /scripts/getname.asp
<form style="margin-top:0px;margin-bottom:0px;" name="alert" method="post" action="/scripts/getname.asp" onsubmit="return validateForm(this)">
<input type="hidden" name="dbfName" value="web">
<input type="hidden" name="urlGoto" value=".">
<input type="hidden" name="referer" value="">
<input type="hidden" name="begindate" value="4/12/2023">
<input type="hidden" name="em_to" value="inforeq@onlc.com">
<input type="hidden" name="em_from" value="www@onlc.com">
<input type="hidden" name="em_subj" value="More Info Req">
<input type="hidden" name="em_fields" value="fname lname co_name phoneb emailaddr comment location referer urlGoto eof">
<p class="leftcol" style="margin-top:0px;line-height:15px;">
<b>HAVE QUESTIONS?</b><br>
<span><b>First Name</b></span><br>
<input type="text" size="10" maxlength="25" name="fname" style="width:120px">
<br>
<span><b>Last Name</b></span><br>
<input type="text" size="10" maxlength="25" name="lname" style="width:120px">
<br>
<span><b>Company</b></span><br>
<input type="text" size="10" maxlength="25" name="co_name" style="width:120px">
<br>
<span><b>Phone</b></span><br>
<input type="text" size="10" maxlength="25" name="phoneb" style="width:120px">
<br>
<span><b>Email</b></span><br>
<input type="text" size="10" maxlength="50" name="emailaddr" style="width:120px">
<br>
<span><b>Location</b></span><br>
<input type="text" size="10" maxlength="100" name="location" style="width:120px">
<br>
<span><b>Question/Comment</b></span><br>
<input type="text" size="10" maxlength="200" name="comment" style="width:120px">
<br>
<input type="SUBMIT" value="Submit"><br>
</p>
</form>Text Content
800-288-8221 Contact Us
Toggle navigation 800-288-8221
* Home
* Courses
* * Desktop Applications
* Adobe
* Adobe On-Demand
* Alteryx
* AutoCAD
* AutoCAD On-Demand
* Canva
* Crystal Reports
* Data Visualization
* Dynamics
* Excel Analytics
* Google Classroom
* Google Ads & Analytics
* Google Workspace (multiple)
* Microsoft Office / Office 365
* Microsoft Office Specialist (MOS)
* Office 365 Collaboration
* Power BI
* QuickBooks
* SAS
* Salesforce.com
* SketchUp
* Splunk
* Tableau
* Web Design
* WordPress
* * Microsoft Technical
* Active Directory
* Azure
* BizTalk Server
* Exchange Server
* Microsoft 365
* Microsoft On-Demand (multiple)
* Office 365
* Power Platform (multiple)
* PowerShell
* Role-based Certifications
* Security
* SharePoint
* SQL Server
* System Center
* Visual Studio
* Windows Client / 10
* Windows Server
* * Server & Cybersecurity
* Cisco
* CompTIA
* CompTIA On-Demand
* Cybersecurity
* Docker
* Ethical Hacking / EC-Council
* Linux
* Oracle
* RPA
* VMware
* * Process & Programming
* AWS
* Business Intelligence (BI)
* Business Process
* Java Programming
* Low-Code/No-Code
* Open Source
* Programming (multiple)
* Project Management (multiple)
* Web Development
*
*
* All Courses
* Certifications
* Microsoft Office Certification (MOS)
* Microsoft Technical Certification (Role-based)
* Adobe Certification
* AWS Certification
* AutoCAD Certification
* CareerPath Certification Programs
* Cisco Certification
* CompTIA Certification
* EC Council Certification
* ITIL® Certification
* Oracle Certification
* Project Mgmt. Certification
* Python Certification
* QuickBooks Certification
* Security Certification
* Scrum Master Certification
* Splunk Certification
* Tableau Certification
* VMware Certification
*
* All Certifications
* Savings
* Schedule
* Locations
* Info
* Class Format
* Registration
* Payment
* Invoice/Receipt
* Cancel/Reschedule
* What is RCI?
* Why ONLC?
* Blog
* RCI Login
Use the up and down arrows to select a result. Press enter to go to the selected
search result. Touch device users can use touch and swipe gestures.
1. Home
2. Courses
3. Microsoft Office
4. Access
5. Access Programming with VBA
Access Programming with VBA
Class Dates
(click date for class times)
(click Enroll for locations)
5/22-5/24
Class Dates and Times 05/22/2023Monday 10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 05/23/2023Tuesday 10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 05/24/2023Wednesday10:00-4:45 EDT 9:00-3:45
CDT 8:00-2:45 MDT 7:00-1:45 PDT
Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still
available but filling fast - Register soon!
Last Reg Date5/17
6/21-6/23
Class Dates and Times 06/21/2023Wednesday10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 06/22/2023Thursday 10:00-4:45 EDT 9:00-3:45
CDT 8:00-2:45 MDT 7:00-1:45 PDT 06/23/2023Friday 10:00-4:45 EDT 9:00-3:45
CDT 8:00-2:45 MDT 7:00-1:45 PDT
7/17-7/19
Class Dates and Times 07/17/2023Monday 10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 07/18/2023Tuesday 10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 07/19/2023Wednesday10:00-4:45 EDT 9:00-3:45
CDT 8:00-2:45 MDT 7:00-1:45 PDT
8/16-8/18
Class Dates and Times 08/16/2023Wednesday10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 08/17/2023Thursday 10:00-4:45 EDT 9:00-3:45
CDT 8:00-2:45 MDT 7:00-1:45 PDT 08/18/2023Friday 10:00-4:45 EDT 9:00-3:45
CDT 8:00-2:45 MDT 7:00-1:45 PDT
9/11-9/13
Class Dates and Times 09/11/2023Monday 10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 09/12/2023Tuesday 10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 09/13/2023Wednesday10:00-4:45 EDT 9:00-3:45
CDT 8:00-2:45 MDT 7:00-1:45 PDT
10/9-10/11
Class Dates and Times 10/09/2023Monday 10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 10/10/2023Tuesday 10:00-4:45 EDT 9:00-3:45 CDT
8:00-2:45 MDT 7:00-1:45 PDT 10/11/2023Wednesday10:00-4:45 EDT 9:00-3:45
CDT 8:00-2:45 MDT 7:00-1:45 PDT
--------------------------------------------------------------------------------
Fee: $1195
Savings options:
Learning Credits
Need a price quote?
Follow the link to our self-service price quote form to generate an email with a
price quote.
Need a class for a group?
We can deliver this class for your group. Follow the link to request more
information.
Email Alert
Receive an email when this class is available as "Ready to Run" or "Early
Notice" status.
Train from your home or office
If you have high-speed internet and a computer you can likely take this class
from your home or office.
1. Home
2. Courses
3. Microsoft Office
4. Access
5. Access Programming with VBA
ACCESS PROGRAMMING WITH VBA COURSE OUTLINE
Overview
Students learn the Visual Basic for Applications language as well as the Access
classes and objects needed to create VBA scripts to automate Access.
Participants create procedures and functions using the VBA language and Access
objects. As well, debugging and error handling techniques are reviewed.
Version Note
This class is appropriate for users of Access 2013, 2016, 2019, or 365.
Prerequisites
Appropriate introductory and advanced courses plus several weeks of
practice. No programming experience is required.
Course Outline
Getting Started
Introduction to Programming in Access
Why Program in Access?
Understanding the Development Environment
Using Visual Basic Help
Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Organizing Code and Procedures
Working with the Code Editor
Understanding Objects
Understanding Classes and Objects
Navigating the Access Object Hierarchy
Understanding Collections
Using the Object Browser
Working with the Application Object
Understanding the Form Object
Working with Properties
Using the With Statement
Working with Methods
Understanding the DoCmd Object
Working with Events
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Working with Variable Lifetime
Considering Variable Scope and Lifetime Together
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the For...Next Structure
Using the For Each...Next Structure
Using the Do...Loop Structure
Guidelines for use of Branching Structures
Working with Recordsets
Declaring and Creating Object Variables
Working with the DAO Recordset Object
Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Setting Break Expressions
Using Break Mode during Run Mode
Stepping through Code
Determining the Value of Expressions
Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling
Appendix - Working with the ADO Recordset Object
View outline in Word
WACP16
Attend hands-on, instructor-led Access Programming with VBA training classes at
ONLC's more than 300 locations. Not near one of our locations? Attend these same
live classes from your home/office PC via our Remote Classroom Instruction (RCI)
technology.
For additional training options, check out our list of Access Courses and select
the one that's right for you.
GENERAL INFO
Class Format
Class Policies
Student Reviews
--------------------------------------------------------------------------------
HAVE QUESTIONS?
First Name
Last Name
Company
Phone
Email
Location
Question/Comment
--------------------------------------------------------------------------------
×
Loading...
×
BUSINESS TO BUSINESS ONLY
In Virginia, ONLC is only licensed to serve students who are sponsored by their
employer. We cannot accept registrations from individuals.
If you are being sponsored by your company, click Ok to continue to register.
Ok Close
×
NEW HAMPSHIRE RESIDENTS
This course has not yet been approved by the New Hampshire Department of
Education. Please contact us for an update on when the class will be available
in New Hampshire.
Close
ONLC TRAINING CENTERS
800-288-8221
www.onlc.com
Our Classes
* Instructor-led Schedule (all titles)
* On-Demand / self-study courses
* Payment & Registration Policies
Why Register with ONLC
* Why ONLC
* Fewest Class Cancellations
* Reasons to Register Early
Other Information
* Hundreds of ONLC Centers
* Our Instructors
* Class Credits (CEU/CPE/PDU)
For Companies
* Savings Options & Plans
* Custom & Private Training
* Extra Value Adds
For Professionals
* Certification Programs
* Savings Plans
* Money Back Guarantee
For Government
* GSA / Federal, State, Military
* DoD 8140 / 8570.1
* Private & Custom Classes
Live Classes from Home or Office
* RCI Overview
* RCI from Destinations
* Setup Overview (videos)
About ONLC
* About Us
* Business IDs
* Job Openings
Other Details
* Certification Exams
* Partnering Opportunities
* Contact Us
Connect
* Facebook
* LinkedIn
Live Chat