Database Training on CD-ROM - Training Resources

WordPerfect 9 Advanced ...File In A Document, Import Spreadsheets, Import Data From Database, Import Data From, Database Using Embedding, Import Data From Database Using Linking Method, Adding Data To The Database, Update A Link, Sorting The Updated Data Lesson 6: Using TextArt, Resizing The TextArt, Moving The TextArt, Working With Graphic Lines, Creating Page Borders, Watermarks, Edit Graphic Image Box, Resizing A  more...

Access 2000 User Series ... (26 Minutes) 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database (33 Minutes) 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting Records 2.5 Find and Replace 2.6 Modifying the Appearance of a Datasheet  more...

Access 2000 Beginning ... (26 Minutes) 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database (33 Minutes) 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting Records 2.5 Find and Replace 2.6 Modifying the Appearance of a Datasheet  more...

Access 2000 Intermediate ...rmediate (2 Hours 4 Minutes) 1.0 Planning and Designing a Database (20 Minutes) 1.1 Evaluating Inputs and Outputs 1.2 Normalization 1.3 Creating a Database Using a Wizard 1.4 Creating a Database from Scratch 2.0 Building and Modifying Tables (49 Minutes) 2.1 Creating Tables Using a Wizard 2.2 Creating Tables from Scratch & Data Types 2.3 Setting Primary Keys 2.4 Field Properties 2.5 Input Masks  more...

Access 2000 Advanced ...th Report Properties 2.5 Modifying Selection Criteria 3.0 Database Startup Options (5 Minutes) 3.1 Setting the Application, Icon, and Startup Form 3.2 Designing other Startup Information 4.0 Importing, Exporting and Linking (39 Minutes) 4.1 Exporting to another Database 4.2 Exporting to an Excel Spreadsheet 4.3 Exporting to ASCII 4.4 Exporting to HTML 4.5 Importing from anther Access Database  more...

Access 2000 Intermediate ...king With Tables, Introduction - Installing The Northwind Database, Opening Microsoft Access 2000, The Single-Click Option, The Find Feature, The Find In Field Dialog Box, Search Options, Using Replace, Filtering By Form, Creating Advanced Filters, Sorting In Form View, Printing Your Data In Form Style, The Compact On Close Option Lesson 2: Manipulating Table Structure, Introduction, Opening A  more...

Access 2000 Advanced ...on 1: Working With Menus And Toolbars,Opening An Existing Database,Access Sample Databases, Installing The Northwind Database, The Show Me Menu, Customizing Toolbars And Menus, Customizing Toolbars, Customizing Menus, Creating Custom Toolbars, Adding Commands To A Custom Toolbar, Sorting Records, Hiding A Toolbar, Deleting A Toolbar, Grouping Toolbar Commands, Modifying ToolTips, Creating  more...

Access 2002 Advanced ...on Objectives Opening Access Opening The Northwind Sample Database Exporting Data Viewing Exported Data Exporting Data In HTML Format Opening An HTML File Sharing Reports Emailing A Report The Snapshot Viewer Viewing An Attachment Printing A Report Creating Backward Compatible Databases Renaming A Database Opening A Converted Database The Upsizing Wizard Object Linking & Embedding Creating A  more...

Access 2002 Intermediate ...on Lesson Objectives Opening Access Opening The Northwind Database Customizing The Interface Creating A New Folder Other Options Changing The Default Database Folder Specifying Keyboard Behavior Setting Default Field Types & Sizes Creating A New Database Opening A Table Using Find Search Options Using Replace Filtering By Form Removing A Filter Creating An Advanced Filter Applying More Than One  more...

Access 2002 Basic ...Database Objects Introduction Lesson Objectives About Databases Access Database Files Opening Access The Title Bar The Menu Bar The Ask A Question List Box The Database Toolbar The Task Pane Navigating Between Task Panes The Clipboard Task Pane The Basic & Advanced Search Task Panes Closing The Task Pane The Status Bar Database Objects Opening A Sample Database About The Northwind Database The  more...

Access XP Essentials Set of 3 ...troduction 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database 2.1 Viewing & Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting & Deleting Records 2.5 Find & Replace 2.6 Modifying the Appearance of a Datasheet 2.7  more...

JAVA JDBC Servlets Set of 4 ...Databases 1.1 What is an rdbms? 1.2 Why are rdbmss Used? 1.3 Rdbms Choices 1.4 Structure of a Relational Database 1.5 Tables 1.6 Related Data 1.7 Structured Query Language 1.8 Sql Language Types 1.9 Proprietary SQLs 1.10 Ides with Database Support 1.11 Rdbmss and JAVA 2.0 Learning SQL 2.1 About mysql? 2.2 Installing and Running mysql 2.3 Mysql Syntax 2.4 Database Structure  more...

