Free access vba tutorial with video lessons. This free course teaches all you need to get started with Microsoft Access VBA

Learn Access VBA With The Smart Method.  Microsoft Access tutorials, Discussion Forums, Training Courses and Support info@learnaccessvba.com
Home Home  Site Map Site Map  Free Tutorials Free Tutorials Application
Development
application development Buy The Book Buy My Book Classroom
Courses
Classroom delivered courses Contact Contact Details
Free Access VBA Course
This Free Access VBA course includes all that you need to know to give you a thorough grounding in VBA and the Access object model.

This course isn't for Access beginners. You'll need to already be thoroughly competent in the interactive use of Access (up to our defined Expert level) before beginning Access application development with VBA.  See the Competent User and Expert course outlines in the Classroom Courses section of the site to confirm that you're ready to take the next step and begin coding with VBA.
 

Session Lesson
(Use the links below for dial-in, otherwise the PDF link on the right is better)
Cost
Introduction Table of Contents   [PDF]
How to use the course  
Three - The Object Orientated Paradigm
(why does the course begin at session three?)

Foreword and objectives

  [PDF]
3-1 Understand properties  
3-2 Understand methods  
3-3 Understand events  
3-4 The Access object model  
Session 3 Exercise  
Session 3 Exercise Answers (included in PDF)  
Four - An Introduction To VBA

Foreword and objectives

  [PDF]
4-1 Understand subs  
4-2 Step through code  
4-3 Understand step over and step out  
4-4 Understand variables  
4-5 Use the immediate window to view and change variable contents  
4-6 Use the locals window to view and change variable contents  
Session 4 Exercise  
Session 4 Exercise Answers (included in PDF)  
Five - Professional Grade VBA

Foreword and objectives

  [PDF]
 
5-1 Understand data types  
5-2 Understand and implement strong typing and explicit variable declaration  
5-3 Understand arguments  
5-4 Understand functions  
5-5 Understand ByRef and ByVal argument types  
5-6 Set and retrieve form control values from within VBA  
5-7 Understand scope  
5-8 Implement error handling  
5-9 Use the help system and the object browser  
Session 5 Exercise  
Session 5 Exercise Answers (included in PDF)  
Appendix A: The Rules

1: Introduction

  [PDF]
