Visual Basic 6.0 Workshop
Duration
Five Days
Objectives
At the completion of this course, the student will have:
Developed a VB application using multiple windows, all available controls, considerable VBA code and the ADO database tools for reading and updating local and remote databases.
Audience
Application Developers
Pre-requisites
Students should have experience using any version of Microsoft Windows. Familiarity with programming concepts in any language and familiarity with relational databases and SQL is also desirable.
Topics
- Maintaining Existing VB Applications
- Developing New VB Applications
- Visual Basic for Applications (VBA)
- Managing Forms
- Gathering Input
- Displaying Output
- Presenting Choices
- Database Capabilities
- Data Controls
- Database Object Libraries
- Preparing for the Real World
Course Outline
I. Maintaining Existing VB Applications
- Using the VB toolbars, toolbox, menus, etc.
- Changing properties of forms and controls; finding, changing code; using features of the code editor
- Debugging; getting Help online, the Internet, and other sources
II. Developing New VB Applications
- Project groups, projects, forms, modules and other files; naming and saving files
- Developing and enhancing a project, using basic controls such as text boxes, labels, command buttons and some basic VBA
III. Visual Basic for Applications (VBA)
- VBA syntax rules
- Variables, constants, arrays
- Conditional statements; looping; creating and invoking subroutines
- Functions for numbers, strings, dates; using Windows API and other external functions
- File processing; older file commands, File System Objects
IV. Presenting Choices
- Ordinary and data-bound List and Combo Boxes
- Menus and Toolbars
- Option Buttons and Check Boxes
V. Gathering Input
- Text controls; validating input; setting focus; selecting text
- Non-text controls such as Scroll Bars, Sliders, UpDown buttons, Calendar controls
VI. Displaying Output
VII. Managing Forms
- Making more space with tabs
- Managing multiple forms; MDI
VIII. Database Capabilities
- Accessing PC and client-server DBMS's, the role of ODBC
- Overview of ADO, DAO, RDO
- Using VisData
IX. Database Shortcuts
- Using a Data Control with bound DataGrid, Test Boxes
- Creating a report with the Data Environment and Data Report
X. Database Object Libraries
- The ADO object model
- Defining and using Recordsets
- Updating databases; using stored queries; transaction processing
XI. Preparing for the Real World
- Using Help files, tooltips and other forms of assistance
- Cleaning up and bullet-proofing the application
- Deploying the application with the Package and Deployment Wizard