JAVA JDBC Servlets Set of 4 ...Databases 1.1 What is an rdbms? 1.2 Why are rdbmss Used? 1.3 Rdbms Choices 1.4 Structure of a Relational Database 1.5 Tables 1.6 Related Data 1.7 Structured Query Language 1.8 Sql Language Types 1.9 Proprietary SQLs 1.10 Ides with Database Support 1.11 Rdbmss and JAVA 2.0 Learning SQL 2.1 About mysql? 2.2 Installing and Running mysql 2.3 Mysql Syntax 2.4 Database Structure  more...

C Programming Set of 5 ....1 Introducing the IDE 2.2 Compiling 2.3 Debugging 2.4 Database Manipulation Tools 2.5 Getting Help 3.0 Language Fundamentals 3.1 Comments 3.2 Types 3.3 Creating Variables & Constants Using Value Types 3.4 Basic Expressions & Operators 3.5 Casting & Conversion 3.6 Building Enumerations 3.7 Control of Flow Level Two 1.0 Working with Classes & Objects 1.1 Class Basics 1.2  more...

C Programming Set of 5 ....1 Introducing the IDE 2.2 Compiling 2.3 Debugging 2.4 Database Manipulation Tools 2.5 Getting Help 3.0 Language Fundamentals 3.1 Comments 3.2 Types 3.3 Creating Variables & Constants Using Value Types 3.4 Basic Expressions & Operators 3.5 Casting & Conversion 3.6 Building Enumerations 3.7 Control of Flow Level Two 1.0 Working with Classes & Objects 1.1 Class Basics 1.2  more...

Oracle8iR2 Database Administration Set of 5 ...1 DBA Environment 1.2 Server Architectural Overview 1.3 Database Comps 1.4 Logical Storage Structure 1.5 Data Blocks 1.6 Tablespaces 1.7 Oracle8i JVM 1.8 Multithread Server 1.9 Optimal Flexible Architecture 1.10 DBA Products 1.11 Summary 2.0 Oracle Memory Structures & Processes (1 hr 2 min) 2.1 Setting up Environment 2.2 DB Buffer Cache 2.3 Multiple Buffer Cache Pools 2.4  more...

Exchange Server 2000 System Admin Set of 5 Administration Level 1 1.0 Overview of Exchange Server 1.1 Shared-file vs. Client-Server 1.2 Exchange 2000 Server Family 1.3 Exchange 2000 Server Features 2.0 Integration with Active Directory 2.1 AD Concepts Review 2.2 Schema 2.3 Domains 3.0 Exchange 2000 Server Architecture 3.1 Overview of Components 3.2 Communication Between Components 3.3 Message Flow in Exchange 2000 Server  more...

SQL Server 2000 Data Warehousing Set of 5 ...ing Level 2 1.0 Building a Data Mart 1.1 Creating the Database 1.2 Creating the Fact Table 1.3 Creating Dimension Tables 1.4 Creating Constraints and Indexes 2.0 Loading the Data Mart 2.1 Using Staging Tables 2.2 Using Transact SQL for Data Migration 2.3 Loading Data using Data Transformation Services 2.4 Advanced DTS Issues 2.5 Evaluating a Typical Load Scenario 3.0 Maintaining  more...

SQL Server 2000 Design Implement Databases Set of 6 ...Databases 1.1 What is a Database? 1.2 Relational Algebra 1.3 Relational Database Terms 2.0 Database Normalization 2.1 How to Normalize a Database 2.2 Case study: Employee Time Tracking System 3.0 An Overview of SQL Server 3.1 Features & Capacities 4.0 Creating Databases 4.1 SQL Server Databases & Logs 4.2 Files & FileGroups 4.3 Creating a Database 4.4 Database Size Planning 4.5  more...

SQL Server 2000 Design Implement Databases Set of 6 ...Databases 1.1 What is a Database? 1.2 Relational Algebra 1.3 Relational Database Terms 2.0 Database Normalization 2.1 How to Normalize a Database 2.2 Case study: Employee Time Tracking System 3.0 An Overview of SQL Server 3.1 Features & Capacities 4.0 Creating Databases 4.1 SQL Server Databases & Logs 4.2 Files & FileGroups 4.3 Creating a Database 4.4 Database Size Planning 4.5  more...