2: General rules  
3: Table and field naming  
4: Field properties  
5: Access object, form control and variable naming  
6: Constants, variable declaration, error handling and object destruction  
One - The Sample Database

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course.  Book owners can also download the sample files for each lesson.

 
1-1 Understand the sample database [Sample Files]
1-2 Create lookup fields [Sample Files]
1-3 Create a concatenated lookup field [Sample Files]
1-4 Create one-to-many table relationships [Sample Files]
1-5 Create a many-to-many table relationship [Sample Files]
1-6 Set default and required values [Sample Files]
1-7 Create a general purpose query [Sample Files]
1-8 Create the prototype main form using a wizard [Sample Files]
1-9 Improve the prototype form for keyboard input [Sample Files]
1-10 Create a simple report using a wizard [Sample Files]
Session 1 Exercise [Sample Files]
Session 1 Exercise Answers  
Two - Adding Advanced Features Using Wizards

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course.
2-1 Add a switchboard to the application using the Switchboard Wizard [Sample Files]
2-2 Add a command button to a form using a wizard [Sample Files]
Session 2 Exercise [Sample Files]
Session 2 Exercise Answers  
Six - Improving Wizard-Generated Code Foreword and objectives [Sample Files] This session is published in the book and covered in my VBA Classroom Course. Book owners can also download the sample files for each lesson.

 
6-1 Understand and improve the command button wizard's error handling code [Sample Files]
6-2 Understand the DoCmd object and its DoMenuItem method [Sample Files]
6-3 Implement the DoCmd object's RunCommand method [Sample Files]
6-4 Replace standard warnings and error messages with custom dialogs [Sample Files]
6-5 Understand the combo box wizard code [Sample Files]
6-6 Improve the combo box wizard code [Sample Files]
6-7 Correctly name controls [Sample Files]
6-8 Program an add record button [Sample Files]
6-9 Handle the form object's Current event [Sample Files]
6-10 The Access object model re-visited [Sample Files]
Session 6 Exercise [Sample Files]
Session 6 Exercise Answers  
Seven - Speeding Up Data Entry

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course. Book owners can also download the sample files for each lesson.

 
7-1 Filter using Filter By Form [Sample Files]
7-2 Add an option group control [Sample Files]
7-3 Implement the option group control's functionality [Sample Files]
7-4 Add interactive help [Sample Files]
7-5 Add a shortcut key to a control [Sample Files]
Session 7 Exercise [Sample Files]
Session 7 Exercise Answers  
Eight - Implementing a Popup Browse Form

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course. Book owners can also download the sample files for each lesson.

 
8-1 Create a browse form using a listbox contr4ol [Sample Files]
8-2 Convert form to a dialog box [Sample Files]
8-3 Use the recordset object's FindFirst and Clone methods and Bookmark property [Sample Files]
8-4 Launch the popup form from the main form [Sample Files]
Session 8 Exercise [Sample Files]
Session 8 Exercise Answers  
Nine - Maintaining Static Data

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course.  Book owners can also download the sample files for each lesson.
9-1 Create a self-updating bound combo box [Sample Files]
9-2 Make the combo box accept apostrophes [Sample Files]
9-3 Create and use a global constant [Sample Files]
9-4 Create a popup dialog to update related data [Sample Files]
9-5 Add a command button to invoke the Add Director form [Sample Files]
9-6 Improve the code to auto-select the contents of the combo box [Sample Files]
9-7 Add simple forms to maintain static data [Sample Files]
Session 1 Exercise [Sample Files]
Session 1 Exercise Answers  
Ten - Validations and Sub-Forms

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course. Book owners can also download the sample files for each lesson.
10-1 Add an advisory validation [Sample Files]
10-2 Add a VBA business rule to a form [Sample Files]
10-3 Design a query for the many-to-many sub form [Sample Files]
10-4 Create the many-to-many sub form [Sample Files]
10-5 Convert the combo box to self-updating [Sample Files]
10-6 Add a sub form [Sample Files]
Session 1 Exercise [Sample Files]
Session 1 Exercise Answers  
Eleven - Creating a Dialog-Driven Report

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course. Book owners can also download the sample files for each lesson.

 
11-1 Design a query for the report [Sample Files]
11-2 Create the prototype report [Sample Files]
11-3 Format the prototype report - first fix [Sample Files]
11-4 Format the prototype report - second fix [Sample Files]
11-5 Design the tab-based user interface [Sample Files]
11-6 Complete the user interface [Sample Files]
11-7 Implement Print Preview functionality [Sample Files]
11-8 Implement Print functionality [Sample Files]
Session 11 Exercise [Sample Files]
Session 11 Exercise Answers  
Twelve - Using Word with Access

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course
12-1 Create a Word document template [Sample Files]
12-2 Create a command button that will open Word [Sample Files]
12-3 Transfer data from Access to Word [Sample Files]
Session 12 Exercise [Sample Files]
Session 12 Exercise Answers  
Thirteen - Adding Switchboards, Menus and Toolbars

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course. Book owners can also download the sample files for each lesson.
13-1 Create the user interface [Sample Files]
13-2 Create a global menu [Sample Files]
13-3 Add standard top-level menus and items [Sample Files]
13-4 Add a custom top-level menu and items [Sample Files]
13-5 Create a custom toolbar [Sample Files]
Session 13 Exercise [Sample Files]
Session 13 Exercise Answers  
Fourteen - Finalizing the Application For Deployment

Foreword and objectives

[Sample Files] This session is published in the book and covered in my VBA Classroom Course. Book owners can also download the sample files for each lesson.
14-1 Implement universal error handling [Sample Files]
14-2 Explicitly declare and destroy objects [Sample Files]
14-3 Improve form appearance [Sample Files]
14-4 Further improve form appearance [Sample Files]
14-5 Setting start-up options [Sample Files]
14-6 Test the application [Sample Files]
Session 14 Exercise [Sample Files]
Session 14 Exercise Answers