CareerVision Training

Visual Basic for Access Training

CareerVision Training
Distancia

£ 72 - (86 )
+IVA

Informazione importanti

  • Training
  • Beginner
  • A distanza
  • Durata:
    Flexible
  • Quando:
    Da definire
Descrizione

 •  Format: DVD

 •  Duration: 6.5 Hours (79 lessons)

 •  Instructor: Guy Vaccaro

 •  Platform: Windows PC or Mac

 

Informazione importanti
Sedi

Dove e quando

Inizio Luogo
Da definire
Distance Learning

Cosa impari in questo corso?

Access
Basic
Visual Basic training
IT
Basic IT training
Basic IT
Visual Basic

Programma

 •  Format: DVD
 •  Duration: 6.5 Hours (79 lessons)
 •  Instructor: Guy Vaccaro
 •  Platform: Windows PC or Mac
 

Gain the skills and knowledge to use this powerful programming language to provide greater control over your MS Access forms and databases with the help of these beginners Microsoft Visual Basic for Access tutorial videos.

Commencing from the absolute basics, expert VBA tutor Guy Vaccaro presents step-by-step training videos that explain the important concepts and best practices that will transform you from beginner to confident and proficient VBA programmer in a very short space of time.

Through over six hours of professionally created training videos, the tuition includes the basics of writing VBA code, help using the VBA editor, learning VBA datatypes, how to repeat VBA code, lessons on creating a procedure and so much more.

The complete training course contents are listed below and you can start learning VBA right away, click any blue linked lesson to sample FREE Microsoft Visual Basic for Access video tutorials and discover how effective this teaching method really is...

Benefits of this Software Training:
 •  Tuition by expert tutors.
 •  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
 •  Learning is fast as the trainers guide you using simplistic terms and minimal jargon.
 •  Personal Tutoring - Step-by-step video training from your own desktop.
 •  Delivered via DVD/CD training or online tuition.
 •  The tutor transfers knowledge to you quickly and effectively.
 •  All the concepts of each application are explained clearly and precisely.
 •  Course works on PC and Mac.
 •  Alternative to a boring book or manual and expensive training courses, seminars and amp; classes.
 •  Jump to and from lessons - learn at your own pace.
 •  The visual and practical nature shortens the learning curve compared to standard training manuals.

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
Introducing VBA For Access
Can I Really Become A Programmer
About The VBA Tutor
Using The Working Files
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 VB Editor - Explorer And Properties Windows
The VB 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
MS VBA Course Wrap Up