Learning Visual Basic For Microsoft Access Training Video

expand all / collapse all

• 00. Free Videos From This Course

  • Can I Really Become A Programmer
  • About The Author
  • Using The Working Files
  • Initial Setup Of The Sample Databases Provided
  • What Is VBA
  • Where Is The VBA
  • The VBA Editor Quick Tour
  • The Editor - Explorer And Properties Windows
  • The Editor - The Debug Window
  • Macros Or VBA - Convert Your Macro To Code
  • Getting Started With A Standard Module
  • Creating A Procedure
  • Adding Comments To Your Code
  • VBA Data Types
  • Declaring Parameters For Use In Procedures
  • How To Declare Variables And Constants
  • Creating And Assigning Array Values
  • The Scope And Lifetime Of Variables
  • Standard Naming Conventions For Variables
  • Handling Multiple Line Commands
  • The Very Useful Keyword - ME

• 01. Introducing VBA For Access

  • 0101 Can I Really Become A Programmer
  • 0102 About The Author
  • 0103 Using The Working Files
  • 0104 Initial Setup Of The Sample Databases Provided

• 02. Moving From A Database To An Application

  • 0201 What Is VBA
  • 0202 Where Is The VBA
  • 0203 The VBA Editor Quick Tour
  • 0204 The Editor - Explorer And Properties Windows
  • 0205 The Editor - The Debug Window
  • 0206 Macros Or VBA - Convert Your Macro To Code

• 03. Programming In VBA

  • 0301 Getting Started With A Standard Module
  • 0302 Creating A Procedure
  • 0303 Adding Comments To Your Code
  • 0304 VBA Data Types
  • 0305 Declaring Parameters For Use In Procedures
  • 0306 How To Declare Variables And Constants
  • 0307 Creating And Assigning Array Values
  • 0308 The Scope And Lifetime Of Variables
  • 0309 Standard Naming Conventions For Variables
  • 0310 Handling Multiple Line Commands
  • 0311 The Very Useful Keyword - ME

• 04. Repeating VBA Code

  • 0401 Do Loop
  • 0402 While Wend
  • 0403 For Next
  • 0404 If Else End If
  • 0405 The Very Flexible Select Case Statement

• 05. Working With Access Objects

  • 0501 The Access Object Model
  • 0502 Changing The Value Of Object Properties
  • 0503 Access Special Object DoCmd
  • 0504 Class Modules And Class Procedures
  • 0505 Enable And Disable Controls
  • 0506 Hide Or Show Form Controls
  • 0507 Lock Unlock Controls
  • 0508 Form Events To Trigger Procedures
  • 0509 Setting Color Properties
  • 0510 Defining Your Own Custom Colours
  • 0511 Defining Font Properties Through Your Code
  • 0512 With End With To Shorten Code Writing
  • 0513 Assigning Values To Data Fields On A Form
  • 0514 Opening A Form
  • 0515 Open Form And Display Filtered Dataset
  • 0516 Closing Any Open Form

• 06. Data Manipulation

  • 0601 A Very Quick SQL Tour
  • 0602 Running An Action Query As Code
  • 0603 Stop Warnings On Action Queries When Run In VBA
  • 0604 Building And Storing SQL In Variables
  • 0605 Changing The Sql That Populates A List Or Combo Box
  • 0606 Create A New Table
  • 0607 Deleting (And Closing) A Table
  • 0608 Adding Data To Tables Through Code
  • 0609 The Recordset Explained
  • 0610 How To Reference Fields In A Recordset
  • 0611 Navigating Through The Rows Of A Recordset
  • 0612 Closing Off A Recordset And ADODB Connection
  • 0613 The Recordset In Action
  • 0614 DCOUNT (Great Function)

• 07. Interacting With The User

  • 0701 Getting Started With The MSGBOX
  • 0702 Customizing The MSGBOX
  • 0703 Reacting To The User Response In A MSGBOX
  • 0704 Creating A Dialog Box
  • 0705 Using A Dialog To Give Choices To Users
  • 0706 Combo Box Dynamic List Building
  • 0707 Excluding Values From The Combo Box List
  • 0708 Using The Combo Box Selected Value
  • 0709 Detecting The Right Mouse Click

• 08. Combo And ListBox Specials

  • 0801 Combo Box And ListBox Properties
  • 0802 Accessing And Setting Combo And Field List Properties
  • 0803 Accessing Combo Box Fields From A Different Form
  • 0804 List Box Search Application

• 09. Functions

  • 0901 What Is A Function
  • 0902 Creating A Custom Function
  • 0903 A Proper ProperCase Function

• 10. Testing, Error Handling And Debugging

  • 1001 The Three Types Of Errors
  • 1002 Handling Logical Errors With Debug Print
  • 1003 Handling Logical Errors With Breakpoints
  • 1004 Creating Your Own Runtime Error Handler
  • 1005 Specific Error Messages For Specific Errors

• 11. And Finally

  • 1101 Locking The VBA From Prying Eyes
  • 1102 So What's Next

In this software training course from expert author and trainer Guy Vaccaro, you will learn how to use Visual Basic with Microsoft Access. Knowing how to use Visual Basic with Microsoft Access gives you greater control of your Access forms and design.

You will start with an introduction to VBA and the VBA editor, how to navigate and use the tools available to you to write VBA code. You will explore variables and constants, functions, sub routines, arrays and other VBA constructs. This video based training will teach you to use VBA for data manipulation, create and use recordsets, controlling objects, create and use dialog and message boxes, debugging, and creating error messages. Finally, you will learn to protect your VBA programs.

By the completion of this training video, you will be comfortable with using Visual Basic for Access to exert greater control over your Microsoft Access forms and databases. Working Files are included to allow you to work alongside the author in this video tutorial.