Queries Training on CD-ROM

Access XP Essentials Set of 3 ... Printing Relationships Advanced 1.0 Designing 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  more...

JAVA JDBC Servlets Set of 4 ...13 Dropping Tables 2.14 Inserting Data into Tables 2.15 Queries 2.16 SQL Operators 2.17 Ordering Data 2.18 Limiting Results 2.19 Query Summary 2.20 Updating Data 2.21 Selecting Data from Multiple Tables 2.22 Deleting Data Level 2 1.0 Jdbc Fundamentals 1.1 What is jdbc? 1.2 Multi-tier Models 1.3 Jdbc Drivers and Urls 1.4 Classes and Interfaces 1.5 Java to SQL Data Type Mapping  more...

JAVA JDBC Servlets Set of 4 ...13 Dropping Tables 2.14 Inserting Data into Tables 2.15 Queries 2.16 SQL Operators 2.17 Ordering Data 2.18 Limiting Results 2.19 Query Summary 2.20 Updating Data 2.21 Selecting Data from Multiple Tables 2.22 Deleting Data Level 2 1.0 Jdbc Fundamentals 1.1 What is jdbc? 1.2 Multi-tier Models 1.3 Jdbc Drivers and Urls 1.4 Classes and Interfaces 1.5 Java to SQL Data Type Mapping  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 ...yzer 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 Temporary Tables 3.3 UPDATE Statements 3.4 DELETE Statement 4.0  more...

SQL Server 2000 Design Implement Databases Set of 6 ...yzer 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 Temporary Tables 3.3 UPDATE Statements 3.4 DELETE Statement 4.0  more...

Dreamweaver MX Web Applications ...ll 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 Behaviors with ASP, ASP.NET  more...

Access 2002 Advanced ...g A Hyperlink Removing A Hyperlink Lesson 2: 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  more...

Access 2002 Intermediate ...ng Image Properties Printing A Form Lesson 4: Charts, Queries & Data Access Pages Introduction Lesson Objectives The Chart Wizard Selecting A Source Specifying Fields Selecting A Chart Type Laying Out Chart Data 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  more...

Access 2002 Basic ... Relationships Relational Databases Relationship Lines Queries Forms Navigating In Forms Viewing Reports Zooming In Zooming Out Displaying Multiple Pages Form Design View Data Access Pages Macros Modules Closing The Database Window Exiting Access Lesson 2: Working With Tables Introduction Lesson Objectives Opening Access Creating A New Database Using The Table Wizard  more...

Dreamweaver MX Web Applications ...ll 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 Behaviors with ASP, ASP.NET  more...

Access 2000 Beginning ...(5 Minutes) 5.1 Printing Table Datasheets 5.2 Printing Queries 5.3 Printing Forms 5.4 Printing Reports 6.0 Getting Help (8 Minutes) 6.1 The Office Assistant & Index Searching 6.2 Context-Sensitive Help & Printing Help Topics 7.0 Database Maintenance & Shortcuts (12 Minutes) 7.1 Backing Up and Restoring a Database 7.2 Compacting and Repairing a Database 7.3 Converting a Database  more...

Access 2000 User Set of 5 ...(5 Minutes) 5.1 Printing Table Datasheets 5.2 Printing Queries 5.3 Printing Forms 5.4 Printing Reports 6.0 Getting Help (8 Minutes) 6.1 The Office Assistant & Index Searching 6.2 Context-Sensitive Help & Printing Help Topics 7.0 Database Maintenance & Shortcuts (12 Minutes) 7.1 Backing Up and Restoring a Database 7.2 Compacting and Repairing a Database 7.3 Converting a Database  more...

Access 2000 Application Developer Set of 16 ...ics 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 Data 1.3 Excluding Fields 1.4 Nulls and Query Results 1.5  more...

Access 2000 Application Developer Set of 16 ...ics 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 Data 1.3 Excluding Fields 1.4 Nulls and Query Results 1.5  more...

Access 2000 Application Developer Set of 16 ...ics 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 Data 1.3 Excluding Fields 1.4 Nulls and Query Results 1.5  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 ...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) 2.1 Working with Built-in Tab Control 2.2 Working with Headers, Footers and Combo Boxes 2.3 Creating Multi-Table Forms  more...

