Creating An If Statement Training on CD-ROM - Training Resources

Excel 2000 Intermediate ...Copying Cell Formulas, Removing Absolute Cell References, Creating An IF Statement, Copying An IF Statement, More On AutoSum, Using Goal Seek, Naming A Group Of Cells, Using VLOOKUP, Copying A Formula Into A Block Of Cells, Applying The TREND Function, Review Lesson 5: More Customizing Options, Introduction, Opening Multiple Documents Simultaneously, Viewing Two Documents At Once, Linking Cells  more...

Excel 2002 Intermediate ...bout AutoSum Tracing An Error Entering A Formula Manually Creating An IF Statement Using Goal Seek Using VLOOKUP Applying The Trend Function Calculating A Percentage Quick Calculations Saving Your Work Lesson 5: Protection & Customization Introduction Lesson Objectives Opening A Workbook About Protection Locking And Unlocking Cells Hiding Formulas Protecting A Worksheet Verifying Protection  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...

JAVA Programming Set of 4 Level 1 1.0 Overview of Java 1.1 What is Java? 1.2 What is OOP? 1.3 What is Source Code? 1.4 Dynamic Loading 1.5 Java vs. C 1.6 Java Platform & Development Environments 1.7 Applications & Applets 1.8 What is a JavaBean? 1.9 Web Programming with Java 1.10 What is Unicode? 1.11 Multi-tier Applications 1.12 Java Documentation 2.0 Getting Started in Java 2.1 Java Development  more...

JAVA Programming Set of 4 Level 1 1.0 Overview of Java 1.1 What is Java? 1.2 What is OOP? 1.3 What is Source Code? 1.4 Dynamic Loading 1.5 Java vs. C 1.6 Java Platform & Development Environments 1.7 Applications & Applets 1.8 What is a JavaBean? 1.9 Web Programming with Java 1.10 What is Unicode? 1.11 Multi-tier Applications 1.12 Java Documentation 2.0 Getting Started in Java 2.1 Java Development  more...

Oracle8iR2 Database Administration Set of 5 Level 1 (2 hrs 22 min) 1.0 Oracle8i Architecture (1 hr 20 min) 1.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  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...

HTML DHTML Introduction Lesson 1: Basic Concepts Introduction Internet Concepts History Of The Internet Network Types Local Area Networks Metropolitan Area Networks Wide Area Networks The Internet Networking Essentials Clients and Servers Protocols IP Addresses Uniform Resource Locators The World Wide Web How The WWW Works Markup Languages Standard Generalized Markup Language Hyper Text Markup Language Dynamic  more...

HTML DHTML Introduction Lesson 1: Basic Concepts Introduction Internet Concepts History Of The Internet Network Types Local Area Networks Metropolitan Area Networks Wide Area Networks The Internet Networking Essentials Clients and Servers Protocols IP Addresses Uniform Resource Locators The World Wide Web How The WWW Works Markup Languages Standard Generalized Markup Language Hyper Text Markup Language Dynamic  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...

Excel 2002 Intermediate ...t AutoSum Tracing An Error Entering A Formula Manually Creating An IF Statement Using Goal Seek Using VLOOKUP Applying The Trend Function Calculating A Percentage Quick Calculations Saving Your Work Lesson 5: Protection & Customization Introduction Lesson Objectives Opening A Workbook About Protection Locking And Unlocking Cells Hiding Formulas Protecting A Worksheet  more...

Excel 2000 Intermediate ...Copying Cell Formulas, Removing Absolute Cell References, Creating An IF Statement, Copying An IF Statement, More On AutoSum, Using Goal Seek, Naming A Group Of Cells, Using VLOOKUP, Copying A Formula Into A Block Of Cells, Applying The TREND Function, Review Lesson 5 : More Customizing Options, Introduction, Opening Multiple Documents Simultaneously, Viewing Two Documents At Once,  more...

Visual Basic 6 0 Getting Started Set of 8 LV 1-8 Level 1 (1 Hour 51 Minutes) 1.0 Overview (19 min) 1.1 What is Visual Basic? 1.2 History and Features 1.3 Advantages 1.4 Versions and Components 2.0 Windows (13 min) 2.1 Overview of Windows 2.2 Versions and Computing Terms 3.0 The VB Environment (1 Hour 18 min) 3.1 Overview of VB Environment 3.2 Setting up the VB Environment 3.3 Forms 3.4 Controls and Labels 3.5 Setting  more...

Visual Basic 6 0 Complete Set of 17 Level 1 (1 Hour 51 Minutes) 1.0 Overview (19 min) 1.1 What is Visual Basic? 1.2 History and Features 1.3 Advantages 1.4 Versions and Components 2.0 Windows (13 min) 2.1 Overview of Windows 2.2 Versions and Computing Terms 3.0 The VB Environment (1 Hour 18 min) 3.1 Overview of VB Environment 3.2 Setting up the VB Environment 3.3 Forms 3.4 Controls and Labels 3.5 Setting  more...

Visual Basic 6 0 Client Server Techniques LV 13 Level 13 Client/Server Techniques (2 Hours 15 Minutes) 1.0 What is Client/Server (18 min) 1.1 Concepts 1.2 Network File Server 1.3 Splitting the Application 1.4 Where do you put the Logic 1.5 Dead Vs Live Data 1.6 Multi-User Considerations 1.7 Cursors 1.8 Lock Types 1.9 Cursor Limitations 2.0 ODBC and OLE DB Overview (6 min) 2.1 What is ODBC? 2.2 ODBC Components 2.3 ODBC  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...

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 7 Access 2000 Developer Level 7 (1 Hour 56 Minutes) 1.0 Debugging (56 Minutes) 1.1 Avoiding Bugs 1.2 The Immediate Window 1.3 Invoking the Debugger & Breakpoints 1.4 Stepping Through Code & Modifying Values 1.5 Placing Breakpoints 1.6 The Step Over Feature 1.7 The Step Out Feature 1.8 Setting the Next Statement to Execute 1.9 The Call Stack Window 1.10 The Locals Window 1.11 Watch  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 3 SQL 7.0 Data Warehousing Level 3 (1 Hr 28 Mins) 1.0 Storing & Processing Cubes (32 Mins) 1.1 MOLAP, ROLAP, & HOLAP Storage Structures 1.2 Comparing ROLAP & MOLAP 1.3 Review & Compare Storage Options 1.4 Storing Partitions & Processing Cubes 1.5 Calculated Members 1.6 The Virtual Cube, Cube Security & Roles 2.0 Analyzing Data Using Clients (28 Mins) 2.1 Navigating Warehouse Data &  more...

Linux Essentials Set of 4 Lesson 1: Linux Essentials Linux Essentials Overview Module Objectives Linux System Overview Differences in Linux and Unix Operating Systems Overview Linux Installation Details Installation Objectives Install Steps Hardware Requirements Hardware Control Linux Device Names Installation Methods Installation Classes Partitioning the Hard Drive Network  more...