Discover Classes. Earn 10% Rewards.

Microsoft Access VBA

  • Advanced
  • 14 and older
  • $850
  • Earn 8,500 reward points
  • Price Lock Guarantee
  • 230 W Monroe St, Chicago, IL
  • over 2 sessions

Start Dates (0)

  • $850
  • over 2 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this access class:

Students will learn ActiveX data objects, control structures, and the basics of VBA programming.

Target Audience: Experienced Access users looking to learn Access VBA. Students should already have good working knowledge of Access or have completed our Access Advanced class.

Detailed Course Outline

Visual Basic Editor

  • Visual Basic Terminology
  • Work with Objects, their properties, methods, and events
  • Use Object Browser to get information about Objects
  • Identify Collection Objects and use Collection 
  • Control
Programming Basics
  • Manipulate and Combine Data to get User input
  • Declare Variables and Procedures
  • Create Sub and Function Procedures
  • Call one Procedure from other
Control Structures
  • Use Decision Structures to create procedures that execute code
  • Use Loop structures to execute code repeatedly
ActiveX Data Objects
  • Examine ActiveX Data Objects architecture and collections
  • Connect to a Database
  • Work with a Recordset and Parameter query
VBA Debugging Tools
  • Identify compile-time, run-time and logical errors
  • Use the Debugging Tools
  • Write Error-handling code to trap errors
Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class. 

What's included: 
  • Microsoft Access Training Manual
  • Certificate of Course Completion
  • 6 Months FREE Repeat Policy

Refund Policy

All cancellations and rescheduling requests must be made in writing and emailed to [email protected]

  • Rescheduling requests made 9 business days before the commencement of the training are free.
  • Rescheduling that takes place within 9 business days of the commencement of the training will incur a $150 administration fee.
  • We do not charge for student substitutions at any time.

We are unable to offer refunds for cancellations.

While we make every effort to deliver classes as scheduled, we reserve the right to reschedule previously confirmed classes for a variety of reasons including but not exclusively, the illness of the Trainer. In such cases, we will endeavor to inform the Client as soon as possible of the new training dates. We are not liable for any additional expenses incurred as a result of rescheduling training.

We are not able to offer refunds for no-shows or uncompleted courses.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at Training Connection (158)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 8500 points. Earn 10% back in reward points!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Training Connection

Training Connection LLC is a computer and business skills training company.

Our Training Philosophy

Our main focus is to provide exceptional computer desktop and business skills training. We strive to achieve this by following a 5 cornerstone approach:

1. Our Instructors

Without a doubt our most valuable...

Read more about Training Connection

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Training Connection

Training Connection

All classes at this location

Trains CTA - Blue and Red Lines - Monroe Station Walk approximately 4 blocks west on Monroe Street to Franklin Street. CTA - Orange, Pink, Purple and Brown Lines - Quincy station Walk approximately 1.5 blocks north on Wells Street, turn left (west) on Monroe Street, and go to corner of Franklin Street. CTA - Green Line Swap at Clark for Blue line or Roosevelt for Orange line. Metra - Union Station Walk 3 blocks east on West Adams (crossing river). Turn left (North) on Franklin and walk 1 block to Monroe Street.

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

  • Price Lock Guarantee

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Earn 10% Reward Points

    Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!

  • No Added Fees

    Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!

  • Curated Courses

    Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...