Access 2000 Developer Series (16 levels) - on DVD

Access 2000 Developer Series (16 levels)

Access 2000 Developer Series (16 levels) - on DVD

1.0 Access as a Development Tool
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
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.0 Relationships
3.1 Introduction to Relationships
3.2 Types of Relationships
3.3 Referential Integrity
3.4 Benefits of Relationships
3.5 Indexes & Relationships

4.0 Query Basics
4.1 Query Basics
4.2 The Query & Query Result
4.3 Refining Queries with Criteria
4.4 Updatability of Query Results
4.5 Queries Based on Multiple Tables

1.0 More About Query Basics
1.1 Calculated Fields
1.2 Summarizing Data
1.3 Excluding Fields
1.4 Nulls & Query Results
1.5 Field
1.6 Parameter Queries

2.0 Forms
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
2.9 Command Button Wizards
2.10 Forms Based on More than One Table

3.0 Reports
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
3.8 Reports Based on More than One Table
3.9 Sorting & Grouping

1.0 Introduction to VBA
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
2.1 Declaring Variables
2.2 Data Types
2.3 Scope & Lifetime of Variables
2.4 Comments & Line Continuation
2.5 Adding Comments & Line Continuation

3.0 Control Structures
3.1 If-Then-Else
3.2 Conditional If
3.3 Select Case

4.0 Looping Constructs
4.1 Do WhileLoop
4.2 DoLoop While
4.3 Do UntilLoop & DoLoop Until
4.4 For Next
4.5 WithEnd With
4.6 For EachNext

5.0 Passing Parameters & Returning Values
5.1 Passing Parameters Positionally
5.2 Returning Values

6.0 Built-in Functions
6.1 Format
6.2 Instr
6.3 Left & Right
6.4 Mid
6.5 Ucase
6.6 DatePart
6.7 The Object Browser

7.0 Working with Constants
7.1 Symbolic Constants
7.2 Intrinsic Constants

8.0 The Visual Basic Editor
8.1 IntelliSense
8.2 The VBE Environment
8.3 Customizing the VBE Environment

1.0 Objects
1.1 The Object Model
1.2 Objects 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 & Functions
1.8 Determining the Type of a Control

2.0 Advanced Form Techniques
2.1 Form Events
2.2 The Sequence of Form Events
2.3 Section & Control Events
2.4 Types of Forms
2.5 Built-in Dialogs
2.6 Menus

3.0 More Advanced Form Techniques
3.1 Switching a Forms RecordSource
3.2 Power Combo & Listbox Techniques
3.3 Power Subform Techniques
3.4 Synchronizing a Form with its Underlying Recordset

1.0 Advanced Report Techniques
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
2.1 Changing Reports Record Source
2.2 Displaying Summary & Detail Information
2.3 Printing Mailing Labels

2.4 Determining Mailing Label Positions
2.5 Printing Page Headers

3.0 Advanced Query Techniques
3.1 Action Queries
3.2 Query Properties
3.3 Optimizing Queries
3.4 Building Cross-tab Queries
3.5 Outer Joins & Self Joins
3.6 SQL & Union Queries
3.7 Passing Parameters Queries

1.0 ActiveX Data Objects & Data Access Objects Introduced
1.1 Understanding ADO & DAO
1.2 ADO versus DAO
1.3 The ADO Object Model

2.0 ADO Recordset Types
2.1 CursorType
2.2 LockType
2.3 Options Parameter

3.0 Working with ADO Recordset Properties & Methods
3.1 Record-Movement Methods
3.2 Detecting Limits of a Recordset
3.3 Counting Records in a Recordset
3.4 Sorting
3.5 AbsolutePosition
3.6 The Bookmark Property
3.7 Executing Parameterized Queries

4.0 Modifying Table Data
4.1 Updating Records using ADO
4.2 Deleting Records
4.3 Adding Records

5.0 Creating & Modifying Database Objects Using Code
5.1 Adding a Table
5.2 Removing a Table
5.3 Establishing Relationships
5.4 Creating Queries

6.0 Data Access Objects A Crash Course
6.1 The DAO Object Hierarchy
6.2 DAO Recordset Types
6.3 DAO Recordset Properties & Methods
6.4 Sorting
6.5 Running a Parameter Query using DAO Code
6.6 Modifying Data & Adding & Deleting Records:
6.7 Creating a Table & other Objects

1.0 Debugging
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.0 Error Handling
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.0 Generic Error Handlers
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

1.0 Optimizing Your Application
1.1 Optimization - An Overview
1.2 Improving Performance with Hardware & Software
1.3 Jet 4.0 & 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 & Reports to Improve Performance

2.0 A Strategy for Application Development
2.1 Splitting Tables & Other Objects
2.2 Basing Forms & 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.0 Developing Multi-user Applications
3.1 Developing with Multi-users in Mind
3.2 Access Locking Mechanisms
3.3 Locking & 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.0 Using External Data
4.1 External Data
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 & Removing Links

1.0 Client/Server Techniques
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 Client/Server Strategies
2.1 Selecting the Best Recordset Type
2.2 Pass-through Queries & Stored Procedures
2.3 Using Access Data Projects
2.4 Optimizing Data Handling
2.5 Optimizing Queries & Forms

3.0 Client/Server Application
3.1 Creating a Client/Server Application Using Linked Tables
3.2 Creating a Client/Server Application Using an Access Data Projects

1.0 Transactions
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
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.0 The Replication Manager
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

1.0 Advanced VBA Techniques (1 Hr)
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 & Null
1.6 Creating & Working with Custom Collections
1.7 Compilation Options
1.8 Importing & Exporting Code Modules
1.9 Project Properties

2.0 Using ActiveX Controls
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

1.0 Automation: Communicating with Other Applications
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.0 Exploiting the Power of the Windows API
2.1 Declaring an External Function to the Compiler
2.2 Working with Constants & Types & Calling DLL's
2.3 Using API Functions

1.0 Exploiting the Power of Class Modules
1.1 Exploring the Benefits of Class Modules
1.2 Object Orientation An Introduction
1.3 Creating & Using a Class Module
1.4 Creating Multiple Class Instances
1.5 The Initialize & Terminate Events
1.6 Class Module Examples
1.7 Working with Custom Collections

2.0 Creating Your Own Libraries
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.0 Builders
3.1 Using Builders
3.2 Using Wizards

1.0 Access & the Internet
1.1 What's New with Access & 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 & 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.0 Data Access Pages
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

1.0 Security
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 & Groups
1.9 Assigning Rights to Users & Groups
1.10 Creating an MDE File
1.11 Special Issues

2.0 nced Security
2.1 Maintaining Groups Using Code
2.2 Using Code to Maintain Users
2.3 Listing Users & Groups
2.4 Working with Passwords
2.5 Accomplishing Field-level Security Using Queries

1.0 Documenting Your Application
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
2.1 Compacting & Repairing Your Database

3.0 The Microsoft Office Developer
3.1 Distributing Your Application
3.2 Looking at the MOD

4.0 Managing the Development Process with Visual SourceSafe
4.1 Installing Visual SourceSafe
4.2 Using Visual SourceSafe

5.0 Distributing Your Application
5.1 Introducing the Package & Deployment Wizard
5.2 Loading the Package & 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