Access 2000 Application Development Level 1 (2 Hours 5 Minutes)

1. 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. Tables (39 Minutes)
   2.1 Building a New Table
   2.2 Selecting the Appropriate Field Type
   2.3 Working with Field Properties
   2.4 The Primary Key
   2.5 The Lookup Feature
   2.6 Table Properties
   2.7 Using Indexes to Improve Performance
   
3. Relationships (21 Minutes)
   3.1 Introduction to Relationships
   3.2 Types of Relationships
   3.3 Referential Integrity
   3.4 Benefits of Relationships
   3.5 Indexes and Relationships
   
4. 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. 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. 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. Reports (35 Minutes)
   3.1 Types of Reports
   3.2 Anatomy of a Report
   3.3 Creating a New Report
   3.4 The Report Design Window
   3.5 Report Properties
   3.6 Control Properties
   3.7 Bound, Unbound, and Calculated Controls
   3.8 Reports Based on More than One Table
   3.9 Sorting and Grouping
   

Access 2000 Application Development Level 3 (2 Hours 6 Minutes)

1. 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. Working with Variables (16 Minutes)
   2.1 Declaring Variables
   2.2 Data Types
   2.3 Scope and Lifetime of Variables
   
3. Comments and Line Continuation (5 Minutes)
   3.1 Adding Comments & Line Continuation
   
4. Control Structures (11 Minutes)
   4.1 If-Then-Else
   4.2 Conditional If
   4.3 Select Case
   
5. Looping Constructs (19 Minutes)
   5.1 Do While…Loop
   5.2 Do…Loop While
   5.3 Do Until…Loop & Do…Loop Until
   5.4 For Next
   5.5 With…End With
   5.6 For Each…Next
   
6. Passing Parameters and Returning Values (9 Minutes)
   6.1 Passing Parameters Positionally
   6.2 Returning Values
   
7. Built-in Functions (16 Minutes)
   7.1 Format
   7.2 Instr
   7.3 Left & Right
   7.4 Mid
   7.5 Ucase
   7.6 DatePart, DateDiff & DateAdd
   7.7 The Object Browser
   
8. Working with Constants (9 Minutes)
   8.1 Symbolic Constants
   8.2 Intrinsic Constants
   
9. The Visual Basic Editor (10 Minutes)
   9.1 IntelliSense
   9.2 The VBE Environment
   9.3 Customizing the VBE Environment
   

Access 2000 Application Development Level 4 (2 Hours 14 Minutes)

1. 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. Advanced Form Techniques (4 Minutes)
   2.1 Form Events
   2.2 The Sequence of Form Events
   2.3 Section and Control Events
   2.4 Types of Forms
   2.5 Built-in Dialogs
   2.6 Menus, Toolbars, and Shortcut Menus
   
3. More Advanced Form Techniques (20 Minutes)
   3.1 Switching a Forms RecordSource
   3.2 Power Combo and Listbox Techniques
   3.3 Power Subform Techniques
   3.4 Synchronizing a Form with its Underlying Recordset
   

Access 2000 Application Development Level 5 (2 Hours 7 Minutes)

1. 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. 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 Determining Mailing Label Positions
   2.5 Printing Page Headers
   
3. Advanced Query Techniques (16 Minutes)
   3.1 Action Queries
   3.2 Query Properties
   3.3 Optimizing Queries
   3.4 Building Cross-tab Queries
   3.5 Outer Joins and Self Joins
   3.6 SQL & Union Queries
   3.7 Passing Parameters Queries
   

Access 2000 Application Development Level 6 (2 Hours 7 Minutes)

1. 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. ADO Recordset Types (12 Minutes)
   2.1 CursorType
   2.2 LockType
   2.3 Options Parameter
   
3. Working with ADO Recordset Properties and Methods (28 Minutes)
   3.1 Record-Movement Methods
   3.2 Detecting Limits of a Recordset
   3.3 Counting Records in a Recordset
   3.4 Sorting, Filtering, and Finding Records
   3.5 AbsolutePosition
   3.6 The Bookmark Property
   3.7 Executing Parameterized Queries
   
4. Modifying Table Data (19 Minutes)
   4.1 Updating Records using ADO
   4.2 Deleting Records
   4.3 Adding Records
   
5. 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. Data Access Objects – A Crash Course (32 Minutes)
   6.1 The DAO Object Hierarchy
   6.2 DAO Recordset Types
   6.3 DAO Recordset Properties and Methods
   6.4 Sorting, Filtering, and Finding using DAO Code
   6.5 Running a Parameter Query using DAO Code
   6.6 Modifying Data & Adding & Deleting Records:
   6.7 Creating a Table and other Objects
   

Access 2000 Developer Level 7 (1 Hour 56 Minutes)

1. 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 Expressions
   
2. Error Handling (38 Minutes)
   2.1 Implementing Error Handling
   2.2 Error Events
   2.3 Using OnError Statements
   2.4 Resume Statements
   2.5 Clearing Errors
   2.6 The Cascading Error Effect
   2.7 The Error Object
   2.8 Raising an Error
   2.9 The Errors Collection
   
3. Generic Error Handlers (21 Minutes)
   3.1 Invoking Generic Error Handlers
   3.2 Logging Errors
   3.3 Determining the Appropriate Response to an Error
   3.4 Creating an Error Form
   

Access 2000 Developer Level 8 (2 Hours 16 Minutes)

1. 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 Designing Forms and Reports to Improve Performance
   
2. 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 for Distribution
   2.5 EXE versus Database
   2.6 The Importance of Security
   2.7 Access as a Front-end
   
