MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Visual Basic for Microsoft Access Tutorial

Course Summary

Supercharge your Microsoft Access by using Visual Basic. A practical tutorial that teaches real world skills


  • +

    Course Syllabus

    • Introducing VBA For Access
      • Working Files - Download These First
      • Can I Really Become A Programmer
      • Using The Working Files
      • How to obtain your Certificate of Completion for this Infinite Skills course.
      • Initial Setup Of The Sample Databases Provided
    • Moving From A Database To An Application
      • 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
    • Programming In VBA
      • 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
    • Repeating VBA Code
      • Do Loop
      • While Wend
      • For Next
      • If Else End If
      • The Very Flexible Select Case Statement
    • Working With Access Objects
      • The Access Object Model
      • Changing The Value Of Object Properties
      • Access Special Object DoCmd
      • Class Modules And Class Procedures
      • Enable And Disable Controls
      • Hide Or Show Form Controls
      • Lock Unlock Controls
      • Form Events To Trigger Procedures
      • Setting Color Properties
      • Defining Your Own Custom Colours
      • Defining Font Properties Through Your Code
      • With End With To Shorten Code Writing
      • Assigning Values To Data Fields On A Form
      • Opening A Form
      • Open Form And Display Filtered Dataset
      • Closing Any Open Form
    • Data Manipulation
      • A Very Quick SQL Tour
      • Running An Action Query As Code
      • Stop Warnings On Action Queries When Run In VBA
      • Building And Storing SQL In Variables
      • Changing The Sql That Populates A List Or Combo Box
      • Create A New Table
      • Deleting (And Closing) A Table
      • Adding Data To Tables Through Code
      • The Recordset Explained
      • How To Reference Fields In A Recordset
      • Navigating Through The Rows Of A Recordset
      • Closing Off A Recordset And ADODB Connection
      • The Recordset In Action
      • DCOUNT (Great Function)
    • Interacting With The User
      • Getting Started With The MSGBOX
      • Customizing The MSGBOX
      • Reacting To The User Response In A MSGBOX
      • Creating A Dialog Box
      • Using A Dialog To Give Choices To Users
      • Combo Box Dynamic List Building
      • Excluding Values From The Combo Box List
      • Using The Combo Box Selected Value
      • Detecting The Right Mouse Click
    • Combo And ListBox Specials
      • Combo Box And ListBox Properties
      • Accessing And Setting Combo And Field List Properties
      • Accessing Combo Box Fields From A Different Form
      • List Box Search Application
    • Functions
      • What Is A Function
      • Creating A Custom Function
      • A Proper ProperCase Function
    • Testing, Error Handling And Debugging
      • The Three Types Of Errors
      • Handling Logical Errors With Debug Print
      • Handling Logical Errors With Breakpoints
      • Creating Your Own Runtime Error Handler
      • Specific Error Messages For Specific Errors
    • And Finally
      • Locking The VBA From Prying Eyes
      • So What's Next


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top