Visual Studio

Mastering Microsoft Visual Basic 6 (VB) Fundamentals
(Microsoft Training Course: 1303) - 5 days - £2640 exc VAT

> Target Audience
This course provides the necessary intermediate level skills to developers new to Microsoft Windows-based programming. The course also provides the necessary foundation for those moving on to the Visual Basic Development course
> Course outline
  1. Introduction to Application Development with Visual Basic
  2. Visual Basic Fundamentals
  3. Working with Code and Forms
  4. Variables and Procedures
  5. Controlling Program Execution
  6. Debugging
  7. Working with Controls
  8. Data Access Using the ADO Data Control
  9. Input Validation
  10. Error Trapping
  11. Enhancing the User Interface
  12. Drag and Drop
  13. More About Controls
  14. Finishing Touches

Supplementary InformationThis course was written with Visual Basic 6.0. If you require a similar course in a newer technology, we suggest Course [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-.Net/2373.aspx}2373: Programming with Microsoft Visual Basic .NET]]. Look at our .Net 2008 courses too.
Module 1: Introduction to Application Development with Visual Basic
  • Overview of Visual Basic Editions, terminology and navigating the development environment
  • Create Project and Executable files, and use the VB reference materials
  • Identify the elements in the Visual Basic development environment.
  • Explain the difference between design time and run time, procedural and event driven.
  • Describe the purpose of a project file and the file types that can be referenced/included in a project
Module 2: Visual Basic Fundamentals
  • Introduction to Controlling objects through Properties, Methods, and Events
  • Working with forms and controls
  • Create a simple application
  • Manipulate forms and controls through the use of Properties, Methods, and Events
  • Use the With…End With statement to set multiple property values for a single object
Module 3: Working with Code and Forms
  • Understanding modules and navigating the Code Editor window
  • Code documentation and formatting
  • Setting environment options
  • Automatic code completion features
  • Interact with the user through the MsgBox and InputBox functions
  • Working with code statements
  • Managing forms
  • Create organized and well-documented code.
  • Customize the Visual Basic toolbar and toolbox
  • Display message boxes and use constants and named arguments.
  • Differentiate between the Load/Unload statements and use the Show/Hide methods.
  • Set the Startup Form for an application
  • Control a program’s closing routine
Module 4: Variables and Procedures
  • Overview of variables and constants; Declaring, scope, data types and conversions
  • Using arrays and user-defined data types
  • Working with procedures, dates and times and manipulating text strings
  • Use the Format function
  • Explain the various data types used when declaring variables
  • Declare private and public variables
  • Use public variables to use data in multiple forms.
  • Differentiate between a Sub and a Function procedure
  • Create a Function that accepts arguments and returns a value
  • Differentiate Standard and Form modules
  • Store general procedures and variables in Standard modules
  • Use Functions to manipulate text strings and return the current date and time
Module 5: Controlling Program Execution
  • Comparison and logical operators
  • Using If…Then statements
  • Using Select Case statements
  • Using Do…Loop structures
  • Using For…Next statements
  • Unconditionally exiting a loop
  • List techniques for comparing variables and object properties
  • Explain the difference between If…Then and Select Case statements
  • Explain the difference between the For…Next and Do…Loop statements
Module 6: Debugging
  • Types of errors and Break mode
  • Using the Debug toolbar, Watch, Immediate and Locals windows
  • Tracing program flow with the Call Stack
  • Use Breakpoints and Watch expressions to stop program execution and monitor variables.
  • Test data and a procedure’s results in the Immediate window
  • Evaluate variable values in the Locals window
  • Distinguish among Run, Design, and Debug modes in Visual Basic
  • Trace the program execution sequence using the Call Stack.
Module 7: Working with Controls
  • Overview of standard controls
  • Using ComboBox , ListBox, OptionButton and Frame controls
  • Working with selected text
  • Advanced standard controls
  • ActiveX controls and Insertable Objects
  • Identify and use the standard controls in Visual Basic
  • Define how an ActiveX control differs from a standard control
  • Add ActiveX controls to a project and use these controls in a program
Module 8: Data Access Using the ADO Data Control
  • Overview of ActiveX data objects
  • Visual Basic data access features
  • Relational database concepts
  • Using the ADO Data control to access data
  • Structured query language (SQL)
  • Manipulating data
  • Using the Data Form Wizard
  • Define the following terms: Database, Table, Field, Record, and Key
  • Use the ADO Data control to view, find, modify, delete, and add records in a database
  • List the standard data-bound controls
  • Define Structured Query Language (SQL) and the purpose of the SELECT statement in SQL
  • Use Data Form Wizard to design a simple data-entry form
Module 9: Input Validation
  • Field-level validation through TextBox properties to restrict data entry
  • Using the Masked Edit control
  • Form-level validation
  • Form events used when validating data
  • Create an application that validates user data at the field level and at the form level
  • Create an application that uses the Masked Edit control
  • Create an application that enables or disables controls based on field values
Module 10: Error Trapping
  • Overview of run-time errors and the error handling process
  • The global Err object
  • Errors and the calling chain
  • Errors in an error-handling routine
  • Inline error handling
  • Error-handling styles and options
  • Trap run-time errors with error handling routines
  • Note how errors are handled in the calling chain
  • Handle inline errors
  • Describe some common error-handling styles
Module 11: Enhancing the User Interface
  • Menus, StatusBars, Toolbars
  • Create and edit custom menu bars, pop up menus, menus, submenus, and menu items using the Menu Editor
  • Identify the menu properties that can be set in the Menu Editor dialog box
  • Assign code to menu items using the Click event
  • Use and manipulate properties of Toolbars and a StatusBars on a form
Module 12: Drag and Drop
  • Overview of Drag and Drop
  • Mouse events
  • Perform the steps required to add Drag-and- Drop features to an application, through Mouse and Drag events
  • Identify the source control and target form or control in a Drag-and-Drop operation
Module 13: More About Controls
  • Collections and Control Arrays
  • Define, describe and create a Control Array
  • Dynamically add and delete controls
  • Use the Visual Basic Controls Collection.
  • Create and use object variables
Module 14: Finishing Touches
  • User interface design principles
  • Distributing an application
  • Creating a default project
  • Create a setup program for an application using the Package and Deployment Wizard
  • Create custom projects
> Pre-Requisites
Before attending this course, students should have the following pre-requisites:
  • Knowledge of the Windows interface and familiarity with its terminology
  • Rudimentary knowledge of word-processing and spreadsheet applications.
  • To help delegates familiarise themselves with these pre-requisites we provide a Free book to all delegates booking on this course
> Purpose
On completion of the course, students will be able to write solid event-driven code; create stand-alone, multi-form applications; create an effective interface; and access and modify a database
> Supplementary Information
This course was written with Visual Basic 6.0. If you require a similar course in a newer technology, we suggest Course [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-.Net/2373.aspx}2373: Programming with Microsoft Visual Basic .NET]]. Look at our .Net 2008 courses too.