3. Developing Multi-user Applications (36 Minutes)
   3.1 Developing with Multi-users in Mind
   3.2 Access Locking Mechanisms
   3.3 Locking and Refresh Strategies
   3.4 Form & Other Locking Strategies
   3.5 Recordset Locking
   3.6 Effectively Handling Locking Conflicts
   3.7 More on Locking Conflicts & Refresh versus Re-query
   3.8 Understanding the LDB File
   3.9 Other Multi-user Strategies
   
4. Using External Data (29 Minutes)
   4.1 External Data, Importing, Linking, and Opening
   4.2 Selecting Options
   4.3 Importing External Data
   4.4 Creating a Link to External Data
   4.5 Opening an External Table
   4.6 Refreshing and Removing Links
   

Access 2000 Developer Level 9 (1 Hour 59 Minutes)

1. 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. Client/Server Strategies (22 Minutes)
   2.1 Selecting the Best Recordset Type
   2.2 Pass-through Queries and Stored Procedures
   2.3 Using Access Data Projects
   2.4 Optimizing Data Handling
   2.5 Optimizing Queries and Forms
   
3. Client/Server Application (18 Minutes)
   3.1 Creating a Client/Server Application Using Linked Tables
   3.2 Creating a Client/Server Application Using an Access Data Projects
   

Access Application Development Level 10 (1 Hour 44 Minutes)

1. 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. Replication (44 Minutes)
   2.1 Uses of Replication
   2.2 Implementation of Replication
   2.3 The Replication Architecture
   2.4 Replication Topologies
   2.5 Changes Replication Makes to the Database & Making a Database Replicable
   2.6 Creating Additional Replicas
   2.7 Synchronizing Replicas & Resolving Replication Conflicts
   2.8 Partial Replication
   2.9 Implementing Replication Using Code
   
3. The Replication Manager (30 Minutes)
   3.1 Running the Replication Manager for the First Time
   3.2 Replicating a Database with the Replication Manager
   3.3 Creating Replicas with the Replication Manager
   3.4 Synchronizing with the Replication Manager & Reviewing the History
   3.5 Synchronization Properties
   

Application Development Level 11 (1 Hour 54 Minutes)

1. 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. Using ActiveX Controls (52 Minutes)
   2.1 ActiveX Controls Explained
   2.2 Incorporating ActiveX Controls
   2.3 Setting ActiveX Control Properties at Design Time
   2.4 Coding Events of an ActiveX Control
   2.5 The Calendar Control
   2.6 The UpDown Control
   2.7 The StatusBar Control
   2.8 The Common Dialog Control
   2.9 The Rich Textbox Control
   2.10 The TabStrip Control
   2.11 The ImageList Control
   

Application Development Level 12 (1 Hour 53 Minutes)

1. 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
   1.8 Controlling PowerPoint from Access
   1.9 Controlling Access from Other Applications
   
2. Exploiting the Power of the Windows API (50 Minutes)
   2.1 Declaring an External Function to the Compiler
   2.2 Working with Constants and Types & Calling DLL's
   2.3 Using API Functions
   

Application Development Level 13 (2 Hours 2 Minutes)

1. Exploiting the Power of Class Modules (59 min)
   1.1 Exploring the Benefits of Class Modules
   1.2 Object Orientation – 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. Creating Your Own Libraries (17 Minutes)
   2.1 Preparing a Database to be a Library
   2.2 Creating a Reference
   2.3 Debugging a Library Database
   2.4 Securing an Access Library
   
3. Builders, Wizards, and Menu Add-Ins (40 Minutes)
   3.1 Using Builders
   3.2 Using Wizards
   

Application Development Level 14 (1 Hour 37 Minutes)

1. 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 HTML Templates
   
2. Data Access Pages (50 Minutes)
   2.1 Understanding Data Access Pages
   2.2 Creating Data Access Pages
   2.3 Modifying Important Properties of a Data Access Page
   2.4 Modifying Record Navigation Control Properties
   2.5 Creating Grouped Data Access Pages
   2.6 Modifying Properties to Change Behavior
   2.7 Augmenting Data Access Pages with VBScript
   

Application Development Level 15 (1 Hour 51 Minutes)

1. Security (1 Hour 5 Minutes)
   1.1 Share-Level Security
   1.2 Encrypting a Database
   1.3 User-level Security – 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 Creating an MDE File
   1.11 Special Issues
   
2. Advanced Security (45 Minutes)
   2.1 Maintaining Groups Using Code
   2.2 Using Code to Maintain Users
   2.3 Listing Users and Groups
   2.4 Working with Passwords
   2.5 Accomplishing Field-level Security Using Queries
   

Application Development Level 16 (2 Hours 6 Minutes)

1. 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. Maintaining Your Application (16 Minutes)
   2.1 Compacting & Repairing Your Database
   
3. The Microsoft Office Developer (26 Minutes)
   3.1 Distributing Your Application
   3.2 Looking at the MOD
   
4. Managing the Development Process with Visual SourceSafe (21 Minutes)
   4.1 Installing Visual SourceSafe
   4.2 Using Visual SourceSafe
   
5. Distributing Your Application (36 Minutes)
   5.1 Introducing the Package and Deployment Wizard
   5.2 Loading the Package and Deployment Wizard
   5.3 Distributing an Application to Run with a Full Copy of Access
   5.4 Using Full Versus Runtime Versions of Access
   5.5 Preparing a Database for Use with the Runtime
   

Detailed Video Outlines

Access 2000 is part of the MicroSoft Office 2000 Premium Combo Sets
Check out our list of Keystone Training Videos