Visual Basic for Access TrainingCareerVision Training
£ 72 - (81 €)
- A distanza
Cosa impari in questo corso?
Visual Basic training
Basic IT training
• Format: DVD
• Duration: 6.5 Hours (79 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac
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.
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
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
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
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
Locking The VBA From Prying Eyes
So What's Next
MS VBA Course Wrap Up