Access 2000 Beginning (2 Hours 6 Minutes)

1. Introduction (26 Minutes)
   1.1 Starting Access
   1.2 Opening an Existing Database
   1.3 The Access Desktop
   1.4 The Database Window
   1.5 A Preview of the Database Components
   
2. Working with an Existing Database (33 Minutes)
   2.1 Viewing and Navigating Table Data
   2.2 Editing Table Data
   2.3 Adding Records to a Table
   2.4 Selecting and Deleting Records
   2.5 Find and Replace
   2.6 Modifying the Appearance of a Datasheet
   2.7 Spell-Check and Auto-correct
   
3. Form Basics (25 Minutes)
   3.1 Moving from Record to Record
   3.2 Finding
   3.3 Sorting
   3.4 Filtering
   3.5 AutoForms
   3.6 Using a Form Wizard
   3.7 Conditional Formatting
   
4. Report Basics (15 Minutes)
   4.1 Moving form Page to Page
   4.2 Zooming In and Out
   4.3 Viewing Multiple Pages
   4.4 Printing
   4.5 AutoReports & the Report Wizard
   4.6 Page Setup
   
5. Printing Database Objects (5 Minutes)
   5.1 Printing Table Datasheets
   5.2 Printing Queries
   5.3 Printing Forms
   5.4 Printing Reports
   
6. Getting Help (8 Minutes)
   6.1 The Office Assistant & Index Searching
   6.2 Context-Sensitive Help & Printing Help Topics
   
7. 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 to a Previous Version
   7.4 Organizing Database Objects into Groups
   

Access 2000 Intermediate (2 Hours 4 Minutes)

1. 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. 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 Field Properties
   2.5 Input Masks
   2.6 The Lookup Wizard
   2.7 Indexes
   
3. Working with Relationships (27 Minutes)
   3.1 Introduction to Relationships
   3.2 Benefits of Relationships
   3.3 Types of Relationships
   3.4 Referential Integrity
   3.5 Indexes and Relationships
   3.6 Printing Relationships
   
4. Designing Simple Queries (27 Minutes)
   4.1 Selecting Fields & Ordering the Query Result
   4.2 Refining Queries with Criteria
   4.3 Updatability of Query Results
   4.4 Queries Based on Multiple Tables
   

Access 2000 Advanced (2 Hours 3 Minutes)

1. Building and Modifying Forms (51 Minutes)
   1.1 Adding Controls
   1.2 Selecting Controls
   1.3 Moving, Sizing and Deleting Controls
   1.4 Aligning Controls
   1.5 Changing Control Properties
   1.6 Changing the Tab Order Controls
   1.7 Form Properties
   1.8 Working with Combo Boxes and List Boxes
   
2. Building and Modifying Reports (26 Minutes)
   2.1 Understanding Report Bands
   2.2 Working with Controls
   2.3 Creating Groups and Totals Reports
   2.4 Working with Report Properties
   2.5 Modifying Selection Criteria
   
3. Database Startup Options (5 Minutes)
   3.1 Setting the Application, Icon, and Startup Form
   3.2 Designing other Startup Information
   
4. Importing, Exporting and Linking (39 Minutes)
   4.1 Exporting to another Database
   4.2 Exporting to an Excel Spreadsheet
   4.3 Exporting to ASCII
   4.4 Exporting to HTML
   4.5 Importing from anther Access Database
   4.6 Importing Spreadsheet Data
   4.7 Importing ASCII Data
   4.8 Importing from HTML
   4.9 Linking to Anther Access Database
   4.10 Linking to anther types of Database
   4.11 The Linked Table Manager
   

Access 2000 Expert Topics (1 Hour 55 Minutes)

1. Advanced Query Design Techniques (58 Minutes)
   1.1 Calculated Fields
   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. 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 and Subforms
   2.4 Adding OLE Objects to Forms
   2.5 Using a Bitmap as a Form Background
   2.6 Adding Calculated Controls to a Form
   2.7 Other Important Form Control Properties
   2.8 Creating a Switchboard
   2.9 Saving a Form as HTML
   
3. Advanced Report Design Techniques (19 Minutes)
   3.1 Building Reports with Sub-Reports
   3.2 Setting Section Properties
   3.3 Adding Graphics to a Report
   3.4 Adding / Modifying Calculations
   

Access 2000 Web/Security (2 Hours 2 Minutes)

1. Access and the Web (23 Minutes)
   1.1 Creating Data Access Pages
   1.2 Modifying Data Access Page Properties
   1.3 Modifying Record Navigating Control Properties
   1.4 Grouping and Sorting Data within Data Access Pages
   
2. Charting Table Data (17 Minutes)
   2.1 Using the Chart Wizard
   2.2 Linking a Chart to a Record
   
3. Security Basics (10 Minutes)
   3.1 Establishing a Database Password
   3.2 Modifying a Database Password
   3.3 Encrypting and Decrypting a Database
   
4. Replication Basics (23 Minutes)
   4.1 Introduction to Replication
   4.2 Converting a Database to a Design Master
   4.3 Creating Additional Replicas
   4.4 Synchronizing Changes
   4.5 Managing Conflicts
   
5. Developing Apps with Macros (29 Minutes)
   5.1 Creating a Macro
   5.2 Running a Macro
   5.3 Adding Macro Names
   5.4 Modifying an Existing Macro
   5.5 Adding Conditions to a Macro
   
6. Special Topics (19 Minutes)
   6.1 Optimizing Data Types Usage
   6.2 Establishing One-to-One Relationships
   6.3 Using Add-ins
   6.4 Report and Form Section Properties
   

Detailed Video Outlines

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