Who Should Attend

Programmers and designers who are interested in developing robust client/server applications that use RDMS databases, create COM components, create ActiveX controls and use the internet from their VB application.

Prerequisites

This course assumes that student has good working knowledge of Microsoft Visual Basic programming system. Potential students should be able to accomplish the following tasks before taking this training:

• Create an application with multiple forms and add functionality for multiple events to the controls on those forms
• Write a Function procedure and a Sub procedure, and invoke them from Event procedures
• Declare variables and use conditional statements
• Describe the purpose and use of each of the controls in the Toolbox
• Add a simple menu interface to an application
• Retrieve and validate information from a user
• Add a custom control to a project
• Describe the relationship between properties, methods and objects
• Add run- time error handling to an application• Run the application and use debug mode within the Visual Basic environment
• Create EXE file from the project files
• Design and use a relational database
• Use SQL syntax to create database queries

What you will learn

Students will learn to write a Microsoft Visual Basic-based application that accesses data from a database; write a Visual Basic-based application that uses components object model (COM) components; create an ActiveX control; create a COM component; and list the opportunities that Visual Basic developers have to incorporate Internet technologies into their applications.

Course Outline

1. Essentials of Microsoft Visual Basic
• Understanding V B-based development
• Creating an application
• Debugging and error handling
• Compiling an EXE file 
2. Using Visual Data Access Tools
• Universal data access
• Connecting to a data source
• Getting data from a connection
• Organizing and presenting data
3. Using Class Modules
• Designing an application
• Creating and using class modules
• Adding properties, methods, and events
• Creating data-bound class modules
4. Building ActiveX Controls
• Creating an ActiveX control
• Properties, methods, and events
• Testing a control
• Creating property pages
• Creating a data-bound control
• Creating a data source control
5. Using ActiveX Data Objects
• Handling data access errors
• Connecting to data source
• Retrieving data from a data source
• Sorting and searching data
• Using disconnected data
• Creating dynamic record sets
• Understanding performance considerations
6. Advanced Data Access Issues
• Overview of Microsoft SQL Server security
• Using cursors
• Enforcing data integrity
• Executing statements on a database
7. Using COM Components
• Introduction to using COM components
• Creating a client application
• Using Microsoft Internet Explorer
8. Building COM Components
• Introduction to COM components
• Creating COM components
• Creating an object model
• Adding error handling
9. Optimizing and Deploying an Application
• Optimizing an application
• Deploying an application
• Deploying an ActiveX control

Hands-on Workshops

• VB Coding Essentials
• Using visual data access tools
• Using class modules
• Building an ActiveX control
• Data-binding an ActiveX control
• Using ADO
• Advanced data access issues
• Using/Building COM Components
• Deploying the State U. Bookstore solution

Course Duration

Five (5) days

Course Schedule

Go to Epcom Course Schedule

Course Materials

• Comprehensive course workbook/summary 
• Course certificate of completion