Table of Contents:

• Introduction  


• Access Overview
  
  
  
  • Opening Access
  
  
  • Using a Template
  
  
  • Viewing the Quick Access Toolbar
  
  
  • Working with the Navigation Pane
  
  
  • Viewing the Status Bar
  
  
  
  


• Opening an Existing Database
  
  
  
  • Viewing the Start-Up Form
  
  
  • Understanding Tables
  
  
  • Explaining the ID Field
  
  
  • Using the Quick-Search
  
  
  • Using the Field AutoFilter
  
  
  • Changing the Table Layout
  
  
  
  


• Creating a Table in Datasheet View
  
  
  
  • Using the 'Add New Field' feature
  
  
  • Reviewing the Data Types
  
  
  • Using a Lookup Column
  
  
  • Saving your Table
  
  
  • Deleting a Field
  
  
  
  


• Creating a Table in Design View
  
  
  
  • Using the Design View
  
  
  • Viewing all Data Types
  
  
  • Understanding the Field Properties
  
  
  • Using an Input Mask
  
  
  • Understanding Indexes
  
  
  
  


• Using Find and Replace
  
  
  
  • Using Access Wildcards
  
  
  • Replacing Data
  
  
  • Deleting a Record
  
  
  • Hiding and Showing Fields
  
  
  • Freezing and Unfreezing Columns
  
  
  • Setting the Row Height
  
  
  
  


• Working with Queries
  
  
  
  • Introducing the Select Query
  
  
  • Using the Query Wizard to Create a New Query
  
  
  • Understanding the Resulting Dataset
  
  
  • Working with the Query Tools, Design Ribbon for Query
  
  
  • Working in the Query Table View and QBE Grid
  
  
  • Adding Criteria
  
  
  • Creating a Query from Scratch
  
  
  • Using Criteria for your Queries
  
  
  
  


• Working with Forms
  
  
  
  • Introducing the Form
  
  
  • Understand the different types of Forms
  
  
  • Using the Form Wizard
  
  
  • Working in the Form Design View
  
  
  • Understanding Form Controls
  
  
  • Understanding Properties
  
  
  • Understanding the Dialog Box and the Pop-up Form
  
  
  • Changing Properties for a Text Box
  
  
  • Modifying the Order of Controls
  
  
  
  


• Working with Simple Reports
  
  
  
  • Creating Labels
  
  
  • Using the Report Wizard
  
  
  • Using Layout View
  
  
  • Using Design View
  
  
  • Understanding the Report Header and Footer
  
  
  • Grouping and Sorting your Reports
  
  
  • Creating a Report From a Query
  
  
  • Summary