Course Outlines
SQL
Visual Basic
Visual Basic for Applications
   

 

 

 

Visual Basic Designing & Implementing Desktop Applications Outline

Aims of the Two-Day Course

This course has been designed for experienced users to learn how to develop desktop applications using Visual Basic. The course is 100% hands-on, with exercises to help delegates practice the new skills they learn.

Course Content

  • Debugging and Error Handling Review
    • Debugging Techniques and Tools
    • Error Trapping

  • Introduction to COM
    • Class Modules
    • Building Class Modules manually
    • Using Class Builder

  • Using the Power of COM
    • Creating COM Components
    • Threading Models
    • Testing Components

  • Using COM Components
    • Using COM Components from Other Applications
    • Creating Objects for Components Four Ways

  • Introduction to Data Access
    • Adding the Data Environment Designer
    • Retrieving Data from Connection
    • Data Services and ADO

  • Presenting Data
    • Shaping and Organising Data
    • Presenting On-screen Data
    • Printed Reports
  • ActiveX Controls
    • ActiveX Controls and Constituent Controls
    • Using Layer of Automation to Provide Property and Method Visibility
    • Property Pages
    • Data Aware Controls

  • Implementing Help
    • Setting Help File Properties
    • Implementing Tool Tips

  • Package and Deployment Wizard
    • Preparing your Application
    • Optimising and Deployment
    • Deploying your Application

  • Visual SourceSafe
    • Adding Visual SourceSafe to your Project
    • Using Visual SourceSafe

  • Using SQL
    • SQL Overview
    • SELECT Statements
    • Cursors
    • Record Locking
    • Stored Procedures

  • Internet Applications
    • WebBrowser Control
    • What is an Active Document?

Prerequisites

Trainees must have completed the Visual Basic Introduction, or equivalent course. Trainees should also able to use Visual Basic to develop a simple Windows application, identify & correct errors and develop and work with Microsoft Word, Excel and Access files.

Duration

Twelve hours - 9.30am to 12.30pm and 1.30pm to 4.30pm on each day.

Please contact us for prices for this course

   
 
  Courses can be tailor made  
Contact Us Course Dates Prices Locations Courses Training Services About Us Home