Two-Day Visual Basic Course

This powerful programming language is becoming more and more important everyday. You will learn:

Day 1

• What is Visual Basic
• Why is Visual Basic important
• Different editions of Visual Basic
• Some Key terms used in VB
• Elements of VB development environment
• Create a new project
• Toolbox
• Form Designer
• Project Explorer Window
• Properties Window
• Code Editor Window
• Standard toolbar
• Event-Driven Programming
• Sources of Visual Basic Events
• Build an application
• Visual Development Environment
• Steps in developing an application
• Forms, controls, and code to create an application
• Properties, Methods and Events
• Constants
• Using With...End With to Set Object Properties
• Build User Login
• Form Module
• Standard modules
• Class module
• Code Editor window (Code Window)
• Other Code Navigation Features
• Finding Text
• Object Browser
• Bookmarks
• Line continuation and comments
• Creating controls
• Setting Environment Options
• Editor Format Options
• Message boxes
• Input boxes
• Show and Load methods of Form
• Modal and Modeless Forms
• Hide and Unload form
• Ending an application
• Form Events
• Variables
• Data Type of Variables
• Date and Time
• Data Type Conversion
• The VarType function
• Type Determination
• Valid Variable Name
• Prefix type for variables in naming convention
• Declaring Variables and using Option Explicit
• Scope of a Variable
• Declaring Local Variables and Static Variables
• Module, Form and Public Variables
• & and + Operators
• Adding ToolTip
• Math Operators
• Arrays and Multidimensional Arrays
• Functions related to Arrays
• Fixed-size arrays and Dynamic Arrays
• If - Else - End If Statements
• Select Case statements and Select Case (Range)
• Procedures and Functions
• Calling functions
• Call a subroutine and pass parameters to it
• Date and Time Functions
• FormatDateTime
• For Next Loop and Do Loop
• Using Exit For
• Using the Format Function
• String Functions
• Comparison Operators
• Logical Operators
  

Day 2

• The List Box Control
• Some properties and methods of List Box
• Combo Box Control
• Populating a List at Design Time
• Accessing items in a combo or list box
• Associating a Value with a List Item
• Removing items from a list
• Sorting a list
• Option Buttons (Radio Buttons) and Frame
• Selected Text
• File Management Controls
• Timer control and create a Time Display
• Using the Timer function and Math
• ActiveX Controls
• Microsoft Windows Common Controls
• Common Dialog Boxes
• Graphics, Picture Box Control and Image Control
• Loading Pictures at Runtime
• Menu Editor
• Create a Menu Bar with File, Edit, View and Help pull-down menu
• Adding checked item and two-option submenu
• Connect Menu item to Event Procedures
• File Manipulation
• Opening, closing and deleting Files
• Writing to Files with Write#
• User Defined Data Type
• Input Validation
• KeyPress, KeyUp and KeyDown
• Debugging
• Types of Errors - Syntax Errors, Run-Time Errors and Logic Errors
• Break Mode and setting Breakpoints
• Using a Stop statement and using a Debug.Assert method
• Using the Debug Toolbar
• Using error handlers
• Implement an Error Trap
• The Err object
• Data Access using the ADO Data control
• Understanding OLE DB
• Using the ADO Data Control
• ConnectionString Property
• RecordSource Property
• Binding a control
• DataSource and DataField Properties
• Update a Database and adding New Records

Date: Monday 19 October and Tuesday 20 October 2009

Cost: $660 (Australian dollars) including morning tea, lunch, afternoon tea, notes and lots of hands on exercises

Time: 9 am - 5pm

Place: 600 Collins Street or at a place close to the Monash freeway about 25 minutes drive from Melbourne city in Australia

Enquiries or Enrolment:

Email: melbourne@expert.com.hk

We also offer on-site training courses at your place anywhere in Australia, email to us for details: melbourne@expert.com.hk