Visual Basic For Microsoft Access

Video description

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.

Table of contents

  1. Introducing VBA For Access
    1. Can I Really Become A Programmer
    2. About The Author
    3. Using The Working Files
    4. Initial Setup Of The Sample Databases Provided
  2. Moving From A Database To An Application
    1. What Is VBA
    2. Where Is The VBA
    3. The VBA Editor Quick Tour
    4. The Editor - Explorer And Properties Windows
    5. The Editor - The Debug Window
    6. Macros Or VBA - Convert Your Macro To Code
  3. Programming In VBA
    1. Getting Started With A Standard Module
    2. Creating A Procedure
    3. Adding Comments To Your Code
    4. VBA Data Types
    5. Declaring Parameters For Use In Procedures
    6. How To Declare Variables And Constants
    7. Creating And Assigning Array Values
    8. The Scope And Lifetime Of Variables
    9. Standard Naming Conventions For Variables
    10. Handling Multiple Line Commands
    11. The Very Useful Keyword - ME
  4. Repeating VBA Code
    1. Do Loop
    2. While Wend
    3. For Next
    4. If Else End If
    5. The Very Flexible Select Case Statement
  5. Working With Access Objects
    1. The Access Object Model
    2. Changing The Value Of Object Properties
    3. Access Special Object DoCmd
    4. Class Modules And Class Procedures
    5. Enable And Disable Controls
    6. Hide Or Show Form Controls
    7. Lock Unlock Controls
    8. Form Events To Trigger Procedures
    9. Setting Color Properties
    10. Defining Your Own Custom Colours
    11. Defining Font Properties Through Your Code
    12. With End With To Shorten Code Writing
    13. Assigning Values To Data Fields On A Form
    14. Opening A Form
    15. Open Form And Display Filtered Dataset
    16. Closing Any Open Form
  6. Data Manipulation
    1. A Very Quick SQL Tour
    2. Running An Action Query As Code
    3. Stop Warnings On Action Queries When Run In VBA
    4. Building And Storing SQL In Variables
    5. Changing The Sql That Populates A List Or Combo Box
    6. Create A New Table
    7. Deleting (And Closing) A Table
    8. Adding Data To Tables Through Code
    9. The Recordset Explained
    10. How To Reference Fields In A Recordset
    11. Navigating Through The Rows Of A Recordset
    12. Closing Off A Recordset And ADODB Connection
    13. The Recordset In Action
    14. DCOUNT (Great Function)
  7. Interacting With The User
    1. Getting Started With The MSGBOX
    2. Customizing The MSGBOX
    3. Reacting To The User Response In A MSGBOX
    4. Creating A Dialog Box
    5. Using A Dialog To Give Choices To Users
    6. Combo Box Dynamic List Building
    7. Excluding Values From The Combo Box List
    8. Using The Combo Box Selected Value
    9. Detecting The Right Mouse Click
  8. Combo And ListBox Specials
    1. Combo Box And ListBox Properties
    2. Accessing And Setting Combo And Field List Properties
    3. Accessing Combo Box Fields From A Different Form
    4. List Box Search Application
  9. Functions
    1. What Is A Function
    2. Creating A Custom Function
    3. A Proper ProperCase Function
  10. Testing, Error Handling And Debugging
    1. The Three Types Of Errors
    2. Handling Logical Errors With Debug Print
    3. Handling Logical Errors With Breakpoints
    4. Creating Your Own Runtime Error Handler
    5. Specific Error Messages For Specific Errors
  11. And Finally
    1. Locking The VBA From Prying Eyes
    2. So What's Next

Product information

  • Title: Visual Basic For Microsoft Access
  • Author(s):
  • Release date: March 2012
  • Publisher(s): Infinite Skills
  • ISBN: 9781926873947