Windows 2000 Directory Services Level 4 ...for RIS 3.0 Backing Up & Restoring the Active Directory Database 3.1 Active Directory Backup Options 3.2 Backing Up Active Directory 3.3 Active Directory Restore Options 3.4 Performing a Non-Authoritative Restore 3.5 Performing an Authoritative Restore 4.0 Group Policy Inheritance Behavior & Delegation of Control 4.1 How To Allow, Override, or Block GPO Inheritance How To Delegate  more...

Windows 2000 Directory Services Level 4 ...for RIS 3.0 Backing Up & Restoring the Active Directory Database 3.1 Active Directory Backup Options 3.2 Backing Up Active Directory 3.3 Active Directory Restore Options 3.4 Performing a Non-Authoritative Restore 3.5 Performing an Authoritative Restore 4.0 Group Policy Inheritance Behavior & Delegation of Control 4.1 How To Allow, Override, or Block GPO Inheritance How To Delegate  more...

Draw 9 - Volume II ...ts Locking Objects Lesson 4: The Object Manager And Database Opening The Object Manager Unlocking Objects Using The Object Manager Creating A Layer, Renaming A Layer Changing The Active Layer Selecting Objects Using The Object Manager Moving And Copying Objects Between Layers Showing And Hiding A Layer The Layer Manager View Ordering Objects Ordering Objects Using  more...

Dreamweaver MX Web Applications ...ber of Team Macromedia) will teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia's Live Object and Server  more...

Delphi 5 Advanced Level 4 Advanced Level 4 (1 Hr 51 Mins) 1.0 Graphics & Animation (50 Mins) 1.1 Bitmaps 1.2 TCanvas 1.3 Loading & Saving Images 1.4 Loading & Copying TBitMaps 1.5 A 'Paint' Program 1.6 Animation 2.0 Making a Connection (20 Mins) 2.1 Error Messages to Expect 2.2 Logging On & Logging Off 3.0 Creating an Alias (10 Mins) 3.1 Using the Database Explorer 3.2 Creating a New Interbase Alias &  more...

Paradox 9 ObjectPAL ...Applying A Currency Format Retrieving Information From A Database Variable Declarations Data Types Supported By ObjectPAL Validating A Field Calculating Values Creating A New Method Attaching Code To A Form The Closer-Is-Better Principle Handling Key Violations Running The Form Locating Records The View Dialog Box Lesson 3: Comboboxes, Dialog Boxes and Tcursors Opening A Form  more...

Active Server Pages 3 Level 6 Level 6 (1 Hr 48 Mins) 1.0 Error Handling (28 Mins) 1.1 VB Script 1.2 JavaScript 2.0 3-Tier Architecture (36 Mins) 2.1 What is 3-Tier Architecture? 2.2 Building the Middle Tier with VB 2.3 Scalability with Component Services 3.0 Using Visual InterDev 6.0 (32 Mins) 3.1 What is Microsoft Visual InterDev? 3.2 Creating an ASP Project 3.3 Creating an ASP Page 3.4 Creating a Data  more...

Active Server Pages 3 Level 6 Level 6 (1 Hr 48 Mins) 1.0 Error Handling (28 Mins) 1.1 VB Script 1.2 JavaScript 2.0 3-Tier Architecture (36 Mins) 2.1 What is 3-Tier Architecture? 2.2 Building the Middle Tier with VB 2.3 Scalability with Component Services 3.0 Using Visual InterDev 6.0 (32 Mins) 3.1 What is Microsoft Visual InterDev? 3.2 Creating an ASP Project 3.3 Creating an ASP Page 3.4 Creating a Data  more...

Active Server Pages 3 Level 2 Level 2 (1 Hr 52 Mins) 1.0 ASP in Action (22 Mins) 1.1 Sample ASP Web Sites 1.2 Your Sample Application 2.0 The Server Object (19 Mins) 2.1 Server.Transfer & Server.Execute 2.2 Server.CreateObject 3.0 ActiveX COM DLL (32 Mins) 3.1 Authoring your Component in VB 3.2 Instantiating your Object & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1  more...

Active Server Pages 3 Level 2 Level 2 (1 Hr 52 Mins) 1.0 ASP in Action (22 Mins) 1.1 Sample ASP Web Sites 1.2 Your Sample Application 2.0 The Server Object (19 Mins) 2.1 Server.Transfer & Server.Execute 2.2 Server.CreateObject 3.0 ActiveX COM DLL (32 Mins) 3.1 Authoring your Component in VB 3.2 Instantiating your Object & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1  more...

Active Server Pages 3 Set of 6 ... your Object & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1 Creating a Database 4.2 Creating a Table 4.3 Creating a Login 4.4 Creating a Stored Procedure 4.5 Creating a View 4.6 Creating a Relationship 4.7 Creating a Trigger 5.0 Active X DataObjects (17 Mins) 5.1 Recordset Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data  more...

