Exclusive
Visual Studio

Mastering Microsoft Visual Basic 6 (VB) Development Classroom View
(Microsoft Training Course: 1013) - 5 days - £2640 exc VAT



> Target Audience
This course is intended for Visual Basic programmers who build desktop applications and access corporate databases
> Course outline
  1. Essentials of Microsoft Visual Basic
  2. Using Visual Data Access Tools
  3. Using Class Modules
  4. Building ActiveX Controls
  5. Using ActiveX Data Objects
  6. Advanced Data Access Issues
  7. Using COM Components
  8. Building COM Components
  9. Application
  10. Building Internet Applications

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]].
Module 1: Essentials of Microsoft Visual Basic
  • Understanding the Visual Basic development
  • Creating, testing, debugging and compiling an application
  • Overview the State University Bookstore application
Skills
  • Use Visual Basic to create and compile a simple application
  • List the files that comprise a Visual Basic-based application
  • Use Visual Basic debugging tools
  • Write run-time error handlers
top
Module 2: Using Visual Data Access Tools
  • Understand Universal Data Access
  • Connecting to a data source
  • Getting data from a Connection
  • Organizing and presenting data
Skills
  • Create a report using the Data Report Designer
top
Module 3: Using Class Modules
  • Designing an application
  • Creating class modules
  • Adding Properties, Methods, and Events
  • Creating data-bound class modules
Skills
  • Understand the benefits of using class modules in an application
  • Use a class module to create a COM object within Visual Basic
  • Create COM objects exposing properties, methods, and events
  • Create/use data-bound classes
top
Module 4: Building ActiveX Controls
  • Creating and testing an ActiveX control
  • Exposing properties, methods, and events
  • Creating property pages
  • Creating a data-bound control
  • Creating a data source control
Skills
  • Describe the benefits of using ActiveX controls
  • Create ActiveX controls exposing Properties, Methods, and Events
  • Use control events to save and load persistent properties
  • Test and debug ActiveX controls
  • Create and enable Property Pages for an ActiveX control
  • Enable data-binding capabilities of an ActiveX control
  • Create an ActiveX control as a data source
top
Module 5: Using ActiveX Data Objects
  • Overview of ActiveX Data Objects (ADO)
  • Handling data access errors
  • Connecting to a data source
  • Retrieving data from a data source
  • Sorting and searching data
  • Updating data
  • Creating/using Disconnected Recordsets
  • Creating dynamic Recordsets
  • Understanding performance considerations
Skills
  • Connect to a data source using ADO
  • Explain how to handle errors using ADO
top
Module 6: Advanced Data Access Issues
  • Overview of Microsoft SQL Server security
  • Using cursors
  • Enforcing data integrity
  • Executing statements on a database
Skills
  • Discuss SQL Server security implementations
  • Describe different cursor locations and when to use a specific cursor type
  • Use a stored procedure to execute a statement on a database
  • Handle referential integrity errors
  • Describe ways to enforce data integrity
top
Module 7: Using COM Components
  • Introduction to using COM components
  • Creating a client application
  • Using Microsoft Internet Explorer
Skills
  • List the main steps required to use an external COM component in a Visual Basic application
  • Create a Visual Basic client application that uses a COM component
  • Create a Visual Basic application that handles events from a COM component.
  • Create a Visual Basic application that automates Internet Explorer.
top
Module 8: Building COM Components
  • Introduction to COM components
  • Creating COM components
  • Creating an object model
  • Adding error handling
Skills
  • Compile a project with class modules into a COM component
  • Create an object model in a COM component
  • Debug and test a COM component
top
Module 9: Application
  • Optimising an application
  • Deploying an application
  • Deploying an ActiveX control
Skills
  • Describe a variety of techniques for optimising the performance of an application.
  • Use the GetSetting and SaveSetting statements to save application-specific information to the Registry
  • Use Resource Files
  • Create a Setup program using Package and Deployment Wizard
  • Package an ActiveX control for use on a Web site
  • Use the WebClass Designer to create server-side code components
top
Module 10: Building Internet Applications
  • Using the WebBrowser control
  • Creating Active Documents
  • Creating DHTML applications
  • Creating Microsoft Internet Information Server applications using WebClasses
Skills
  • List the ways Visual Basic can enhance a Web site
  • Create applications that use the Web Browser control
  • Explain the uses for Active Documents
  • Create an Active Document.
  • Use the DHTML Page designer to create client-side code components
top
> Pre-Requisites
Before attending this course, students are expected to have a fundamental programming competency with Visual Basic. The Visual Basic Fundamentals course 1303 satisfies the pre-requisite skills required for this course
    > Purpose
    This course will teach programmers how to create database applications using ActiveX components. On completion of the course, students will be able to:Write a Visual Basic-based application for database access. Write an application using component object model (COM) components. Create an ActiveX control. Incorporate Internet technologies into the Visual Basic applications
    > 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]].