Cauta cursuri
Vezi toate categoriile

Learning Visual Basic for Access

99 USD
  Curs on-line
Predare in limba: Engleza

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this software training course from InfiniteSkills, 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.


Infinite Skills

Structura cursului

SECTION 1: Introducing VBA For Access
Lecture 1:
Working Files - Download These First
Lecture 2: Can I Really Become A Programmer (02:52)
Lecture 3: Using The Working Files (01:59)
Lecture 4:
How to obtain your Certificate of Completion for this Infinite Skills course.
Lecture 5: Initial Setup Of The Sample Databases Provided (02:44)

SECTION 2: Moving From A Database To An Application
Lecture 6: What Is VBA (03:20)
Lecture 7: Where Is The VBA (04:38)
Lecture 8: The VBA Editor Quick Tour (02:34)
Lecture 9: The Editor - Explorer And Properties Windows (02:50)
Lecture 10: The Editor - The Debug Window (02:45)
Lecture 11: Macros Or VBA - Convert Your Macro To Code (03:19)

SECTION 3: Programming In VBA
Lecture 12: Getting Started With A Standard Module (02:11)
Lecture 13: Creating A Procedure (02:55)
Lecture 14: Adding Comments To Your Code (02:10)
Lecture 15: VBA Data Types (02:38)
Lecture 16: Declaring Parameters For Use In Procedures (04:30)
Lecture 17: How To Declare Variables And Constants (05:09)
Lecture 18: Creating And Assigning Array Values (04:21)
Lecture 19: The Scope And Lifetime Of Variables (03:33)
Lecture 20: Standard Naming Conventions For Variables (03:24)
Lecture 21: Handling Multiple Line Commands (03:44)
Lecture 22: The Very Useful Keyword - ME (02:45)

SECTION 4: Repeating VBA Code
Lecture 23: Do Loop (04:34)
Lecture 24: While Wend (01:54)
Lecture 25: For Next (04:47)
Lecture 26: If Else End If (07:02)
Lecture 27: The Very Flexible Select Case Statement (05:17)

SECTION 5: Working With Access Objects
Lecture 28: The Access Object Model (07:23)
Lecture 29: Changing The Value Of Object Properties (04:14)
Lecture 30: Access Special Object DoCmd (03:52)
Lecture 31: Class Modules And Class Procedures (04:35)
Lecture 32: Enable And Disable Controls (05:41)
Lecture 33: Hide Or Show Form Controls (05:47)
Lecture 34: Lock Unlock Controls (02:52)
Lecture 35: Form Events To Trigger Procedures (05:48)
Lecture 36: Setting Color Properties (07:19)
Lecture 37: Defining Your Own Custom Colours (08:09)
Lecture 38: Defining Font Properties Through Your Code (05:46)
Lecture 39: With End With To Shorten Code Writing (02:47)
Lecture 40: Assigning Values To Data Fields On A Form (06:44)
Lecture 41: Opening A Form (05:29)
Lecture 42: Open Form And Display Filtered Dataset (06:40)
Lecture 43: Closing Any Open Form (06:00)

SECTION 6: Data Manipulation
Lecture 44: A Very Quick SQL Tour (03:53)
Lecture 45: Running An Action Query As Code (04:50)
Lecture 46: Stop Warnings On Action Queries When Run In VBA (04:12)
Lecture 47: Building And Storing SQL In Variables (05:39)
Lecture 48: Changing The Sql That Populates A List Or Combo Box (04:28)
Lecture 49: Create A New Table (03:56)
Lecture 50: Deleting (And Closing) A Table (04:47)
Lecture 51: Adding Data To Tables Through Code (07:38)
Lecture 52: The Recordset Explained (07:29)
Lecture 53: How To Reference Fields In A Recordset (02:13)
Lecture 54: Navigating Through The Rows Of A Recordset (02:41)
Lecture 55: Closing Off A Recordset And ADODB Connection (02:14)
Lecture 56: The Recordset In Action (13:05)
Lecture 57: DCOUNT (Great Function) (06:09)

SECTION 7: Interacting With The User
Lecture 58: Getting Started With The MSGBOX (07:13)
Lecture 59: Customizing The MSGBOX (06:12)
Lecture 60: Reacting To The User Response In A MSGBOX (06:04)
Lecture 61: Creating A Dialog Box (04:29)
Lecture 62: Using A Dialog To Give Choices To Users (07:46)
Lecture 63: Combo Box Dynamic List Building (06:01)
Lecture 64: Excluding Values From The Combo Box List (03:07)
Lecture 65: Using The Combo Box Selected Value (04:42)
Lecture 66: Detecting The Right Mouse Click (07:20)

SECTION 8: Combo And ListBox Specials
Lecture 67: Combo Box And ListBox Properties (04:04)
Lecture 68: Accessing And Setting Combo And Field List Properties (09:12)
Lecture 69: Accessing Combo Box Fields From A Different Form (10:45)
Lecture 70: List Box Search Application (04:26)

SECTION 9: Functions
Lecture 71: What Is A Function (02:21)
Lecture 72: Creating A Custom Function (04:17)
Lecture 73: A Proper ProperCase Function (06:53)

SECTION 10: Testing, Error Handling And Debugging
Lecture 74: The Three Types Of Errors (04:48)
Lecture 75: Handling Logical Errors With Debug Print (05:39)
Lecture 76: Handling Logical Errors With Breakpoints (05:46)
Lecture 77: Creating Your Own Runtime Error Handler (06:07)
Lecture 78: Specific Error Messages For Specific Errors (06:51)

SECTION 11: And Finally
Lecture 79: Locking The VBA From Prying Eyes (02:57)
Lecture 80: So What's Next (03:13)