Query Training on CD-ROM - Training Resources
Query Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based Training
Access 2000 User Series
... Queries (27 Minutes) 4.1 Selecting Fields & Ordering the Query Result 4.2 Refining Queries with Criteria 4.3 Updatability of Query Results 4.4 Queries Based on Multiple Tables Access 2000 Advanced (2 Hours 3 Minutes) 1.0 Building and Modifying Forms (51 Minutes) 1.1 Adding Controls 1.2 Selecting Controls 1.3 Moving, Sizing and Deleting Controls 1.4 Aligning Controls 1.5 Changing Control
more...
Access 2000 User Series
... Queries (27 Minutes) 4.1 Selecting Fields & Ordering the Query Result 4.2 Refining Queries with Criteria 4.3 Updatability of Query Results 4.4 Queries Based on Multiple Tables Access 2000 Advanced (2 Hours 3 Minutes) 1.0 Building and Modifying Forms (51 Minutes) 1.1 Adding Controls 1.2 Selecting Controls 1.3 Moving, Sizing and Deleting Controls 1.4 Aligning Controls 1.5 Changing Control
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 (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
...es And Data Access Pages, Introduction, Creating A Select Query, Adding Fields To A Select Query, Running A Query From The Design Window, Sorting With A Query, Showing And Hiding Fields, Using Criteria In A Query, Querying Multiple Tables, Specifying Another Table In A Query, Using Comparison Operators, Multiple Criteria Conditions, Closing, Saving, Naming and Printing The Query, Building
more...
...es And Data Access Pages, Introduction, Creating A Select Query, Adding Fields To A Select Query, Running A Query From The Design Window, Sorting With A Query, Showing And Hiding Fields, Using Criteria In A Query, Querying Multiple Tables, Specifying Another Table In A Query, Using Comparison Operators, Multiple Criteria Conditions, Closing, Saving, Naming and Printing The Query, Building
more...
Access 2000 Advanced
... Queries, Introduction - Advanced Queries, Creating A New Query, Defining A Sort Order, Running A Query, Calculating Fields, Modifying A Query, Creating A Multi-table Query, The Show Tables Button, Joining Fields, Joining Properties, Creating A Crosstab Query, Running A Crosstab Query, Specifying Criteria, Creating A Delete Query, Previewing Delete Query Results, Creating An Update Query Lesson
more...
... Queries, Introduction - Advanced Queries, Creating A New Query, Defining A Sort Order, Running A Query, Calculating Fields, Modifying A Query, Creating A Multi-table Query, The Show Tables Button, Joining Fields, Joining Properties, Creating A Crosstab Query, Running A Crosstab Query, Specifying Criteria, Creating A Delete Query, Previewing Delete Query Results, Creating An Update Query Lesson
more...
Excel 2000 Advanced
...rt Available On The Web, Creating A Data MapRunning A Web Query, Extracting Data, Querying A Spreadsheet Lesson 4: Workgroup Functions, Opening An Existing File, Sharing Your Workbook, Mail A Workbook As An Attachment, Mail A Worksheet As The Body Of The Message, Routing Workbooks, Tracking Changes, Highlight Changes As You Work, Creating A Personal History Worksheet, Multiple User History
more...
...rt Available On The Web, Creating A Data MapRunning A Web Query, Extracting Data, Querying A Spreadsheet Lesson 4: Workgroup Functions, Opening An Existing File, Sharing Your Workbook, Mail A Workbook As An Attachment, Mail A Worksheet As The Body Of The Message, Routing Workbooks, Tracking Changes, Highlight Changes As You Work, Creating A Personal History Worksheet, Multiple User History
more...
Access 2002 Advanced
...ced Queries Introduction Lesson Objectives Creating A New Query Selecting Source Data Adding Fields To A Query Defining Sort Order Running A Query Adding Calculated Fields Modifying A Query Creating A Multi-Table Query Selecting Queries The Show Tables Button Selecting Fields Joining Fields Join Properties Modifying Sort Order Resizing Fields Creating A Crosstab Query Specifying Column & Row
more...
...ced Queries Introduction Lesson Objectives Creating A New Query Selecting Source Data Adding Fields To A Query Defining Sort Order Running A Query Adding Calculated Fields Modifying A Query Creating A Multi-Table Query Selecting Queries The Show Tables Button Selecting Fields Joining Fields Join Properties Modifying Sort Order Resizing Fields Creating A Crosstab Query Specifying Column & Row
more...
Access 2002 Intermediate
...ata Finishing A Chart Modifying A Chart Creating A Select Query Adding Fields To A Select Query Running A Query Sorting With A Query Showing & Hiding Fields Using Criteria In A Query Querying Multiple Tables Using Comparison Operators Setting Multiple Criteria Saving & Naming A Query Printing A Query Building Summary Queries Data Access Pages The Page Wizard Adding Grouping Levels Sorting
more...
...ata Finishing A Chart Modifying A Chart Creating A Select Query Adding Fields To A Select Query Running A Query Sorting With A Query Showing & Hiding Fields Using Criteria In A Query Querying Multiple Tables Using Comparison Operators Setting Multiple Criteria Saving & Naming A Query Printing A Query Building Summary Queries Data Access Pages The Page Wizard Adding Grouping Levels Sorting
more...
Access 2002 Basic
...ilter For Feature Filtering Tips Using Queries The Simple Query Wizard Selecting Fields For A Query Completing The Query Viewing Multiple Objects Tiling Windows Query Design View Hiding Fields In A Query Specifying A Criteria Calculated Fields Removing Criteria Running The Query Modifying The Criteria Adding A Field To A Query Using A Numeric Expression Specifying Sort Order Adding Additional
more...
...ilter For Feature Filtering Tips Using Queries The Simple Query Wizard Selecting Fields For A Query Completing The Query Viewing Multiple Objects Tiling Windows Query Design View Hiding Fields In A Query Specifying A Criteria Calculated Fields Removing Criteria Running The Query Modifying The Criteria Adding A Field To A Query Using A Numeric Expression Specifying Sort Order Adding Additional
more...
Excel 2002 Advanced
... 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 Custom AutoFilter The Data Form Dialog Box Changing A Record
more...
... 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 Custom AutoFilter The Data Form Dialog Box Changing A Record
more...
NET Set of 7
....1 Binding Data to a DataGrid 4.2 Creating Parameterized Query 4.3 Binding Data Manually Level 5 1.0 ADO.NET Connection & Command Objects 1.1 Using the ADO.NET Connection Object 1.2 Using the ADO.NET Command Object 2.0 The ADO.NET DataReader Object 2.1 Loading a List Box 2.2 A Generic ListItem Class 2.3 Displaying Product Info 2.4 Finding Values in Combo Boxes 3.0 ADO.NET
more...
....1 Binding Data to a DataGrid 4.2 Creating Parameterized Query 4.3 Binding Data Manually Level 5 1.0 ADO.NET Connection & Command Objects 1.1 Using the ADO.NET Connection Object 1.2 Using the ADO.NET Command Object 2.0 The ADO.NET DataReader Object 2.1 Loading a List Box 2.2 A Generic ListItem Class 2.3 Displaying Product Info 2.4 Finding Values in Combo Boxes 3.0 ADO.NET
more...
NET Set of 7
....1 Binding Data to a DataGrid 4.2 Creating Parameterized Query 4.3 Binding Data Manually Level 5 1.0 ADO.NET Connection & Command Objects 1.1 Using the ADO.NET Connection Object 1.2 Using the ADO.NET Command Object 2.0 The ADO.NET DataReader Object 2.1 Loading a List Box 2.2 A Generic ListItem Class 2.3 Displaying Product Info 2.4 Finding Values in Combo Boxes 3.0 ADO.NET
more...
....1 Binding Data to a DataGrid 4.2 Creating Parameterized Query 4.3 Binding Data Manually Level 5 1.0 ADO.NET Connection & Command Objects 1.1 Using the ADO.NET Connection Object 1.2 Using the ADO.NET Command Object 2.0 The ADO.NET DataReader Object 2.1 Loading a List Box 2.2 A Generic ListItem Class 2.3 Displaying Product Info 2.4 Finding Values in Combo Boxes 3.0 ADO.NET
more...
Access XP Essentials Set of 3
...g Simple Queries 1.1 Selecting Fields 1.2 Ordering the Query Result & Refining Queries with Criteria 1.3 Updatability of Query Results 1.4 Queries Based on Multiple Tables 2.0 Building & Modifying Forms 2.1 Adding Controls 2.2 Selecting Controls 2.3 Moving, Sizing, & Deleting Controls 2.4 Aligning Controls 2.5 Changing Control Properties 2.6 Changing the Tab Order Controls 2.7
more...
...g Simple Queries 1.1 Selecting Fields 1.2 Ordering the Query Result & Refining Queries with Criteria 1.3 Updatability of Query Results 1.4 Queries Based on Multiple Tables 2.0 Building & Modifying Forms 2.1 Adding Controls 2.2 Selecting Controls 2.3 Moving, Sizing, & Deleting Controls 2.4 Aligning Controls 2.5 Changing Control Properties 2.6 Changing the Tab Order Controls 2.7
more...
JAVA JDBC Servlets Set of 4
...al 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 2.5 Creating and Droping Databases 2.6 Accessing a Database 2.7 Creating Tables 2.8 Common SQL Data Types
more...
...al 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 2.5 Creating and Droping Databases 2.6 Accessing a Database 2.7 Creating Tables 2.8 Common SQL Data Types
more...
JAVA JDBC Servlets Set of 4
...al 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 2.5 Creating and Droping Databases 2.6 Accessing a Database 2.7 Creating Tables 2.8 Common SQL Data Types
more...
...al 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 2.5 Creating and Droping Databases 2.6 Accessing a Database 2.7 Creating Tables 2.8 Common SQL Data Types
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...
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
... & Calculated Columns 3.4 ORDER BY Clause 3.5 Using SLQ Query Analyzer Designing and Implementing Level 3 1.0 Advanced Queries 1.1 Aggregated Functions 1.2 Grouping Data 1.3 Advanced Queries 1.4 Distributed Queries 2.0 Joining Tables 2.1 Inner Joins 2.2 Outer Joins 2.3 Cross Join & Self Join 2.4 Subqueries 2.5 Unions 3.0 Data Modification 3.1 INSERT Statements 3.2 Creating
more...
... & Calculated Columns 3.4 ORDER BY Clause 3.5 Using SLQ Query Analyzer Designing and Implementing Level 3 1.0 Advanced Queries 1.1 Aggregated Functions 1.2 Grouping Data 1.3 Advanced Queries 1.4 Distributed Queries 2.0 Joining Tables 2.1 Inner Joins 2.2 Outer Joins 2.3 Cross Join & Self Join 2.4 Subqueries 2.5 Unions 3.0 Data Modification 3.1 INSERT Statements 3.2 Creating
more...
SQL Server 2000 Design Implement Databases Set of 6
... & Calculated Columns 3.4 ORDER BY Clause 3.5 Using SLQ Query Analyzer Designing and Implementing Level 3 1.0 Advanced Queries 1.1 Aggregated Functions 1.2 Grouping Data 1.3 Advanced Queries 1.4 Distributed Queries 2.0 Joining Tables 2.1 Inner Joins 2.2 Outer Joins 2.3 Cross Join & Self Join 2.4 Subqueries 2.5 Unions 3.0 Data Modification 3.1 INSERT Statements 3.2 Creating
more...
... & Calculated Columns 3.4 ORDER BY Clause 3.5 Using SLQ Query Analyzer Designing and Implementing Level 3 1.0 Advanced Queries 1.1 Aggregated Functions 1.2 Grouping Data 1.3 Advanced Queries 1.4 Distributed Queries 2.0 Joining Tables 2.1 Inner Joins 2.2 Outer Joins 2.3 Cross Join & Self Join 2.4 Subqueries 2.5 Unions 3.0 Data Modification 3.1 INSERT Statements 3.2 Creating
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...
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...
...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
... 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 Behaviors with ASP, ASP.NET and ColdFusion MX. Course
more...
... 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 Behaviors with ASP, ASP.NET and ColdFusion MX. Course
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...
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
...ocuments Check Out Options Checking In Documents Using Query Folders With Document Management Echoing Documents To Your Remote Mailbox Closing GroupWise Lesson 5: Configuring GroupWise For Remote Use Opening GroupWise Setting Up A Remote User Entering User Information Entering System Information Modem Connection Settings Configuring A Connection Date, Time, And Time Zone
more...
...ocuments Check Out Options Checking In Documents Using Query Folders With Document Management Echoing Documents To Your Remote Mailbox Closing GroupWise Lesson 5: Configuring GroupWise For Remote Use Opening GroupWise Setting Up A Remote User Entering User Information Entering System Information Modem Connection Settings Configuring A Connection Date, Time, And Time Zone
more...
GroupWise 5 5
...ocuments Check Out Options Checking In Documents Using Query Folders With Document Management Echoing Documents To Your Remote Mailbox Closing GroupWise Lesson 5: Configuring GroupWise For Remote Use Opening GroupWise Setting Up A Remote User Entering User Information Entering System Information Modem Connection Settings Configuring A Connection Date, Time, And Time Zone
more...
...ocuments Check Out Options Checking In Documents Using Query Folders With Document Management Echoing Documents To Your Remote Mailbox Closing GroupWise Lesson 5: Configuring GroupWise For Remote Use Opening GroupWise Setting Up A Remote User Entering User Information Entering System Information Modem Connection Settings Configuring A Connection Date, Time, And Time Zone
more...
Access 2002 Advanced
... Queries Introduction Lesson Objectives Creating A New Query Selecting Source Data Adding Fields To A Query Defining Sort Order Running A Query Adding Calculated Fields Modifying A Query Creating A Multi-Table Query Selecting Queries The Show Tables Button Selecting Fields Joining Fields Join Properties Modifying Sort Order Resizing Fields Creating A Crosstab Query Specifying
more...
... Queries Introduction Lesson Objectives Creating A New Query Selecting Source Data Adding Fields To A Query Defining Sort Order Running A Query Adding Calculated Fields Modifying A Query Creating A Multi-Table Query Selecting Queries The Show Tables Button Selecting Fields Joining Fields Join Properties Modifying Sort Order Resizing Fields Creating A Crosstab Query Specifying
more...
Access 2002 Intermediate
... Finishing A Chart Modifying A Chart Creating A Select Query Adding Fields To A Select Query Running A Query Sorting With A Query Showing & Hiding Fields Using Criteria In A Query Querying Multiple Tables Using Comparison Operators Setting Multiple Criteria Saving & Naming A Query Printing A Query Building Summary Queries Data Access Pages The Page Wizard Adding Grouping Levels
more...
... Finishing A Chart Modifying A Chart Creating A Select Query Adding Fields To A Select Query Running A Query Sorting With A Query Showing & Hiding Fields Using Criteria In A Query Querying Multiple Tables Using Comparison Operators Setting Multiple Criteria Saving & Naming A Query Printing A Query Building Summary Queries Data Access Pages The Page Wizard Adding Grouping Levels
more...
Access 2002 Basic
...er For Feature Filtering Tips Using Queries The Simple Query Wizard Selecting Fields For A Query Completing The Query Viewing Multiple Objects Tiling Windows Query Design View Hiding Fields In A Query Specifying A Criteria Calculated Fields Removing Criteria Running The Query Modifying The Criteria Adding A Field To A Query Using A Numeric Expression Specifying Sort Order
more...
...er For Feature Filtering Tips Using Queries The Simple Query Wizard Selecting Fields For A Query Completing The Query Viewing Multiple Objects Tiling Windows Query Design View Hiding Fields In A Query Specifying A Criteria Calculated Fields Removing Criteria Running The Query Modifying The Criteria Adding A Field To A Query Using A Numeric Expression Specifying Sort Order
more...
Dreamweaver MX Web Applications
... 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 Behaviors with ASP, ASP.NET and ColdFusion MX. Course
more...
... 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 Behaviors with ASP, ASP.NET and ColdFusion MX. Course
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...
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
...ueries (27 Minutes)
4.1 Selecting Fields & Ordering the Query Result
4.2 Refining Queries with Criteria
4.3 Updatability of Query Results
4.4 Queries Based on Multiple Tables
Access 2000 Advanced (2 Hours 3 Minutes)
1.0 Building and Modifying Forms (51 Minutes)
1.1 Adding Controls
1.2 Selecting Controls
1.3 Moving, Sizing and Deleting Controls
1.4 Aligning Controls
1.5
more...
...ueries (27 Minutes)
4.1 Selecting Fields & Ordering the Query Result
4.2 Refining Queries with Criteria
4.3 Updatability of Query Results
4.4 Queries Based on Multiple Tables
Access 2000 Advanced (2 Hours 3 Minutes)
1.0 Building and Modifying Forms (51 Minutes)
1.1 Adding Controls
1.2 Selecting Controls
1.3 Moving, Sizing and Deleting Controls
1.4 Aligning Controls
1.5
more...
Access 2000 Application Developer Set of 16
...of Relationships
3.5 Indexes and Relationships
4.0 Query Basics (26 Minutes)
4.1 Query Basics
4.2 The Query and Query Result
4.3 Refining Queries with Criteria
4.4 Updatability of Query Results
4.5 Queries Based on Multiple Tables
Access 2000 Application Development Level 2 (2 Hours 5 Minutes)
1.0 More About Query Basics (28 Minutes)
1.1 Calculated
more...
...of Relationships
3.5 Indexes and Relationships
4.0 Query Basics (26 Minutes)
4.1 Query Basics
4.2 The Query and Query Result
4.3 Refining Queries with Criteria
4.4 Updatability of Query Results
4.5 Queries Based on Multiple Tables
Access 2000 Application Development Level 2 (2 Hours 5 Minutes)
1.0 More About Query Basics (28 Minutes)
1.1 Calculated
more...
Access 2000 Application Developer Set of 16
...of Relationships
3.5 Indexes and Relationships
4.0 Query Basics (26 Minutes)
4.1 Query Basics
4.2 The Query and Query Result
4.3 Refining Queries with Criteria
4.4 Updatability of Query Results
4.5 Queries Based on Multiple Tables
Access 2000 Application Development Level 2 (2 Hours 5 Minutes)
1.0 More About Query Basics (28 Minutes)
1.1 Calculated
more...
...of Relationships
3.5 Indexes and Relationships
4.0 Query Basics (26 Minutes)
4.1 Query Basics
4.2 The Query and Query Result
4.3 Refining Queries with Criteria
4.4 Updatability of Query Results
4.5 Queries Based on Multiple Tables
Access 2000 Application Development Level 2 (2 Hours 5 Minutes)
1.0 More About Query Basics (28 Minutes)
1.1 Calculated
more...
Access 2000 Application Developer Set of 16
...of Relationships
3.5 Indexes and Relationships
4.0 Query Basics (26 Minutes)
4.1 Query Basics
4.2 The Query and Query Result
4.3 Refining Queries with Criteria
4.4 Updatability of Query Results
4.5 Queries Based on Multiple Tables
Access 2000 Application Development Level 2 (2 Hours 5 Minutes)
1.0 More About Query Basics (28 Minutes)
1.1 Calculated
more...
...of Relationships
3.5 Indexes and Relationships
4.0 Query Basics (26 Minutes)
4.1 Query Basics
4.2 The Query and Query Result
4.3 Refining Queries with Criteria
4.4 Updatability of Query Results
4.5 Queries Based on Multiple Tables
Access 2000 Application Development Level 2 (2 Hours 5 Minutes)
1.0 More About Query Basics (28 Minutes)
1.1 Calculated
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...
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 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
...ss 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...
...ss 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
...its of Relationships
3.5 Indexes and Relationships
4.0 Query Basics (26 Minutes)
4.1 Query Basics
4.2 The Query and Query Result
4.3 Refining Queries with Criteria
4.4 Updatability of Query Results
4.5 Queries Based on Multiple Tables
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
more...
...its of Relationships
3.5 Indexes and Relationships
4.0 Query Basics (26 Minutes)
4.1 Query Basics
4.2 The Query and Query Result
4.3 Refining Queries with Criteria
4.4 Updatability of Query Results
4.5 Queries Based on Multiple Tables
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
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 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
...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 Working with Controls
more...
...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 Working with Controls
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 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 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...
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
...pening 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 Custom AutoFilter The Data Form Dialog Box
more...
...pening 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 Custom AutoFilter The Data Form Dialog Box
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...
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
...ts Using Project Viewer Printing A Report Lesson 2: Querying Your Data Introduction Creating A Query Using QBE Selecting Fields To Display In A Result Table Using Logical Operators In A Query Creating A Delete Query Viewing The Tables In The Private Directory Undoing Deletes Assigning Example Elements To A Field Using The CALC Operator Creating A Query Using The
more...
...ts Using Project Viewer Printing A Report Lesson 2: Querying Your Data Introduction Creating A Query Using QBE Selecting Fields To Display In A Result Table Using Logical Operators In A Query Creating A Delete Query Viewing The Tables In The Private Directory Undoing Deletes Assigning Example Elements To A Field Using The CALC Operator Creating A Query Using The
more...
Paradox 8 Volumes I II
...le Form, Lesson 6 Review
Lesson 7: Introduction, A Query Overview, Where to Begin, Selecting a Table, Working With the Query Window, The Query Toolbar, Selecting Fields for Answer Table Display, Entering Field Criteria, Running Your Query, Closing Your Query, Saving Your Query, Opening an Existing Query, Creating a Live Query, Check Operators, The Live Query View Property Option, Live
more...
...le Form, Lesson 6 Review
Lesson 7: Introduction, A Query Overview, Where to Begin, Selecting a Table, Working With the Query Window, The Query Toolbar, Selecting Fields for Answer Table Display, Entering Field Criteria, Running Your Query, Closing Your Query, Saving Your Query, Opening an Existing Query, Creating a Live Query, Check Operators, The Live Query View Property Option, Live
more...
SQL Server 7 0 Data Warehousing Set of 4
...ating a Data Warehouse 2.4 Transact-SQL 2.5 Distributed Query 2.6 bcp Utility and the BULK INSERT Statement 2.7 Data Transformation Services (DTS) 2.8 Transferring a File Using DTS 2.9 Transforming Data by Using an ActiveX Script 2.10 Transforming Data by Using a Lookup Query 2.11 Defining Transactions 2.12 Tracking Data Lineage 2.13 Creating a DTS Package Programmatically 3.0 The
more...
...ating a Data Warehouse 2.4 Transact-SQL 2.5 Distributed Query 2.6 bcp Utility and the BULK INSERT Statement 2.7 Data Transformation Services (DTS) 2.8 Transferring a File Using DTS 2.9 Transforming Data by Using an ActiveX Script 2.10 Transforming Data by Using a Lookup Query 2.11 Defining Transactions 2.12 Tracking Data Lineage 2.13 Creating a DTS Package Programmatically 3.0 The
more...
SQL Server 7 0 Data Warehousing Level 2
...ating a Data Warehouse 2.4 Transact-SQL 2.5 Distributed Query 2.6 bcp Utility and the BULK INSERT Statement 2.7 Data Transformation Services (DTS) 2.8 Transferring a File Using DTS 2.9 Transforming Data by Using an ActiveX Script 2.10 Transforming Data by Using a Lookup Query 2.11 Defining Transactions 2.12 Tracking Data Lineage 2.13 Creating a DTS Package Programmatically 3.0 The
more...
...ating a Data Warehouse 2.4 Transact-SQL 2.5 Distributed Query 2.6 bcp Utility and the BULK INSERT Statement 2.7 Data Transformation Services (DTS) 2.8 Transferring a File Using DTS 2.9 Transforming Data by Using an ActiveX Script 2.10 Transforming Data by Using a Lookup Query 2.11 Defining Transactions 2.12 Tracking Data Lineage 2.13 Creating a DTS Package Programmatically 3.0 The
more...
SQL Server 7 0 Data Warehousing Level 4
... Local Cubes through MDX & ADO MD 2.0 Microsoft English Query (35 Mins) 2.1 Introduction to Microsoft English Query 2.2 Domains, Entities, & Relationships 2.3 Database Normalization 2.4 Identify Schema & Defining Entities 2.5 Setting Up Schema & Entities 2.6 Build Test Application for Queries 2.7 Multi-dimensional Databases & Deployment 3.0 Maintaining & Managing (29 Mins) 3.1
more...
... Local Cubes through MDX & ADO MD 2.0 Microsoft English Query (35 Mins) 2.1 Introduction to Microsoft English Query 2.2 Domains, Entities, & Relationships 2.3 Database Normalization 2.4 Identify Schema & Defining Entities 2.5 Setting Up Schema & Entities 2.6 Build Test Application for Queries 2.7 Multi-dimensional Databases & Deployment 3.0 Maintaining & Managing (29 Mins) 3.1
more...
Crystal Reports 8--Level 5
...g on Exchange or Outlook Data 2.0 Using SQL (Structured Query Language) (16 Mins) 2.1 What is SQL? & Creating a Report Based on an ODBC Datasource 2.2 Building a SQL Query 2.3 Modifying SQL Options 3.0 The Crystal Query Designer (18 Mins) 3.1 Why Use a Query 3.2 Creating a Query 3.3 Modifying the Query 3.4 Creating a Report from a Query 3.5 Basing a Query on a Query 4.0 Creating
more...
...g on Exchange or Outlook Data 2.0 Using SQL (Structured Query Language) (16 Mins) 2.1 What is SQL? & Creating a Report Based on an ODBC Datasource 2.2 Building a SQL Query 2.3 Modifying SQL Options 3.0 The Crystal Query Designer (18 Mins) 3.1 Why Use a Query 3.2 Creating a Query 3.3 Modifying the Query 3.4 Creating a Report from a Query 3.5 Basing a Query on a Query 4.0 Creating
more...
Access 2000 Expert
...ly & Remove Filters Use Queries To Retrieve Data Use A Query Create A Select Query Apply Filters In A Record Set Create A Totals Query Create A Parameter Query Specify Criteria In Multiple Fields Modify A Query Create An Action Query Optimize A Query Specify Joint Properties For Relationships Data Integration Export To Excel Drag and Drop To Excel Use A Chart Link To Existing
more...
...ly & Remove Filters Use Queries To Retrieve Data Use A Query Create A Select Query Apply Filters In A Record Set Create A Totals Query Create A Parameter Query Specify Criteria In Multiple Fields Modify A Query Create An Action Query Optimize A Query Specify Joint Properties For Relationships Data Integration Export To Excel Drag and Drop To Excel Use A Chart Link To Existing
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...
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
...move Filters Use Queries To Retrieve Data - What Is A Query? - Create A Select Query - Add a Calculated Field To A Query Work With Reports Create Reports Automatically - What Is A Report? - Use AutoReport - Use The Report Wizard Create A Report Manually - Report Controls - Work With Controls - Types Of Controls - Create A Report Manually - Add A Calculated Control
more...
...move Filters Use Queries To Retrieve Data - What Is A Query? - Create A Select Query - Add a Calculated Field To A Query Work With Reports Create Reports Automatically - What Is A Report? - Use AutoReport - Use The Report Wizard Create A Report Manually - Report Controls - Work With Controls - Types Of Controls - Create A Report Manually - Add A Calculated Control
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...
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...
From Makau Corporation
Relational Database
This tutorial training series will teach you the concept of Relational Databases and how to plan, build, write to, query and manage them.
more...
This tutorial training series will teach you the concept of Relational Databases and how to plan, build, write to, query and manage them.
more...
SQL 2005 - Querying Microsoft SQL Server 2005 Database with Transact-SQL
Learn about the Transact-SQL programming language, what it is and how to query Microsoft SQL Server 2005. Then move on to how to use Transact-SQL query tools to retrieve data, format results, grouping and summarizing data. And then learn how to join multiple tables, work with subqueries, modify data in existing tables, and use programming objects.
3 levels - 49 training modules
more...
Learn about the Transact-SQL programming language, what it is and how to query Microsoft SQL Server 2005. Then move on to how to use Transact-SQL query tools to retrieve data, format results, grouping and summarizing data. And then learn how to join multiple tables, work with subqueries, modify data in existing tables, and use programming objects.
3 levels - 49 training modules
more...
online course |
instructor-led class |
learn at home |
group study |
self-directed study |
cd-based training |
DVD video training |
printed book |
e-book digital book |
workshop seminar |
train the trainer |
computer-based learning |
discount pricing |
online tutorial |
