Beginning
Access 2000 (2 Hrs 6 Mins)
1.0
Introduction (26 Mins)
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.0 Working with an Existing Database (33 Mins)
2.1 Viewing & Navigating Table Data
2.2 Editing Table Data
2.3 Adding Records to a Table
2.4 Selecting & Deleting Records
2.5 Find & Replace
2.6 Modifying the Appearance of a Datasheet
2.7 Spell-Check & Auto-correct
3.0 Form Basics (25 Mins)
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.0 Report Basics (15 Mins)
4.1 Moving form Page to Page
4.2 Zooming In & Out
4.3 Viewing Multiple Pages
4.4 Printing
4.5 AutoReports & the Report Wizard
4.6 Page Setup
5.0 Printing Database Objects (5 Mins)
5.1 Printing Table Datasheets
5.2 Printing Queries
5.3 Printing Forms
5.4 Printing Reports
6.0 Getting Help (8 Mins)
6.1 The Office Assistant & Index Searching
6.2 Context-Sensitive Help & Printing Help Topics
7.0 Database Maintenance & Shortcuts (12 Mins)
7.1 Backing Up & Restoring a Database
7.2 Compacting & Repairing a Database
7.3 Converting a Database to a Previous Version
7.4 Organizing Database Objects into Groups
Intermediate Access 2000 (2 Hrs 4 Mins)
1.0
Planning & Designing a Database (20 Mins)
1.1 Evaluating Inputs & Outputs
1.2 Normalization
1.3 Creating a Database Using a Wizard
1.4 Creating a Database from Scratch
2.0 Building & Modifying Tables (49 Mins)
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.0 Working with Relationships (27 Mins)
3.1 Introduction to Relationships
3.2 Benefits of Relationships
3.3 Types of Relationships
3.4 Referential Integrity
3.5 Indexes & Relationships
3.6 Printing Relationships
4.0 Designing Simple Queries (27 Mins)
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
Advanced
Access 2000 (2 Hrs 3 Mins)
1.0
Building & Modifying Forms (51 Mins)
1.1 Adding Controls
1.2 Selecting Controls
1.3 Moving
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 & List Boxes
2.0 Building & Modifying Reports (26 Mins)
2.1 Understanding Report Bands
2.2 Working with Controls
2.3 Creating Groups & Totals Reports
2.4 Working with Report Properties
2.5 Modifying Selection Criteria
3.0 Database Startup Options (5 Mins)
3.1 Setting the Application
3.2 Designing other Startup Information
4.0 Importing (41 Mins)
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 Another Access Database
4.10 Linking to Other types of Databases
4.11 The Linked Table Manager