Active Server Pages 3 Set of 6 ... your Object & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1 Creating a Database 4.2 Creating a Table 4.3 Creating a Login 4.4 Creating a Stored Procedure 4.5 Creating a View 4.6 Creating a Relationship 4.7 Creating a Trigger 5.0 Active X DataObjects (17 Mins) 5.1 Recordset Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data  more...

Access 2002 Advanced ... Objectives Opening Access Opening The Northwind Sample Database Exporting Data Viewing Exported Data Exporting Data In HTML Format Opening An HTML File Sharing Reports Emailing A Report The Snapshot Viewer Viewing An Attachment Printing A Report Creating Backward Compatible Databases Renaming A Database Opening A Converted Database The Upsizing Wizard Object Linking & Embedding  more...

Access 2002 Intermediate ... Lesson Objectives Opening Access Opening The Northwind Database Customizing The Interface Creating A New Folder Other Options Changing The Default Database Folder Specifying Keyboard Behavior Setting Default Field Types & Sizes Creating A New Database Opening A Table Using Find Search Options Using Replace Filtering By Form Removing A Filter Creating An Advanced Filter  more...

Access 2002 Basic ...Database Objects Introduction Lesson Objectives About Databases Access Database Files Opening Access The Title Bar The Menu Bar The Ask A Question List Box The Database Toolbar The Task Pane Navigating Between Task Panes The Clipboard Task Pane The Basic & Advanced Search Task Panes Closing The Task Pane The Status Bar Database Objects Opening A Sample Database About The  more...

Dreamweaver MX Web Applications ...ber of Team Macromedia) will teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia's Live Object and Server  more...

Lotus Notes Domino R5 Set of 6 ... the Desktop 1.4 Accessing the Internet from Notes 2.0 Database Navigation (8 Minutes) 2.1 Navigating the KeyStone Rap Database 2.2 Printing 2.3 Read Vs unread marks 2.4 Navigating the KeyStone Address Book 3.0 Working with Documents (19 Minutes) 3.1 Formatting Text 3.2 Adding Pictures 3.3 File Attachments 3.4 Embedded Objects 3.5 Tables & Sections 3.6 Spell Checker 3.7 Saving  more...

Visual Basic 6 0 LV 7 Level 7 (1 Hour 48 Minutes) 1.0 Using ADO Objects (48 min) 1.1 Properties and Methods of the Connection Object 1.2 Properties and Methods of the Recordset Object 1.3 Recordset Types 1.4 Creating a Data Entry form Using ADO 1.5 Error Handling 1.6 Multi-User Concepts 2.0 Visual Database Tools (43 min) 2.1 Data Environment 2.2 Data View Window 2.3 Query Designer window 2.4 SQL  more...

Visual Basic 6 0 Multi-Tier Fundamentals LV 15 ... Reusable Classes 2.2 Registry Class 2.3 INI Class 2.4 Database Connection Class 2.5 Preferences Class 3.0 Building Data Access Classes (39 min) 3.1 Overview of Data Access Classes 3.2 Looking at the Data Access Class 3.3 Populating the Class with Data 3.4 Move next & Find 3.5 Inserting the Business rules into the Class 3.6 Update Method 3.7 Delete Method 3.8 Close Record Set  more...

Visual Basic 6 0 Automation Programming LV 14 ...at the Code 2.5 Printing and Loading Data from an Access Database 2.6 Building a Graph 2.7 Shutting down your VB Application 2.8 Hidden Instances of Excel 3.0 Automating Microsoft Word (28 min) 3.1 Building your own Mail Merge Capabilities using Bookmarks 3.2 Using the Word Mail Merge Facility 3.3 Running it from Visual Basic 3.4 Using the Documents Collection to Find a Document  more...

Visual Basic 6 0 Client Server Techniques LV 13 ...t Persistence 3.10 Cursor and Lock Types 3.11 Examining Database Structure 4.0 Command Objects (15 min) 4.1 Command Objects 4.2 Command Object Example 4.3 Insert and Update Statements 4.4 Prepared vs. Non-prepared Statements 4.5 Executing Stored Procedures with Parameters 5.0 Client Server Applications (44 min) 5.1 Creating a Client Server Application 5.2 Benefits of List  more...

Access 2000 Beginning ...6 Minutes) 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database (33 Minutes) 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting Records 2.5 Find and Replace 2.6 Modifying the Appearance of  more...

