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

info@learnaccessvba.com

Home

Site Map

Free Tutorials
With Video

Application
Development

Buy The Book

Classroom
Courses

Contact

Free Access VBA Course - With Video

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. Shortly I will also add a video walk-through for each lesson.

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)
Introduction	Table of Contents	Video	[PDF]
Introduction	How to use the course	(Coming	[PDF]
Three - The Object Orientated Paradigm (why does the course begin at session three?)	Foreword and objectives	soon)	[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