All classes are taught LIVE by seasoned instructors. * 9.6 of 10 (over 22 k student survey results - 2023)

Find A Class in Your City:


Access VBA Microsoft

Email this page | Print this page

Access VBMicrosoft - (Public class max is 5 students)

 


To View Class Dates: Please use the pull down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

   ** 2016 USERS READ HERE: Classes will be taught in 2013, however, if you are using 2016, we can provide 2016 courseware for you and the instructor can discuss any 2016 vs 2013 differences during and after class. Experts agree the differences between 2013 and 2016 aren't as much as previous upgrades. 2010 users: please call us to ask about how you can still take our class. **

  • Training at your company site (group or 1on1) -- click here.
  • We have taught thousands of business professionals throughout the years. Read what our students say
  • Free repeats! You are allowed to repeat your open enrollment class for free within 6 months for any reason whatsoever! Classes are 9am to 4pm and come with courseware and CD to practice afterwards.
  • Are you signing up for more MS Office classes? See our package discounts page
 



Course Description
This course on Microsoft Access: VBA Programming is designed for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming. This manual is designed for quick scanning in the classroom, and filled with interactive exercises.
Objectives
  • Work with objects, use Object Browser, identify collection objects, and use the Controls collection.
  • Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another.
  • Use decision structures and use loop structures.
  • Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query.

Prerequisites
To ensure the successful completion of Microsoft Office Access: VBA Programming, we recommend the equivalent knowledge (familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports):

Who Should Take This Course?
Microsoft Access: VBA Programming is for students who have a thorough understanding of the basic and advanced user features of the Access program, and are interested in learning introductory level administrator skill sets. The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access.
This ILT Series manual on Access VBA Programming is designed for experienced Access users who want to learn activex data objects, control structures, and the basics of VBA programming. This instructor's edition is designed for quick scanning in the classroom, and filled with interactive exercises.

Table of Contents
Unit 1: Visual Basic Editor
  • Topic A: Objects
  • Topic B: Object Browser
  • Topic C: Collections
Unit 2: Programming basics
  • Topic A: Data
  • Topic B: Scope
Unit 3: Control structures
  • Topic A: Decision structures
  • Topic B: Loop structures
Unit 4: ActiveX Data Objects
  • Topic A: Getting started with ActiveX Data Objects
  • Topic B: Working with ActiveX Data Objects
Unit 5: VBA debugging tools
  • Topic A: Errors in code
  • Topic B: Debugging techniques
  • Topic C: Handling run-time errors
Appendix A: Office integration
  • Topic A: Automating Office
  • Topic B: Working with Word from Access
  • Topic C: Working with Excel from Access