Access 2000 User Set of 5 ...6 Minutes) 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database (33 Minutes) 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting Records 2.5 Find and Replace 2.6 Modifying the Appearance of  more...

Access 2000 Application Developer Set of 16 ...f Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1 Building a New Table 2.2 Selecting the Appropriate Field Type 2.3 Working with Field Properties 2.4 The Primary Key  more...

Access 2000 Application Developer Set of 16 ...f Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1 Building a New Table 2.2 Selecting the Appropriate Field Type 2.3 Working with Field Properties 2.4 The Primary Key  more...

Access 2000 Application Developer Set of 16 ...f Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1 Building a New Table 2.2 Selecting the Appropriate Field Type 2.3 Working with Field Properties 2.4 The Primary Key  more...

Cold Fusion 4 5 Level 1 Level 1 (1 hr 53 mins) 1.0 What is Cold Fusion? (18 mins) 1.1 Overview of Cold Fusion 1.2 Internet Protocols 1.3 Clients-Side Scripting 1.4 Server-Side Scripting 1.5 Comparing ASP and JSP to CF 1.6 When is Cold Fusion Better? 1.7 Who is Using Cold Fusion? 1.8 Allaire Product Suite 2.0 Your First Cold Fusion Page (39 mins) 2.1 Your First CFM Page 2.2 HTML vs. CFM 2.3 Setting  more...

Access 2000 Intermediate ...diate (2 Hours 4 Minutes) 1.0 Planning and Designing a Database (20 Minutes) 1.1 Evaluating Inputs and Outputs 1.2 Normalization 1.3 Creating a Database Using a Wizard 1.4 Creating a Database from Scratch 2.0 Building and Modifying Tables (49 Minutes) 2.1 Creating Tables Using a Wizard 2.2 Creating Tables from Scratch & Data Types 2.3 Setting Primary Keys 2.4 Field Properties  more...

Access 2000 Advanced ...Report Properties 2.5 Modifying Selection Criteria 3.0 Database Startup Options (5 Minutes) 3.1 Setting the Application, Icon, and Startup Form 3.2 Designing other Startup Information 4.0 Importing, Exporting and Linking (39 Minutes) 4.1 Exporting to another Database 4.2 Exporting to an Excel Spreadsheet 4.3 Exporting to ASCII 4.4 Exporting to HTML 4.5 Importing from anther Access  more...

