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