Visual Basic 6.0 --

Visual Basic Introduction - Version 6.0
VB Macros - VB.NET - VisualStudio

Three Days
Experience with Windows 98, 2000, NT or XP. Pre-requisite: some programming experience.


Intro to Visual Basic Programming

• What is Visual Basic?
• Terminology
• Steps to create an application
• Modular environment

Building an Application

• Setting properties of objects
• Forms
• Introduction to controls
• Object-based, event-driven programming

Coding

• The Code Editor
• Using the Object Browser to view properties and methods of objects
• Statements and functions
• Conditional statements
• Looping statements
• Native code

Debugging

• Overview

Forms

• Showing and hiding forms
• Order of events
• Multiple forms
• Startup and end of application

Variables

• Data types
• Scope and lifetime of variables
• Constants
• Arrays and user-defined types

Procedures

• Introduction to procedures
• Arguments and parameters
• Named arguments and optional arguments

Controls

• Control formatting
• Standard controls
• Custom controls

Menus

• Creating and coding menus
• Custom pop-up menus

Error Handling

• An introduction to error handlers

Wizards

• The Package and Deployment Wizard
• Application Wizard

The Next Step

• Data access using the Data Form Wizard and the data control
• MDI forms
• Classes
• An introduction to ActiveX controls with Visual Basic





Programming Using Visual Basic for Applications
Beginning - VB.NET - VisualStudio

Full Day
Students must have advanced level skills in both Word and Excel to attend this session. Students will examine sample code, learn how to create macros from scratch, and add to previously created macros.

Introduction to Visual Basic for Applications

• Running a macro
• Recording a macro
• Examining module design

Assigning macros

• Specifying the location of recorded macros
• Assigning macros to menus, buttons, and toolbars

Creating decision-making code

• The if...Then decision structure
• The if...Then...Else decision structure
• The select Case decision structure

Using loop structures

• Using for For...Next statement
• Using a Do...Loop statement
• Using a For Each...Next statement

Macro management

• Personal Macro Workbook
• Assigning Sub procedures to run automatically

Recording a macro in Word

• Running a macro
• Recording a macro

Interactive macros

• Creating a custom message box
• Creating a custom input box
• Extracting data from Excel

Appendix A:

• Using macros in PowerPoint and Access

Appendix B:

• Debugging and testing code





Visual Basic .NET - Introduction
Beginning - VB Macros - VisualStudio

5 Full Days of Training
In this course you will learn Visual Basic.NET to create graphical user interface applications. To ensure your success, we recommend you first take Visual Studio.NET introduction.

Creating a User Interface in a Windows Forms Application

• Determine Properties
• Determine Form Controls
• Determine Control Properties
• Manipulate Grouped Controls
• Write Event Procedures

Working With Data and Variables

• Declare Variables and Constants
• Determine and Set Scope
• Perform Mathematical Calculations
• Create an Array
• Create a Structure to Implement a Custom Data Type
• Create a Collection
• Create an Enumeration

Controlling Program Flow

• Implement a Standard Module
• Manipulate Forms
• Create Functions
• Create Sub Procedures
• Write Decision Structures
• Write Loop Statements
• Debug Logic Errors
• Validate Data
• Implement Structured Exception Handling

Working with Classes

• Create a Class
• Create a Property Procedure
• Create a Method
• Create and Handle a Custom Event
• Set an Object's Initial Values Using a Constructor

Enhancing User Interface Functionality

• Add a Menu to a Windows Form
• Add Dialog Box Controls
• Add a Toolbar
• Add a Status Bar
• Create a Form Using Visual Inheritance
• Create a User Control
• Retrieve Data from an External Data Source
• Manipulate Data in a Windows Forms Application
• Create an Application Configuration File

Deploying Your Application

• Create a Deployment Project
• View Metadata
• Create and Deploy a Shared Assembly

Creating Web Applications

• Create a Web Forms Application
• Create a Web Service Application
• Consume a Web Service Application





Visual Studio.NET - Introduction
Beginning - VB Macros - VB.NET

Full Day
This course expands upon the basic concepts you learned in Visual Studio.NET tool. In this course, you learn how to IDE Windows in Visual Studio.NET to create the different .NET project types

Creating a Windows Forms Project

• Set up the Work Environment
• Set up a Windows Forms Project
• Arrange the Tool Windows
• Set General Preferences
• Add Controls
• Set Form and Control Properties
• Add Code using the Code Editor
• Resolve Errors

Interacting With a Database in a Windows Forms Project

• Configure a Data Adapter Using the Data Adapter Configuration Wizard
• Generate a Dataset
• Display Data from a Database in a Windows Forms Project
• Manipulate Data in a Windows Forms Project Using a DataGrid
• Create and display a Data Report Using the Standard Report Expert
• Deploy a Windows Forms Project

Creating a Web Forms Project

• Set up a Web Forms Project
• Add Form Controls to a Web Forms Project
• Use Code-Behind in a Web Form
• Display Data from a Database in a Web Page Using a DataGrid

Creating a Web Services Project

• Develop a Web Services Project
• Access a Web Service from a Web Forms Project
• Delete, Exclude, or Remove Solution, Project, or Folder Items