Access 2000 Web Security ...d 3.0 Security Basics (10 Minutes) 3.1 Establishing a Database Password 3.2 Modifying a Database Password 3.3 Encrypting and Decrypting a Database 4.0 Replication Basics (23 Minutes) 4.1 Introduction to Replication 4.2 Converting a Database to a Design Master 4.3 Creating Additional Replicas 4.4 Synchronizing Changes 4.5 Managing Conflicts 5.0 Developing Apps with Macros (29  more...

Lotus Domino 5 Application Development LV 1 ...lopment Level 1 (1 Hour 32 Minutes) 1.0 How to Create a Database (8 Minutes) 1.1 Creating a Database from Blank and using a Template 1.2 Creating a Database from another Database 2.0 Documents, Forms and Views (3 Minutes) 2.1 Differences between Documents, Forms and Views 3.0 Building Forms (37 Minutes) 3.1 Fields in a Form 3.2 Previewing on the Web 3.3 Combo Boxes & Rich Text  more...

Access 2000 Application Developer Set of 16 ...es of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1 Building a New Table 2.2 Selecting the Appropriate Field Type 2.3 Working with Field Properties 2.4 The Primary Key 2.5 The Lookup Feature 2.6  more...

Access 2000 Application Developer LV 1 ...es of Applications You Can Develop 1.2 What Exactly is a Database 1.3 Getting to Know the Database Objects 1.4 Object Naming Conventions 1.5 Hardware Requirements 1.6 Getting Started Developing an Application 2.0 Tables (39 Minutes) 2.1 Building a New Table 2.2 Selecting the Appropriate Field Type 2.3 Working with Field Properties 2.4 The Primary Key 2.5 The Lookup Feature 2.6  more...

Access 2000 Application Developer LV 6 ... Records 4.3 Adding Records 5.0 Creating and Modifying Database Objects Using Code (15 Minutes) 5.1 Adding a Table 5.2 Removing a Table 5.3 Establishing Relationships 5.4 Creating Queries 6.0 Data Access Objects a a A Crash Course (32 Minutes) 6.1 The DAO Object Hierarchy 6.2 DAO Recordset Types 6.3 DAO Recordset Properties and Methods 6.4 Sorting, Filtering, and Finding  more...

Access 2000 Application Developer LV 8 ...Preparing an Application for Distribution 2.5 EXE versus Database 2.6 The Importance of Security 2.7 Access as a Front-end 3.0 Developing Multi-user Applications (36 Minutes) 3.1 Developing with Multi-users in Mind 3.2 Access Locking Mechanisms 3.3 Locking and Refresh Strategies 3.4 Form & Other Locking Strategies 3.5 Recordset Locking 3.6 Effectively Handling Locking Conflicts 3.7  more...

Access 2000 Application Developer LV 9 ...rd 1.6 Defining an ODBC Data Source 1.7 Connecting to a Database Server 1.8 Building a Client/Server Application from the Get Go 2.0 Client/Server Strategies (22 Minutes) 2.1 Selecting the Best Recordset Type 2.2 Pass-through Queries and Stored Procedures 2.3 Using Access Data Projects 2.4 Optimizing Data Handling 2.5 Optimizing Queries and Forms 3.0 Client/Server Application (18  more...

Access 2000 Application Developer LV 10 ...lication Topologies 2.5 Changes Replication Makes to the Database & Making a Database Replicable 2.6 Creating Additional Replicas 2.7 Synchronizing Replicas & Resolving Replication Conflicts 2.8 Partial Replication 2.9 Implementing Replication Using Code 3.0 The Replication Manager (30 Minutes) 3.1 Running the Replication Manager for the First Time 3.2 Replicating a Database with the  more...

Access 2000 Application Developer LV 13 Application Development Level 13 (2 Hours 2 Minutes) 1.0 Exploiting the Power of Class Modules (59 min) 1.1 Exploring the Benefits of Class Modules 1.2 Object Orientation a a An Introduction 1.3 Creating and Using a Class Module 1.4 Creating Multiple Class Instances 1.5 The Initialize and Terminate Events 1.6 Class Module Examples 1.7 Working with Custom Collections 2.0  more...

Access 2000 Application Developer LV 14 ... 1.1 What's New with Access and the Internet 1.2 Saving Database Objects as HTML 1.3 Linking to HTML Files 1.4 Importing HTML Files 1.5 Deciding Between Static and Dynamic HTML Formats 1.6 Working with Active Server Pages 1.7 Testing ASP Files 1.8 Working with HTX/IDC Files 1.9 Working with HTML Templates 2.0 Data Access Pages (50 Minutes) 2.1 Understanding Data Access Pages 2.2  more...

Access 2000 Application Developer LV 15 ...r 5 Minutes) 1.1 Share-Level Security 1.2 Encrypting a Database 1.3 User-level Security a a An Introduction 1.4 Creating a Workgroup 1.5 Changing the Password for Admin 1.6 Setting Up an Administrative User 1.7 Securing a Database 1.8 Creating Users and Groups 1.9 Assigning Rights to Users and Groups 1.10 Creating an MDE File 1.11 Special Issues 2.0 Advanced Security (45  more...

Access 2000 Application Developer LV 16 ...ng Your Application to be Self-Documenting 1.2 Using the Database Documenter 1.3 Writing Code to Create Documentation 2.0 Maintaining Your Application (16 Minutes) 2.1 Compacting & Repairing Your Database 3.0 The Microsoft Office Developer (26 Minutes) 3.1 Distributing Your Application 3.2 Looking at the MOD 4.0 Managing the Development Process with Visual SourceSafe (21 Minutes)  more...

WordPerfect 9 Advanced ...File In A Document, Import Spreadsheets, Import Data From Database, Import Data From, Database Using Embedding, Import Data From Database Using Linking Method, Adding Data To The Database, Update A Link, Sorting The Updated Data Lesson 6: Using TextArt, Resizing The TextArt, Moving The TextArt, Working With Graphic Lines, Creating Page Borders, Watermarks, Edit Graphic Image Box,  more...

Quattro Pro 9 Intermediate ...diate Lesson 1: Opening Quattro Pro 9, Creating A Database, Creating Database Fields, Entering Records Using Data Forms, Entering Records Manually, Sorting The Records, Multiple Sort Criteria, Navigating Records With The Data Form Dialog Box, Locating A Record Using Search Criteria, Changing A Record, Deleting Records Using The Data Forms Dialog Box, Saving A File, Using The Database  more...

Paradox 9 Volumes I II ...l Paradox 9 Volume 1 Lesson 1: Exploring Paradox 9 And Database Concepts Introduction To Database Systems Paradox 9 And Normalization Opening Paradox 9 The Welcome Screen Opening An Existing Database Displaying Forms Displaying Reports Displaying Tables Opening The Table Examining Table Structure Navigating Through Records Appending A New Record Switching To Edit  more...

Paradox 8 Volumes I II ...Introduction, Where to Start, Startup With an Expert, The Database Expert, Doorways to a New Table, The NEW Dialog Box, The Table Expert, Doin' It Yourself, Borrowing a Table's Structure, Building a New Table, Entering a Field Name, Selecting a Field Type, Field Size, To "Key" or Not to "Key", The Memo Field Types, The Data Field, A Telephone Number Field, Rearranging the Field Roster, Table  more...

SQL Server 7 0 Data Warehousing Set of 4 ...uirements 2.2 The Data Warehousing System 2.3 Comparing Database Modeling Environments 2.5 Using a Star Schema 2.6 Using a Snowflake Schema 2.7 Choosing a Schema 2.8 Choosing a Grain 2.9 Defining Dimension Characteristics 2.10 Defining Conventional Dimensions 2.11 Sharing Dimensions 2.12 Defining other Types of Dimensions 2.13 Defining the Fact Table 2.14 Defining Pre-calculations  more...

SQL Server 7 0 Data Warehousing Level 1 ...uirements 2.2 The Data Warehousing System 2.3 Comparing Database Modeling Environments 2.5 Using a Star Schema 2.6 Using a Snowflake Schema 2.7 Choosing a Schema 2.8 Choosing a Grain 2.9 Defining Dimension Characteristics 2.10 Defining Conventional Dimensions 2.11 Sharing Dimensions 2.12 Defining other Types of Dimensions 2.13 Defining the Fact Table 2.14 Defining Pre-calculations  more...

SQL Server 7 0 Data Warehousing Level 2 ...ng the Data Warehouse (15 Mins) 1.1 Overview 1.2 Build Database 1.3 Build Dimension Tables 1.4 Using Scripts & Building a Fact Table 2.0 Validating and Transforming Data (53 Mins) 2.1 Process Overview 2.2 Methods of Populating a Data Warehouse 2.3 Tools for Populating a Data Warehouse 2.4 Transact-SQL 2.5 Distributed Query 2.6 bcp Utility and the BULK INSERT Statement 2.7 Data  more...

SQL Server 7 0 Data Warehousing Level 4 SQL 7.0 Data Warehousing Level 4 (1 Hr 32 Mins) 1.0 Building OLAP Clients (27 Mins) 1.1 Overview of Client/Server Architecture 1.2 ADO MD, Catalog Object & Cubedef Object 1.3 Retrieving Data About Cubes & Using Cellsets 1.4 Creating Local Cubes through MDX & ADO MD 2.0 Microsoft English Query (35 Mins) 2.1 Introduction to Microsoft English Query 2.2 Domains, Entities, &  more...

Lotus Domino R5 Application Development Level 1 ...lopment Level 1 (1 Hour 32 Minutes) 1.0 How to Create a Database (8 Minutes) 1.1 Creating a Database from Blank and using a Template 1.2 Creating a Database from another Database 2.0 Documents, Forms and Views (3 Minutes) 2.1 Differences between Documents, Forms and Views 3.0 Building Forms (37 Minutes) 3.1 Fields in a Form 3.2 Previewing on the Web 3.3 Combo Boxes & Rich Text  more...

Lotus Domino R5 Application Development Update Level 2 ... Implementing Application Performance (53 min) 1.1 New Database Properties 1.2 New Form Properties 1.3 New Field Properties 1.4 New View Properties 1.5 Navigators 1.6 Image Resources, Shared Actions 2.0 Formula Language Changes (29 min) 2.1 New @Functions 2.2 New @Commands 3.0 Quiz (24 min) 3.1 What are the ways to launch the Designer? 3.2 What are the names of the tabs in  more...

Lotus Domino R5 System Administration Level 3 Level 3 (1 hr 48 mins) 1.0 Internet Mail Standards (21 mins) 1.1 SMPT Mail Concepts 1.2 POP3 1.3 IMAP 1.4 LDAP 1.5 Web Mail 1.6 Adjacent & Non-Adjacent Domains 2.0 ID Files (19 mins) 2.1 User ID’s 2.2 Security Features 2.3 Certificates & OU’s 2.4 Alternate Names 3.0 Domino Security (51 mins) 3.1 Domains & Servers 3.2 Database 3.3 Advanced Options 3.4 Documents  more...

Lotus Domino R5 System Administration Level 4 Level 4 (1 hr 45 mins) 1.0 Replication (39 mins) 1.1 Replica ID, New Replicas & Replica Settings 1.2 Replica History 1.3 Document & Field Level Sequence Numbers 1.4 Replication Conflict & Replication Maps 1.5 ACL & Replication 2.0 Setting up Replication (23 mins) 2.1 Ways to Make Replication 2.2 Connection Documents & Priority of Database 2.3 Multiple Replicates 2.4 Directory  more...

Lotus Domino R5 System Administration Update Level 2 ...Database Management (25 min) 1.1 New OPS 1.2 Transaction Log 1.3 Database Properties 1.4 Domain Search 1.5 Other File & Database Tools 2.0 Directory Assistance & Catalog (29 min) 2.1 Directory Catalog 2.2 Directory Assistance 3.0 Messaging (16 min) 3.1 Just in Time Encryption 3.2 Using Holidays 3.3 Message Tracking 3.4 Native Mime Support 3.5 Shared Mail 3.6 Maps 4.0  more...

Windows 2000 Network Infrastructure Level 4 ...) 1.0 WINS (23 mins) 1.1 Name Resolution 1.2 NetBIOS Databases & Name Release 2.0 Implementation of WINS (23 mins) 2.1 WINS Requirements 2.2 Installing a WINS Server 2.3 Configuring & Registering Clients 2.4 The WINS Database 3.0 Advanced WINS Topics (1 hr 6 mins) 3.1 WINS Proxy Agents & Non-WINS Clients 3.2 Static Mapping 3.3 Time-to-Live 3.4 Data Replication between WINS  more...

Windows 2000 Network Infrastructure Level 4 ...) 1.0 WINS (23 mins) 1.1 Name Resolution 1.2 NetBIOS Databases & Name Release 2.0 Implementation of WINS (23 mins) 2.1 WINS Requirements 2.2 Installing a WINS Server 2.3 Configuring & Registering Clients 2.4 The WINS Database 3.0 Advanced WINS Topics (1 hr 6 mins) 3.1 WINS Proxy Agents & Non-WINS Clients 3.2 Static Mapping 3.3 Time-to-Live 3.4 Data Replication between WINS  more...

