Query On Training on CD-ROM - Training Resources

Access 2000 User Series Access 2000 Beginning (2 Hours 6 Minutes) 1.0 Introduction (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  more...

Access 2000 Intermediate Access 2000 Intermediate (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 Intermediate LESSON_STR Access 2000 Intermediate Lesson 1: Working 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:  more...

Access 2000 Advanced LESSON_STR   Access 2000 Advanced Lesson 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,  more...

Excel 2000 Advanced LESSON_STR   Excel 2000 Advanced Lesson 1: Working With Records And Filters, Opening Excel, Bringing Data From A Web Page Into Excel, Hiding Toolbars, Increasing Your Field Of View, The Sort Dialog Box, "Then by" Sorting, Using AutoFilter, Using Custom AutoFilter, Using The Data Form Dialog Box, Verifying A Record, Change A Record, Deleting A Record, Disabling AutoFilter, Removing Filters,  more...

Access 2002 Advanced Lesson 1: Sharing Data Introduction Lesson 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  more...

Access 2002 Intermediate Lesson 1: The Access Interface Introduction 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  more...

Access 2002 Basic Lesson 1: The Access Interface & 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  more...

Excel 2002 Advanced Lesson 1: Sorting & Filtering Data Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View Sorting Data Then By Sorting Using AutoFilter Using  more...

NET Set of 7 Level 1 1.0 Overview of the .NET Platform 1.1 Overview of .NET 1.2 Common Language Specification 1.3 Common Type System 1.4 .NET Applications 1.5 ADO.NET 1.6 Security Services 1.7 Why Migrate to .NET 1.8 Benefits of Using.NET 1.9 How to Migrate 2.0 Introduction to Visual Studio.NET 2.1 Overview to Visual Studio.NET 2.2 Project Templates 2.3 Getting Started with VS.NET 2.4  more...

NET Set of 7 Level 1 1.0 Overview of the .NET Platform 1.1 Overview of .NET 1.2 Common Language Specification 1.3 Common Type System 1.4 .NET Applications 1.5 ADO.NET 1.6 Security Services 1.7 Why Migrate to .NET 1.8 Benefits of Using.NET 1.9 How to Migrate 2.0 Introduction to Visual Studio.NET 2.1 Overview to Visual Studio.NET 2.2 Project Templates 2.3 Getting Started with VS.NET 2.4  more...

Access XP Essentials Set of 3 Beginning 1.0 Introduction 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  more...

JAVA JDBC Servlets Set of 4 Level 1 1.0 Introduction to 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  more...

JAVA JDBC Servlets Set of 4 Level 1 1.0 Introduction to 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  more...

SQL Server 2000 Data Warehousing Set of 5 Data Warehousing Level 1 1.0 Introduction 1.1 Topic Overview 1.2 Transactional vs. Analytical Data Systems 1.3 Data Warehouse Defined 1.4 Data Warehouses vs. Data Marts/OLAP 2.0 Dimensional Modeling & Planning 2.1 Entity-Relationship Modeling vs. Dimensional Modeling 2.2 Elements of the Dimensional Model 2.3 The Role of User Requirements 2.4 Identifying Source Data 2.5 Implementing  more...

SQL Server 2000 Design Implement Databases Set of 6 Designing and Implementing Level 1 1.0 Relational 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  more...

SQL Server 2000 Design Implement Databases Set of 6 Designing and Implementing Level 1 1.0 Relational 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  more...

Windows 2000 Server Admin --Volume 5 Lesson 1: Terminal Services Installing Terminal Services Creating A Terminal Services Client Installing A Terminal Services Client Terminal Services Client Setup Connecting To The Terminal Server Logging On To A Terminal Server Testing The Services Verifying The Contents Of A Client Folder Opening The Terminal Services Manager Viewing The Connection Status Of A User Sending A Message To A Client  more...

Windows 2000 Server Admin --Volume 2 ...ole Installing A Caching-only DNS Server Testing A Simple Query On A DNS Server Lesson 3: DHCP Server DHCP Overview DHCP Architecture Benefits Of DHCP Preparing To Introduce DHCP Servers In A Network Installing A DHCP Server Opening The DHCP Console Deleting A DHCP Server Adding A DHCP Server Creating A New Scope Activating A Scope Setting Scope Options Stopping A DHCP Server Starting A  more...

Dreamweaver MX Web Applications This is the second course in a series of tutorials from the Virtual Training Company for Dreamweaver MX. It covers all that techniques required to construct a data driven web site. Author Mark Fletcher (a member 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  more...

Paradox 9 ObjectPAL Lesson 1: Introduction To ObjectPAL Opening Paradox 9 Opening A Form Introduction To ObjectPAL The Object Explorer Window The Object Tree Pane Introduction To Object Trees The Tabbed Pane The Appearance Tab The Properties Tab The Methods Tab ObjectPAL Code The If Structure The VCR Control The Back Event The FastBack Event The FastForward Event The FirstRecord Event The Forward  more...

GroupWise 5 5 Lesson 1: Getting To Know The GroupWise Window Introduction Opening GroupWise The GroupWise Window The Mailbox Folder The Sent Items Folder The Calendar Folder The Task List Folder The Work In Progress Folder The Cabinet Mail Messages Appointment Messages Task Messages Creating New Messages Using The Menu Bar Creating New Messages Using Keyboard Shortcuts Quick Menus The GroupWise  more...

GroupWise 5 5 Lesson 1: Getting To Know The GroupWise Window Introduction Opening GroupWise The GroupWise Window The Mailbox Folder The Sent Items Folder The Calendar Folder The Task List Folder The Work In Progress Folder The Cabinet Mail Messages Appointment Messages Task Messages Creating New Messages Using The Menu Bar Creating New Messages Using Keyboard Shortcuts Quick Menus The GroupWise  more...

Access 2002 Advanced Lesson 1: Sharing Data Introduction Lesson 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  more...

Access 2002 Intermediate Lesson 1: The Access Interface Introduction 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  more...

Access 2002 Basic Lesson 1: The Access Interface & 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  more...

Dreamweaver MX Web Applications This is the second course in a series of tutorials from the Virtual Training Company for Dreamweaver MX. It covers all that techniques required to construct a data driven web site. Author Mark Fletcher (a member 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  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...

Access 2000 User Set of 5 Access 2000 Beginning (2 Hours 6 Minutes) 1.0 Introduction (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  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types 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  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types 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  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types 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  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 Access 2000 Intermediate (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  more...

Access 2000 Expert Topics Access 2000 Expert Topics (1 Hour 55 Minutes) 1.0 Advanced Query Design Techniques (58 Minutes) 1.1 Calculated Fields 1.2 Summarizing Data 1.3 Excluding Fields 1.4 Parameter Queries 1.5 Make Table, Append, Update, and Delete Queries 1.6 The Find Duplicates Wizard 1.7 The Find Unmatched Wizard 1.8 Inner & Outer Joins 1.9 Self & Union 2.0 Advanced Form Design Techniques (37 Minutes)  more...

Access 2000 Application Developer Set of 16 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types 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  more...

Access 2000 Application Developer LV 1 Access 2000 Application Development Level 1 (2 Hours 5 Minutes) 1.0 Access as a Development Tool (37 Minutes) 1.1 Types 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  more...

Access 2000 Application Developer LV 2 Access 2000 Application Development Level 2 (2 Hours 5 Minutes) 1.0 More About Query Basics (28 Minutes) 1.1 Calculated Fields 1.2 Summarizing Data 1.3 Excluding Fields 1.4 Nulls and Query Results 1.5 Field, Field List, and Query Properties 1.6 Parameter Queries 2.0 Forms (1 Hour 1 Minute) 2.1 Uses of Forms 2.2 Anatomy of a Form 2.3 Creating a Form 2.4 The Form Design Window 2.5  more...

Access 2000 Application Developer LV 5 Access 2000 Application Development Level 5 (2 Hours 7 Minutes) 1.0 Advanced Report Techniques (23 Minutes) 1.1 Report Events 1.2 Sequence of Events 1.3 Section Events 1.4 Sequence of Section Events 1.5 Report Properties 2.0 Report Events & Properties (27 Minutes) 2.1 Changing Reports Record Source 2.2 Displaying Summary and Detail Information 2.3 Printing Mailing Labels 2.4  more...

Access 2000 Application Developer LV 6 Access 2000 Application Development Level 6 (2 Hours 7 Minutes) 1.0 ActiveX Data Objects and Data Access Objects Introduced (20 Minutes) 1.1 Understanding ADO and DAO 1.2 ADO versus DAO 1.3 The ADO Object Model 2.0 ADO Recordset Types (12 Minutes) 2.1 CursorType 2.2 LockType 2.3 Options Parameter 3.0 Working with ADO Recordset Properties and Methods (28 Minutes) 3.1  more...

Access 2000 Application Developer LV 8 Access 2000 Developer Level 8 (2 Hours 16 Minutes) 1.0 Optimizing Your Application (40 Minutes) 1.1 Optimization - An Overview 1.2 Improving Performance with Hardware and Software 1.3 Jet 4.0 and Performance 1.4 The Performance Analyzer 1.5 Designing Tables to Optimize Performance 1.6 Designing Queries to Optimize Performance 1.7 Making Code Changes to Improve Performance 1.8  more...

Excel 2002 Advanced Lesson 1: Sorting & Filtering Data Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View Sorting Data Then By Sorting Using  more...

Quattro Pro 9 Advanced Quattro Pro 9 a Advanced Quattro Pro 9 a Advanced  Lesson1: Introduction, Opening Quattro Pro 9, Inserting Images, Removing The Border From An Inserted Image, Inserting An Arrow Shape, Changing The Properties Of A Shape, Inserting TextArt, Inserting A Rounded Rectangle Shape, Changing The Order Of Objects, Adding A Chart Using The Chart Expert, Naming The X And Y Axis Of A  more...

Paradox 9 Volumes I II Corel 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  more...

Paradox 8 Volumes I II Paradox 8 Paradox 8.0 for Windows 95 Volumes I & II Lesson 1: Introduction, Starting Corel Paradox 8 for Windows The Startup Expert, Major Components of the Paradox 8 Window, The File Menu, The Edit Menu, The Tools Menu, The Window Menu, The Help Menu, The Paradox 8 Toolbar, The Status Bar, An Intro to the Project Viewer, Opening the Project Viewer, The Project Viewer Toolbar, The  more...

SQL Server 7 0 Data Warehousing Set of 4 SQL 7.0 Data Warehousing Level 1 (1 Hr 41 Mins) 1.0 Prerequisites (28 Mins) 1.1 Course Prerequisites 1.2 System Setup 1.3 Defining Data Warehousing 1.4 Operational & Analytical Systems 1.5 Comparing Transactional and Data Warehousing Solutions 1.6 Data Marts 1.7 Know the Flow 1.8 Microsoft Data Warehouse Tools 1.9 Data Warehouse Characteristics 2.0 Designing a Data Warehouse (1 Hr  more...

SQL Server 7 0 Data Warehousing Level 2 SQL 7.0 Data Warehousing Level 2 (1 Hr 48 Mins) 1.0 Building 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  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...

Crystal Reports 8--Level 5 Crystal Reports 8 Level 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  more...

Access 2000 Expert 1. Access 2000 (Expert) Basics Work With Toolbars The Menu Bar & Other Toolbars Install Add-In Programs What Is An Add-In? Install & Load Add-Ins Unload Add-Ins Work With Previous Versions Of Access Access 2000 & Previous Versions Of Access Access 2000 & Access 97 Access 2000 & Access 95 Convert A Database Set Startup Options Set Startup Options Help In Access 2000 The  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 DiscoverWare's a Discover Access XP a is an interactive productivity tool 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  more...

PC Windows Basics DiscoverWare's a Discover PC & Windows Basics a is an interactive productivity tool for users of PCs and Microsoft Windows XP. Windows XP delivers a new standard in reliability, security, performance, and ease of use. Topics include what is a computer, hardware, Windows XP basics, file management, applications, the Internet, help resources, and computer ergonomics. What is a Computer?  more...