Access 2000 Application Developer Set of 16 ...uery 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 Data 1.3 Excluding Fields 1.4 Nulls and Query Results 1.5 Field, Field List, and Query  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 ....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 2.6 Form Properties 2.7 Control Properties 2.8 Bound, Unbound, and Calculated Controls 2.9 Command Button Wizards 2.10 Forms Based on More than One Table 3.0 Reports (35  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 ...n 3.6 The Bookmark Property 3.7 Executing Parameterized Queries 4.0 Modifying Table Data (19 Minutes) 4.1 Updating Records using ADO 4.2 Deleting 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  more...

Access 2000 Application Developer LV 8 ...5 Designing Tables to Optimize Performance 1.6 Designing Queries to Optimize Performance 1.7 Making Code Changes to Improve Performance 1.8 Designing Forms and Reports to Improve Performance 2.0 A Strategy for Application Development (30 Minutes) 2.1 Splitting Tables and Other Objects 2.2 Basing Forms and Reports on Queries 2.3 The Access Runtime Engine 2.4 Preparing an Application  more...

Access 2000 Application Developer LV 9 Access 2000 Developer Level 9 (1 Hour 59 Minutes) 1.0 Client/Server Techniques (1 Hour 18 Minutes) 1.1 Client/Server - An Introduction 1.2 The Client/Server Model 1.3 Client/Server Buzz Words 1.4 Preparing for Upsizing 1.5 The Upsizing Wizard 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  more...

Access 2000 Application Developer LV 15 Application Development Level 15 (1 Hour 51 Minutes) 1.0 Security (1 Hour 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  more...

Quattro Pro 9 Intermediate ...ers, Custom Filters, Creating A Criteria Table, Using AND Queries, Using OR Queries, Using AND/OR Queries, Extract Unique Records, Using Database Functions, Import Data, Creating A Cross-Tab Report, Editing The Cross Tab Reports Lesson 3: Introduction, Working With Multi-Sheet Notebooks, Changing Column Width Using Sheet Properties, Naming Notebook Sheets, Copying From Sheet To Sheet,  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 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...

Windows 2000 Network Infrastructure Level 3 Level 3 (1 hr 54 mins) 1.0 DNS (26 mins) 1.1 Definition 1.2 Flat Structure & Hierarchy 1.3 DNS Structure 1.4 Typical Computer Syntax 2.0 Installing DNS (43 mins) 2.1 DNS Requirements 2.2 Installation Process 2.3 DNS Adds 2.4 DNS Client Configuration 2.5 DHCP 2.6 Editing the Root Zone File 2.7 Types of Zone Files 2.8 Ping 3.0 Zone Files (45 mins) 3.1 Reverse Lookup 3.2 Active  more...

Windows 2000 Network Infrastructure Level 3 Level 3 (1 hr 54 mins) 1.0 DNS (26 mins) 1.1 Definition 1.2 Flat Structure & Hierarchy 1.3 DNS Structure 1.4 Typical Computer Syntax 2.0 Installing DNS (43 mins) 2.1 DNS Requirements 2.2 Installation Process 2.3 DNS Adds 2.4 DNS Client Configuration 2.5 DHCP 2.6 Editing the Root Zone File 2.7 Types of Zone Files 2.8 Ping 3.0 Zone Files (45 mins) 3.1 Reverse Lookup 3.2 Active  more...

Access 2000 - Proficient ...ng tables and forms,finding and sorting data,working with queries,creating reports,and working on the web. DiscoverWare products combine audio,animation, and software simulation with a unique user interface to make the "discovery" of computer programs both effective and entertaining.The program is also designed to help users learn about software at their own pace,providing the control to let  more...

Access 2000 Expert ...Filters What Is A Filter? Apply & 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  more...

Access XP Proficient Expert ...elationships Review The Design - Refine The Design - Queries, Forms & Reports Screen Layout - The Access XP Window - The Database Window Help In Access XP - Ask A Question - Microsoft Access Help Build a Database Use Database Wizards - Database Wizards - Use A Database Wizard Create A Blank Database - Create A Blank Database Work With Table Data - Enter Data - Edit  more...