What Microsoft Access 2000 Basic Covers...

 
Lesson 1:  Access 2000 Basic
  • Introduction
  •  Databasics
  • Microsoft Access 2000 Overview
  • Conclusion
Lesson 2:  Getting Started With Access 2000  
  • Installing The Northwind Database
  • Opening Access 2000
  • Opening An Existing Database
  • The Access Database Window
  • Viewing System Objects
  • New Menu Actions
  • Access 2000 Display Options
  • Hiding Objects
  • Database Window Open Options
  • View Options
  • Switching Views
  • The Objects Bar
  • The Details View
  • Object Selection
  • Opening An Object
  • Navigating Amongst Records
  • Adding Records In Datasheet View
  • Working With Fields
  • Sorting Records By Field
  • Switching Between Tables The OLE Object Field
  • Embedded Images
  • Inserting An Object Into A Table
  • Linking Or Embedding
  • Design View
  • A Queries Overview
  • Query Design View
  • Viewing Forms
  • Viewing Reports
  • Viewing Multiple Pages
  • The Multiple Pages Button
  • Form Design View
  • The Page Object
  • The Macro
  • The Module
  • Closing Access 2000
Lesson 3:  Creating A New Database
  • Creating a Desktop Shortcut
  • Creating A Blank Database
  • Filing Options
  • Access 2000 Options
  • Name AutoCorrect
  • Creating A New Table
  • Using The Table Wizard
  • Adding Fields
  • Renaming A Field
  • Removing Fields
  • Importing Data
  • The Link Text Wizard
  • Field Delimiters
  • Text Qualifiers
  • Import Or Link Data
  • Importing Text Files
  • Advanced Import Options
  • Saving Import Specifications
  • Saved Import\Link Specifications
  • Choosing A Primary Key
  • Naming The Table
  • Viewing Existing Tables
  • Print Preview
  • Printing Tables
Lesson 4:  Working With Forms And Data  
  • The Microsoft Office Shortcut Bar
  • Customizing The Office Shortcut Bar
  • Customizing Toolbars And Menus
  • Modifying Button Appearance
  • Modifying Button Functions
  • Modifying Button Location
  • Modifying Menus
  • Toolbar Default Restoration
  • Importing Existing Tables
  • Database Relationships
  • Importing Existing Database Objects
  • Adding Table Relationships
  • Adding A Sub-datasheet
  • Using Autoform
  • Using The Form Wizard
  • Using The Access 2000 Find Feature
  • Find Options
  • Closing The Microsoft Office Shortcut Bar
Lesson 5:  Simple Filters And Queries
  • Creating A Selection Filter
  • Applying A Selection Filter
  • Using The Shortcut Menu Selection Filter
  • Removing Filters
  • Filtering By Exclusion
  • Using The Filter For Feature
  • Using Queries
  • The Simple Query Wizard
  • Viewing Multiple Objects Simultaneously
  • The Query Design Window
  • Hiding Fields In A Query
  • Adding A Field To A Query
  • Using A Numeric Expression In A Query
Lesson 6:  Visual Basic And Access 2000  
  • Introduction To Reports And The Help System
  • Introduction - Creating A Tabular Report
  • Viewing Your Report
  • The Report Design View
  • Adding A Label To A Report
  • Creating A Text Box
  • Binding A Field To A Text Box
  • Grouping Fields In A Report
  • Formatting A Group Header
  • Creating Multiple Groups
  • Printing Your Report Grouping Database
  • Objects Creating A New Group
  • Naming Your New Group
  • Adding Objects To A Group
  • Viewing A New Group
  • Help And The Show Me Feature
  • The Access 2000 Help System
  • Help's Contents And Index
  • The Help Answer Wizard
  • Helps Index Feature
  • The What's This Utility
  • The Office Assistant
  • Changing the Office Assistant
  • Conclusion