Crystal Reports 8--Level 5 ... 5 (1 Hr 40 Mins) 1.0 Working with Data (54 Mins) 1.1 Databases Overview 1.2 Aliases 1.3 Indexes 1.4 Relationships 1.5 SQL & SQL Databases 1.6 Server-side Processing 1.7 Mapping Database Fields 1.8 Working with Different Types of Data 1.9 Advanced Database Features 1.10 Reporting on the NT Event Log 1.11 Reporting on Exchange or Outlook Data 2.0 Using SQL (Structured Query  more...

Visual InterDev 6 0 Level 5 ...Databases (1 Hour 32 Minutes) 1.0 Visual Data Source (30 min) 1.1 Creating a Database Project 1.2 Working with Tables 1.3 Creating a View 1.4 Database Diagram 1.5 Stored Procedures 1.6 Triggers 2.0 Connecting the Database to the Web Application (4 min) 2.1 Connecting to the Database 3.0 Data Aware DTC's (30 min) 3.1 Creating Data Enabled Pages & Recordset Options 3.2 Form  more...

Access 2000 - Proficient ... users of Microsoft Access 2000.Access 2000 builds on the database capabilities of previous versions of the program to provide powerful tools for building and maintaining professional databases.Topics include basic database concepts,planning a database, creating and modifying tables and forms,finding and sorting data,working with queries,creating reports,and working on the web. DiscoverWare  more...

Access 2000 Expert ...cess 2000 & Access 97 Access 2000 & Access 95 Convert A Database Set Startup Options Set Startup Options Help In Access 2000 The Office Assistant Microsoft Access Help Window Help Menu Detect And Repair 2. Build a Database Build A Relational Database Relationships: Overview Establish A One-To-One Relationship Establish A Many-To-Many Relationship Edit A Relationship Set  more...

Cold Fusion 4 5 Level 1 Level 1 (1 hr 53 mins) 1.0 What is Cold Fusion? (18 mins) 1.1 Overview of Cold Fusion 1.2 Internet Protocols 1.3 Clients-Side Scripting 1.4 Server-Side Scripting 1.5 Comparing ASP and JSP to CF 1.6 When is Cold Fusion Better? 1.7 Who is Using Cold Fusion? 1.8 Allaire Product Suite 2.0 Your First Cold Fusion Page (39 mins) 2.1 Your First CFM Page 2.2 HTML vs. CFM 2.3 Setting  more...

Access XP Proficient Expert ...for users of Microsoft Access XP. Access XP builds on the database capabilities of previous versions of the program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. Topics cover basic database concepts such as planning, forms, and data management, to more advanced concepts including sorting, filtering,  more...