Level 10
Drag & Drop
Automatic Drag & DropManual Drag & DropPutting it all Together
File & System Objects
The Dictionary Object
Overview of Dictionary ObjectSimple Dictionary ObjectUsing the Dictionary Object to hold Objects
Printing
Printer ObjectData Report DesignerCrystal Reports
Level 11 Component Development (2 Hrs)
Introduction to ActiveX Technology
COMDCOMCompound DocumentsIn-Place ActivationActive X ContainerActive X Server ComponentsActive Automation
Creating ActiveX Components
Types of ComponentsBuilding an Active X DLLCompiling the DLLDebugging the DLLFunction: Create ObjectBindingCreating an Active X EXERunning the DLL from ExcelDifferences between an Active X DLL & EXEs
Active X Components
RegisteringVersioningError Handling
Call-Backs & Events
What is a Call BackThe Server SideThe Client SideDisconnectingRaising Events
Threads & Instancing
ThreadsInstancingExampleThread Pool
Visual Component Manager
Visual Component Manager WizardSearching for Components in the RepositoryAdding a Component to a ProjectMaking the Repository SQL Server Based
Level 12 ActiveX Controls
Creating ActiveX Controls
What are ActiveX Controls?Steps in ActiveX Control CreationCreating an ActiveX ControlPropertiesLifetime EventsThe ActiveX Control WizardEventsMethodsUsing the Control
Advanced ActiveX Control Topics
Creating an About BoxAdding a Property PageAdditional Topics
Data Aware Controls
ActiveX Control ExamplesCreating Data Aware ControlsBinding Active X Controls to Data ControlsBinding an Address Control to an ADO Data ControlPutting an Active X Control into the Data Repeater
Active X Documents
OverviewActive X Migration WizardCreating an Active X Document from ScratchPassing Data from one Document to Another
Level 13 Client/Server Techniques
What is Client/Server
ConceptsNetwork File ServerSplitting the ApplicationWhere do you put the LogicDead Vs Live DataMulti-User ConsiderationsCursorsLock TypesCursor Limitations
ODBC & OLE DB Overview
What is ODBC?ODBC ComponentsODBC ArchitectureOLE DB
ADO
Asynchronous ConnectionsAsynchronous Recordset OperationsAsynchronous SamplesSubmitting an SQL Statement AsynchronouslyTransaction ProcessingLong Text FieldsMultiple Result SetsGet Rows & Get String MethodsRecordset PersistenceCursor & Lock TypesExamining Database Structure
Command Objects
Command ObjectsCommand Object ExampleInsert & Update StatementsPrepared vs. Non-prepared StatementsExecuting Stored Procedures with Parameters
Client Server Applications
Creating a Client Server ApplicationBenefits of List ApproachThe Sub Main RoutineLogging onData Entry Form TechniquesSaving & UpdatingThe Delete StatementEditingOther Data Entry Form Techniques
Level 14 Automation Programming
Introduction to Automation Programming
What is AutomationHow to use AutomationProgramming the Server
Automating Microsoft Excel
Help on ExcelExcel Object HierarchyDeclaring ExcelLooking at the CodePrinting & Loading Data from an Access DatabaseBuilding a GraphShutting down your VB ApplicationHidden Instances of Excel
Automating Microsoft Word
Building your own Mail Merge Capabilities using BookmarkUsing the Word Mail Merge FacilityRunning it from Visual BasicUsing the Documents Collection to Find a DocumentUsing the Word Spell Checking Feature in our VB ApplicationUsing Word as a Report SystemClosing our Document in Word
Automating Microsoft PowerPoint
Creating a PresentationCreating a Presentation from a Table
Automating Microsoft Outlook
Help on OutlookOutlook Object HierarchyDisplaying foldersDisplaying the Explorer WindowBringing up the Create Appointment WindowCreating the Appointment ProgrammaticallySending an E-mail
Automating Microsoft Access
Automating Microsoft SQL DMO
SQL Server DMOObject HierarchyDatabasesTables
Automating the Visual Basic Design Environment
Add-ins ToolbarAdd-ins ManagerExtracting Data out of the EnvironmentAdding a Sub MenuReplacing the Tools Procedures Attributes Menus
Level 15 - Multi-Tier Architecture A
Introduction To Multi-Tier Architecture
What is Multi-TierClient/Server Multi TierWhy Use Multi TierExamples of MT Services
Creating Reusable Classes
Overview of Reusable ClassesRegistry ClassINI ClassDatabase Connection ClassPreferences Class
Building Data Access Classes
Overview of Data Access ClassesLooking at the Data Access ClassPopulating the Class with DataMove next & FindInserting the Business rules into the ClassUpdate MethodDelete MethodClose Record Set & Copy Object
Building a Security System
LoginSecurity DLLDesigning the Security Form
Multi-Tier Application Template
Overview of Multi Tier Application TemplateSub MainConfig from INI & App config getPreferences ClassData Entry FormsData Entry FormsEditingWriting Keystroke HandlersPrompting the User to Save or undo when Closing the App.Solving List Problems
Level 16 - Multi-Tier Architecture B
Data Aware Classes
OverviewData Source ClassData Consumer ClassData Object Wizard
Distributed Computing
Microsoft Transaction Server
What is MTS?Why Use MTS?Hardware & Software Requirements to Install MTSInstallation & Setup Procedures for MTS?Developing an Application to run Under MTS?MTS Component FrameworkMTS DLL Graphic ExplorerStepping through the Client Side
Level 17 Internet Topics
Internet Controls
Web Browser ControlInternet Transfer Control
DHTML Applications
What is DHTML?Development EnvironmentDeploying your ApplicationCreating a DHTML ApplicationEventsDesign ConsiderationsAdvantages & Disadvantages of DHTML
Building Internet Information Server Applications
OverviewCreating IIS Applications in VB 6Active Server Pages Object ModelCreating an IIS Application from ScratchAdding HTML Templates to the ApplicationReplaceable TokensBuilding a Data Environment with a Command Object
|
