About This Book
Intended Audience
Getting Started
Hardware Requirements
Software Rqquirements
Course Overivew
Features of This Book
Conventions Used in This Book
About The CD-ROM
Using this book to Prepare for Certification
Where to Fing Specific Skills in This Book
The Microsoft Certified Professional Program
Microsoft Certification Benefits
Technical Support
About the Authors
Chapter 1:Planning the Design of an Application
About This Chapter
Before You Begin
Lesson 1:Using the Microsoft Solutions Framework
Overview of Microsoft Solutions Framework
Microsoft Solutions Framework Models
Design Phases of the Solution Design Model
Your Role as Deeloper
Logical Design Tasks
Lesson Summary
Lesson 2:Designing a System Architecture
understanding Application Structure
Single-tier Applications
Two-tier Applications
Multi-tier Applications
Lesson Summary
Lesson 3:Using Visual SourceSafe
Overview of Visual SourceSafe
Practice :Adding Visual SourceSafe to Visual Basic
Visual SourceSafe Components
Managing Files in VSS
Reusing Visual SorceSafe Files
Using Administration Tools
Lesson Summary
Summary
Lab:Using the Microsoft Solutions Framework
Microsoft Solutions Framework
The Chateau St.Mark Hotel Reservation System
Review
Chapter 2:Creating the User Interface
About This Chapter
Before You Begin
Lesson 1:User Interface Disign Principles
Composition
Color
Images and Icons
Fonts
Menus
lesson Summary
Lesson 2:Managing Froms
Adding a Form to a Project
Using Form Events
Using Form Methods
Using the FormsCollelction
Lesson Summary
Lesson 3:Using Controls
Working with Controls
Using Control Arrays
Practice:Using Controls Arrays
Using the Controls Collection
Practice:Using the Add Method with a Controls Collection
Enhancing the User Interface
Lesson Summary
Lesson 4:Using Menus
Creating Menus at Design Time
Modifying Menus as Run Time
Lesson Summary
Smmary
Lab:Creating the Chateau St.Mark User Interface
EXercise1:Creating the User Interface
Exercise2:Adding Custom Controls to the Form
Exercise3:Adding a Menu Bar
Review
Chpater3:Validating and Processing suser Input
About This Chapter
Before You Begin
Lesson 1:Overveiw of Validation
The Importance of Validation
Types of Validation
Providing User Feedback
Using the SetFocus Method
Using the LostFocus Event
Lesson Summary
Lesson 2:Implementing Form-Level Validation
Form-Level Keyboard Handler
Enabling and Disabling Controls Based on Input
Practice :Enabling Disabling Controls
Lesson Summary
Lesson 3:Implementing Field-Level Validation
Using the Textbox Control Properties
Using Events for Field-Level Validation
Validation Functions
using the Masked Edit Control
The Validate Event
Practice:Using the Validate Event with Causes Validation Property
Lesson Summary
Summary
Lab:Adding Field and Form Level Validation
Exercise1:Controlling User Navigation
EXercise2:Field-Level Validation
Exercise3:Using the Validate and LostFocus Events
Exercise4:Form-Level Validation
Review
Chapter4:Using the Debugging Tools
About this Chapter
Befor You Begin Lesson 1:Debugging Your Application
Types of Errors
The Debug Menu(Toolbar)
Lesson Summary
Lesson 2:Testing Your Application
TheImmedeate Window
Using the Debug Object
using the Locals Window
Setting Watch Expressions
The Call Stack Dialog Box
Lesson Summary
Summary
Lab:DEbugging an Application
Review
Chapter5:Implementing Error Handkling
About This Chapter
Before You Begin
Lesson 1:Creating an Error handler
How Visual Basic Handles a Run-Time Error
Implementing a local Error Handler
Practice:Creatig a Error Handler
ERrors-Calling Chain
Disabling an Error Handler
Visual Basic ERror Handkling Options
Lesson Summary
lesson2:Using Inline Error Handling
Creating an Inline Error Handler
Disabling an Inline Error Handler
Lesson Summary
lesson3:Implementing Centralized Error Handling
Creating a Centralized Error Handler
Lesson Summary
Summary
Lab:Implementing Error Handling
Exercise1:IMplementing Procedural Error Handling
Exercise2:Implementing Inline Error Handling
Review
Chapter6:Introduction to Class Modules
About This Chapter
Before You Begin
Lesson 1:Introduction to COM
Component Obuect Model
Class Modules
Creating COM Components With Visual Basic
Lesson Summary
Lesson 2:Using Class Modules
Adding A Class MOdule to Project
Creating Objects form Components
Lesson Summary
Lesson 3:Creating Class Modules
Creating Property Procedures
Practice:Designing a Class Module
Creating Methods
Using the CHouse Class
Creatig Events
Declaring Custom Events
handling Events
Lesson Summary
Lesson 4:Using the Class Builder
Loading the Class Builder
Creating a New Class
Object Models
Lesson summary
Summary
Lab:Crating Class Modules
Exercise1:Creating Class Modules with the Class Builder
Chapter7:Introduction to ActiveX Documents
About This Chapter
Before Your Begin
Lesson 1:How Visual Basic Accesses Data
Data Access Interfaces
Relational Database Concepts
Lesson Summary
Lesson2:Introductions to OLE DB and ADO
What Is OLE DB?
How OLE DB Relates To ADO
Lesson Summary
Lesson 3:Overview of Structured Query Language
The SQL Select Statement
Lesson summary
Lesson 4:The ASO Data Control
Using the ASO DAta Control
Connecting to a Data Control
Practice:Connecting an ADO DAta Control to Data Source
Binding Controls
Practice:Binding Controls
Using the Data Form Wizard
Lesson Summary
lesson 5:Coding the ADO Data Control
Creatig Recordset
Modifying Records in a Recordset
Adding Records to a Recordset
Deleting Records from a Recordset
Searching for Records
Practice:Searching for Records in a Recordset
lesson summary
Summary
Lab:Using the ADO Data Control
Exercise1:Connecting to data source
EXercise 2:Binding controls to the ADO Data control
Review
Chapter8:Developing Solutions Using ADO
About This Chapter
Before You begin Lesson 1:Introducing the ADO Object Model
ADO Objects
ADO Collections
lesson Summary
Lesson 2:Connecting to a data Source
using a Connection Object
Creating a Connection Object in Code
Practice:Creating a Connection with Code
Connection Events
Lesson summary
Lesson 3:Retrieving Data
Retrieving Records with a Recordset Object
Retrieving Records with a Command Object
Practice:Returning Records from a Database
Lesson Summary
lesson 4:Navigating Records
Specifying a Cursor Type
Presenting Data to the User
navigating the Recordset
Lesson Summary
Lesson 5:Modifying Data
Locking a Recordset
Editing a Record
Adding a new Record
Deleting a Record
Lesson Summary
Lesson 6:Using the Data Environment
Creating a Connection
Presenting Records to the User
Practice:Presenting Records using a Data Environment
Lesson Summary
Summary
Lab:;using ActiveX Data Objects
Exercise1:Creating ADO Objects
Exercise2:Writing ADO Code
Review
Chapter9:Connecting to COM Servers
About This Chapter
Before You Begin Lesson 1:Connecting to COM Components
Review of COM Components
using Type Libraries
SEtting References
Lesson Summary
Lesson2:Managing COM Components
Overview of Automation
Declaring Object Variables
Instantiating an Object
Practice:Automating Microsoft Excel
using the Object Browser
Lesson Summary
lesson 3:Calling Win32 APIs
COM Components and Win32 DLLs
Extending Applications with the Win32 API
Creating Callback Procedures
Practioce:CReating a Callback Procedure
Lesson summary
Summary
lab:Connecting to COM Components
Exercise1:Connecting to Microsoft word
Exercise2:Connecting to Microsoft Excel
Review
Chapter10:Creating and manging COM Components
About This Chapter
Before You Begin
Lesson1:Overview of Creating COM Components
Designing COM Components
In-Process vs. out-of-Process Components
Component Project Templates
Lesson Summary
Lesson 2:Creating ActiveX Controls
What Is an ActiveX Control :
Control Classes
Practice:Creating an ActiveX Control
Implementing Your ActiveX Control
Practive:Texting YOur ActiveX Control
Making Your ActiveX Control a Data Source
Practice:Creating a Data Source Control
Lesson summary
Lesson 3:Creating ActiveX Code Components
Understanding Code Components
Creating an ActiveX Code Components
Practice:Creating an ActiveX DLL
The Instancing Property
Testing and Debugging
Lesson Summary
Lesson 4:Using the Visual Component Manager
Overview fo Visual Component Manager
Installing and Starting Visual Component Manger
Publishing Components
Finding Components
Reusing Components
lesson Summary
Summary
lab:Creating a Data-Aware Class
Lesson1:Making the CReservation Class a Data Source
EXercise2:Binding Controls to the CReservation class
EXercise3:Creating Recordset Navigation Controls
Exercise4:Implementing Reservation Processing Functionality
Review
Chapter11:Creating Internet Applications
About This Chapter
Before You Begin
Lesson1:Creating DHTML Applications
Revew fo the Internet and HTML
Visual Basic and Internet Development
Introduction to DHTML Applications
Modifying HTML with DHTML
Practice:Creating a DHTML Application
Lesson ssummary
lesson2:Creating ActiveX Documents
overview of ActiveX Documents
The UserDocument Object
Creating an ActiveX Document
Practice:Creating an ActiveX Document
Running and Debugging an ActiveX Document Project
Lesson Summary
Lesson3:Creatin IIS Applications Using WEbclasses
Overview of IIS Application
Using a WebClass to Repond to Client Requests
using the WebClass Designer
Writing Code for a WebClass
Debugging and Deploying Your IIS Application
Integration Between Visual Basic and Other Web Tools
Lesson Summary
Lab:Creating ActiveX Documents
Exercise1:Converting Forms to ActiveX Documents
Review
Chapter12:Packaging and Deploying an Application
About This Chapter
Before You Begin
Lesson1:Implementing Online Help
Properties of Help files
Implementing ToolsTips
Lesson summary
Lesson 2:Creating an EXecutable
Compiler Options
Using Conditional Compilation
Lesson Summary
lesson 3:Using Package and Deployment Wizard
Installing a Desktop Application
The Setup Toolkit
Allowing Uninstall
lesson Summary
Summary
Lab:Using Help files and the Package and Deployment Wizard
Exercise1:Applying help Files
Exercise2:SEtting compile Options in your Application
Exercise3:Using the Package and Deployments Wizard
Review
Appendix:Questions and Ansers
Glossary
Index