2000 Application Training on CD-ROM
 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 Application Developer Set of 16
...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...
...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
...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...
...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
...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...
...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
...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 Selecting
more...
...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 Selecting
more...
Access 2000 Application Developer LV 1
...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 Selecting
more...
...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 Selecting
more...
Access 2000 Application Developer LV 2
...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...
...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 3
...2000 Application Development Level 3 (2 Hours 6 Minutes)
1.0 Introduction to VBA (28 Minutes)
1.1 Why Use VBA
1.2 Types of Modules
1.3 Anatomy of a Module
1.4 Option Explicit
1.5 Event Procedures
1.6 User-defined Procedures
1.7 Scope of Procedures
2.0 Working with Variables (16 Minutes)
2.1 Declaring Variables
2.2 Data Types
2.3 Scope and Lifetime of Variables
3.0 Comments
more...
...2000 Application Development Level 3 (2 Hours 6 Minutes)
1.0 Introduction to VBA (28 Minutes)
1.1 Why Use VBA
1.2 Types of Modules
1.3 Anatomy of a Module
1.4 Option Explicit
1.5 Event Procedures
1.6 User-defined Procedures
1.7 Scope of Procedures
2.0 Working with Variables (16 Minutes)
2.1 Declaring Variables
2.2 Data Types
2.3 Scope and Lifetime of Variables
3.0 Comments
more...
Access 2000 Application Developer LV 4
...2000 Application Development Level 4 (2 Hours 14 Minutes) 1.0 Objects, Properties, Methods, and Events (49 Minutes) 1.1 The Object Model 1.2 Objects, Properties, Methods, and Events Defined 1.3 The Object Browser 1.4 Referring to Objects 1.5 Object Variables 1.6 Objects Versus Collections 1.7 Passing Objects to Subroutines and Functions 1.8 Determining the Type of a Control 2.0
more...
...2000 Application Development Level 4 (2 Hours 14 Minutes) 1.0 Objects, Properties, Methods, and Events (49 Minutes) 1.1 The Object Model 1.2 Objects, Properties, Methods, and Events Defined 1.3 The Object Browser 1.4 Referring to Objects 1.5 Object Variables 1.6 Objects Versus Collections 1.7 Passing Objects to Subroutines and Functions 1.8 Determining the Type of a Control 2.0
more...
Access 2000 Application Developer LV 5
...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...
...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
...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 Record-Movement
more...
...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 Record-Movement
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...
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...
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...
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 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 10
Access Application Development Level 10 (1 Hour 44 Minutes) 1.0 Transactions (18 Minutes) 1.1 What is Transaction Processing? 1.2 Implementing Explicit Transaction Processing 1.3 Looking at Transaction Processing Issues 1.4 Transaction Processing in a Multi-user Environment 2.0 Replication (44 Minutes) 2.1 Uses of Replication 2.2 Implementation of Replication 2.3 The Replication
more...
Access Application Development Level 10 (1 Hour 44 Minutes) 1.0 Transactions (18 Minutes) 1.1 What is Transaction Processing? 1.2 Implementing Explicit Transaction Processing 1.3 Looking at Transaction Processing Issues 1.4 Transaction Processing in a Multi-user Environment 2.0 Replication (44 Minutes) 2.1 Uses of Replication 2.2 Implementation of Replication 2.3 The Replication
more...
Access 2000 Application Developer LV 11
Application Development Level 11 (1 Hour 54 Minutes)
1.0 Advanced VBA Techniques (1 Hour)
1.1 User-Defined Types
1.2 Working with Constants
1.3 Working with Arrays
1.4 Advanced Function Techniques
1.5 Working with Empty and Null
1.6 Creating and Working with Custom Collections
1.7 Compilation Options
1.8 Importing and Exporting Code Modules
1.9 Project Properties
2.0 Using ActiveX
more...
Application Development Level 11 (1 Hour 54 Minutes)
1.0 Advanced VBA Techniques (1 Hour)
1.1 User-Defined Types
1.2 Working with Constants
1.3 Working with Arrays
1.4 Advanced Function Techniques
1.5 Working with Empty and Null
1.6 Creating and Working with Custom Collections
1.7 Compilation Options
1.8 Importing and Exporting Code Modules
1.9 Project Properties
2.0 Using ActiveX
more...
Access 2000 Application Developer LV 12
Application Development Level 12 (1 Hour 53 Minutes)
1.0 Automation: Communicating with Other Applications (1 Hour 2 Minutes)
1.1 Automation Terms
1.2 Declaring an Object Variable
1.3 Creating an Automation Object
1.4 Manipulating an Automation Object
1.5 Controlling Excel from Access & Closing an Excel Automation Object
1.6 Creating a Graph from Access
1.7 Controlling Word from Access
more...
Application Development Level 12 (1 Hour 53 Minutes)
1.0 Automation: Communicating with Other Applications (1 Hour 2 Minutes)
1.1 Automation Terms
1.2 Declaring an Object Variable
1.3 Creating an Automation Object
1.4 Manipulating an Automation Object
1.5 Controlling Excel from Access & Closing an Excel Automation Object
1.6 Creating a Graph from Access
1.7 Controlling Word from Access
more...
Access 2000 Application Developer LV 13
Application Development Level 13 (2 Hours 2 Minutes)
1.0 Exploiting the Power of Class Modules (59
min)
1.1 Exploring the Benefits of Class Modules
1.2 Object Orientation a a An Introduction
1.3 Creating and Using a Class Module
1.4 Creating Multiple Class Instances
1.5 The Initialize and Terminate Events
1.6 Class Module Examples
1.7 Working with Custom Collections
2.0
more...
Application Development Level 13 (2 Hours 2 Minutes)
1.0 Exploiting the Power of Class Modules (59
min)
1.1 Exploring the Benefits of Class Modules
1.2 Object Orientation a a An Introduction
1.3 Creating and Using a Class Module
1.4 Creating Multiple Class Instances
1.5 The Initialize and Terminate Events
1.6 Class Module Examples
1.7 Working with Custom Collections
2.0
more...
Access 2000 Application Developer LV 14
Application Development Level 14 (1 Hour 37 Minutes)
1.0 Access and the Internet (46 Minutes)
1.1 What's New with Access and the Internet
1.2 Saving Database Objects as HTML
1.3 Linking to HTML Files
1.4 Importing HTML Files
1.5 Deciding Between Static and Dynamic HTML Formats
1.6 Working with Active Server Pages
1.7 Testing ASP Files
1.8 Working with HTX/IDC Files
1.9 Working with
more...
Application Development Level 14 (1 Hour 37 Minutes)
1.0 Access and the Internet (46 Minutes)
1.1 What's New with Access and the Internet
1.2 Saving Database Objects as HTML
1.3 Linking to HTML Files
1.4 Importing HTML Files
1.5 Deciding Between Static and Dynamic HTML Formats
1.6 Working with Active Server Pages
1.7 Testing ASP Files
1.8 Working with HTX/IDC Files
1.9 Working with
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...
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...
Access 2000 Application Developer LV 16
Application Development Level 16 (2 Hours 6 Minutes)
1.0 Documenting Your Application (25 Minutes)
1.1 Preparing Your Application to be Self-Documenting
1.2 Using the Database Documenter
1.3 Writing Code to Create Documentation
2.0 Maintaining Your Application (16 Minutes)
2.1 Compacting & Repairing Your Database
3.0 The Microsoft Office Developer (26 Minutes)
3.1 Distributing Your
more...
Application Development Level 16 (2 Hours 6 Minutes)
1.0 Documenting Your Application (25 Minutes)
1.1 Preparing Your Application to be Self-Documenting
1.2 Using the Database Documenter
1.3 Writing Code to Create Documentation
2.0 Maintaining Your Application (16 Minutes)
2.1 Compacting & Repairing Your Database
3.0 The Microsoft Office Developer (26 Minutes)
3.1 Distributing Your
more...
