|
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
Skills
- 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
Top |
|
Module 2: Visual Basic Fundamentals
- Introduction to Controlling objects through Properties, Methods, and Events
- Working with forms and controls
Skills
- 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
Top |
|
|
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
Skills
- 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
Top |
|
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
Skills
- 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
Top |
|
|
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
Skills
- 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
Top |
|
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
Skills
- 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.
Top |
|
|
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
Skills
- 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
Top |
|
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
Skills
- 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
Top |
|
|
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
Skills
- 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
Top |
|
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
Skills
- 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
Top |
|
|
Module 11: Enhancing the User Interface
- Menus, StatusBars, Toolbars
Skills
- 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
Top |
|
Module 12: Drag and Drop
- Overview of Drag and Drop
- Mouse events
Skills
- 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
Top |
|
|
Module 13: More About Controls
- Collections and Control Arrays
Skills
- Define, describe and create a Control Array
- Dynamically add and delete controls
- Use the Visual Basic Controls Collection.
- Create and use object variables
Top |
|
Module 14: Finishing Touches
- User interface design principles
- Distributing an application
- Creating a default project
Skills
- Create a setup program for an application using the Package and Deployment Wizard
- Create custom projects
Top |
|
