Table of Contents\r\n\r\nIntroduction\r\n\r\nChapter 1 Designing a distributed Solution\r\n\r\nGeneral Application Architecture\r\nFile Server Architecture\r\nClient/Server Architecture\r\nThe Services Design Model\r\nUser Services\r\nData Services\r\nBusiness Services\r\nArchitectural Options\r\nMultiple-Tier design and Performance\r\nMicrosoft Transaction Server\r\nScalability\r\nTransaction Support\r\nSecurity\r\nData Source Availability with Microsoft Message Queue\r\nOptimization of Database Roles\r\nDecision-Support Systems\r\nOnline Transaction Processing Systems\r\nThe Balancing Act\r\nInstalling and Configuring Visual Studio 6 components\r\nInstalling and Configuring Visual Basic 6\r\nInstalling SQL Debugging\r\nInstalling and Using Microsoft visual SourceSafe\r\nReview Questions\r\n\r\nChapter 2 Designing and Implementing the Data Tier\r\n\r\nDesigning he Data Tier\r\nThe Rules of Normalization\r\nDenormalization\r\nCreating and Managing Database Objects\r\nExploring Databases\r\nViewing and Modifying Tables\r\nRetrieving and Modifying Data with SQL Statements\r\nRetrieving Data with SQL\r\nModifying Data with SQL\r\nCorrelating Data with Join Statements\r\nUsing Transactions\r\nImplementing Transactions in SQL Server 7\r\nCreating Stored Procedures\r\nSummary\r\nReview Questions\r\n\r\nChapter 3 Accessing Databases with the ActiveX Data Objects\r\n\r\nAdo Basics\r\nGetting Comfortable with the ADO Object Model\r\nImplementing the ADO Data Control\r\nImplementing the ADO Model\r\nUsing the Connection Object\r\nUsing the Recordset Object\r\nOpening a Recordset\r\nDisplaying Data in a Recordset\r\nModifying Data through a Recordset\r\nUsing the Command Object\r\nUsing Stored Procedures\r\nSummary\r\nReview Questions\r\n\r\nChapter 4 Designing and Implementing the Business Tire\r\n\r\nComponents Defined\r\nClasses\r\nObjects\r\nComponents\r\nDesigning Components\r\nCollections and Objects\r\nDesigning Properties,Methods,and Events\r\nThe Nuts and Bolts\r\nCreating Object Models\r\nExercise Scenario\r\nExercise Solution\r\nCreation Components with Visual Basic6\r\nThe Visual Basic Component Project\r\nProject Properties\r\nClass Properties\r\nPreparing the Component Environment\r\nAdding Methods to a Component\r\nAdding Properties\r\nAdding Events\r\nCompiling and Registering the Component\r\nUsing Visual Component Manager\r\nPublishing a Component\r\nLocating a Component\r\nReusing a Component\r\nSummary\r\nReview Questions\r\n\r\nChapter 5 Creating ActiveX Controls\r\n\r\nCreating Simple ActiveX Controls\r\nThe ActiveX control Project\r\nCreating the Visual Interface\r\nTesting the Control\r\nAdding Custom Properties,Methods,and Events\r\nAdding Methods\r\nAdding Properties\r\nThe ActiveX Control Life Cycle\r\nAdding Events\r\nProperty Pages\r\nUsing The Property Page Wizard\r\nUsing Built-In Property Pages\r\nActiveX Controls and Data Binding\r\nCreating Data Bound controls\r\nCreating a Data Provider Control\r\nSummary\r\nReview Questions\r\n\r\nChapter 6 Designing and Implementing the Presentation Tier\r\n\r\nPresentation Fundamentals:Forms,Controls,Events,and Data Display\r\nWorking with Forms\r\nWorking with controls\r\nWorking with Events\r\nAdvanced Interface Controls\r\nInteractive presentation Features\r\nWorking with Menus\r\nWorking with Object collections and Arrays\r\nSummary\r\nReview Questions\r\n\r\nChapter 7 Creating a Data-Aware Client\r\n\r\nEnsuring User-Tier Data Integrity\r\nField-Level Validation\r\nForm-Level Validation\r\nModifying forms or controls Based on Input Values\r\nData Binding :Reaching Beyond the User Tier\r\nVisual Basic Data Source Tools\r\nUsing Manually Bound controls to Display Data\r\nUsing the Data Environment to Connect a Data source\r\nUsing the Data Form Wizard to Create Forms with Bound controls\r\nSummary\r\nReview Questions\r\n\r\nChapter 8 Calling COM Components\r\n\r\nAutomation Basics\r\nBinding\r\nCalling COM Components\r\nObject Variables\r\nAutomation External Objects\r\nCalling Custom components\r\nCommunicating Asynchronously with components\r\nUsing Events\r\nUsing Callback Procedures\r\nEvents vs.Callbacks\r\nSummary\r\nReview Questions\r\n\r\nChapter 9 Using Microsoft Transaction Server\r\n\r\nTransaction Server Fundamentals\r\nTransaction Activity\r\nScalability\r\nSecurity\r\nInstalling and configuring MTS\r\nDefinitions\r\nInstalling MTS\r\nManaging MTS Security\r\nCreating Components for MTS\r\nRequirements of MTS Components\r\nThe context Object\r\nReporting Transaction Status\r\nAdding Components to Packages\r\nWorking with Existing Packages\r\nSummary\r\nReview Questions\r\n\r\nChapter 10 Creating a Browser-Based Presentation Tier\r\n\r\nHTML Overview\r\nStructure Tags\r\nFormatting Tags\r\nList Tags\r\nForm Tags\r\nSpecial Tags\r\nUsing ActiveX Controls\r\nDownloading ActiveX controls\r\nImplementing ActiveX Controls\r\nActiveX Controls and Security\r\nImplementing VBS Cript\r\nVBScript Structures\r\nUsing VBScript with Objects\r\nCreating Dynamic HTML Pages with Visual Basic\r\nCreating Active Server Pages\r\nServer process Architectures\r\nUnderstanding Active Server Pages\r\nImplementing Active Server Pages\r\nIIS Applications and the WebClass\r\nobjects in an IIS Application\r\nWebClass Events\r\nA Walk-Through of an IIS Application\r\nWhere WebClasses Fit\r\nUsing Active Documents\r\nCreating Active Documents\r\nCoding the Active document\r\nWhere Active Documents Fit\r\nSummary\r\nReview Questions\r\n\r\nChapter 11 Creating Help Systems\r\n\r\nHTML Help or WinHelp\r\nPlanning an Online Help System\r\nChoosing a List of Topics\r\nCreating HTML Files\r\nImplementing a Help System\r\nUsing Microsoft HTML Help Workshop\r\nBinding Forms and Controls to the Help Files\r\nPassing Messages from Server components to the User\r\nSummary \r\nReview Questions\r\n\r\nChapter 12 Error Handling in the Distributed Application\r\n\r\nError Handling in the Client\r\nConfiguring Visual Basic for Error Handling\r\nIdentifying and Resolving Runtime Errors\r\nError handling in the component\r\nUsing the ADO Errors collection\r\nExamining the Errors Collection\r\nSummary\r\nReview questions\r\n\r\nChapter 13 Application Testing and Analysis\r\n\r\nthe Debug Tools\r\nEntering Break Mode\r\nSetting Watch Expressions\r\nWorking in Break Mode\r\nThe Callstack\r\nDebugging Distributed Application Elements\r\nProject Groups\r\nDebugging components and Controls\r\nSummary\r\nReview Questions\r\n\r\nChapter 14 Deploying a distributed Application\r\n\r\nUsing the visual Basic compiler\r\nCompiling Project files\r\nUsing Conditional Complication Constants\r\nCompiling from the Command Line\r\ndeployment Media and Methods\r\nfloppy Disk Deployment\r\nCD-ROM Deployment\r\nNetwork Deployment\r\nInternet Deployment\r\nDeploying Updates\r\nUsing the package and Deployment Wizard\r\nCreating a Setup program\r\nDeploying a Setup Package\r\nDeploying and Configuring MTS Components and Clients\r\nUsing the DCOM configuration utility\r\nSummary\r\nReview Questions\r\n\r\nAppendix A Answers to Review Questions\r\n\r\nAppendix B Strategies for Successful Test Taking\r\n\r\n/effective Study Techniques\r\nMnemonics\r\nRepletion\r\nVisualization\r\nMeaning-Making\r\nTest-Taking Skills\r\nBefore the exam\r\nSelecting the Right Answer\r\n\r\nAppendix C Microsoft SQL Server 7 Primer\r\n\r\nInstalling SQL Server\r\nSQL Server 7Versions\r\nInstalling SQL Server\r\nUsing SQL Server Client Utilities\r\nService Manager\r\nClient Network Utility\r\nServer network Utility\r\nEnterprise manager\r\nQuery Analyzer\r\nWhere to Get Additional Information\r\n\r\nClossary
无封面