MICROSOFT ACCESS (XP)
Beginner Intermediate Advanced
 
  • Database Concepts
  • Access Basics (Screen, Menu, Help)
  • Using the Office Assistant
  • Opening/Saving/Closing a File
  • Viewing a Table
  • Editing a Table
  • AutoCorrect and Spell Checking
  • Form vs Table View
  • Viewing Multiple Tables
  • Changing a Table Image
  • Sorting
  • Printing a View
  • Page Setup and Printing
  • Creating and Restructuring a Table
  • Filtering and Finding Data
  • Creating Reports

 

 
  • Importing External Data
  • Importing Spreadsheets
  • Creating a Primary Key
  • Converting Field Types
  • Changing Field Sizes
  • Custom Display Formats
  • Input Masks
  • Assigning Captions
  • Setting Default values
  • Using the Expression Builder
  • Creating Validity Rules & Text
  • Creating Queries
  • Saving/Opening Queries
  • Using Wildcards
  • Compound Queries
  • Creating calculated Fields
  • Using Summary Operators
  • Querying Multiple Tables
  • Action Queries
  • Creating Custom Reports
  • Saving/Opening Reports
  • Creating Custom Forms
  • Saving/Opening Forms
  • File Management
  • Database Properties
 
  • Creating Indexes
  • Parameter Queries
  • Crosstab Queries
  • Customizing Forms
  • Customizing Reports
  • Converting Databases
  • Compacting/Repairing a Database
  • Linked Table Manager
  • Splitting a Database
  • Switchboard Manager
  • Startup Options
  • Upsizing Wizard
  • Password Protection
  • User-Level Security
  • Adding/Editing Users/Groups
  • Encrypting/Decrypting Databases
  • Introduction to Macros
  • Customizing Access Defaults
  • Customizing/Creating Toolbars
  • The Add-in Manager