A TOUR OF ACCESS

  • Microsoft Access Interface
  • Starting Access
  • The Backstage View
  • Opening An Existing Database File
  • Understanding The Access Screen
  • Working With The Navigation Pane
  • Working With Database Objects

DESIGNING A LOOKUP DATABASE

  • How Access Stores Data
  • Access Data Types
  • Identifying Table Problems
  • Refining Table Structures
  • Finalising The Design
  • Creating A Lookup Database
  • Creating A New Database File
  • Creating The Lookup Table
  • Defining The Primary Key
  • Relationships
  • Connecting To A Lookup Table
  • Viewing Table Relationships

MODIFYING TABLE STRUCTURES

  • Adding Fields To An Existing Table
  • Understanding Field Properties
  • Changing Field Size
  • Changing Field Names
  • Changing Decimal Places
  • Changing Date Formats
  • Indexing Fields
  • Deleting Fields From A Table

FORMS

  • Creating A Basic Form
  • Creating A Split Form
  • Binding A Form To A Query
  • Using The Form Wizard
  • Working With Existing Forms
  • Adding / Editing Records In A Form
  • Deleting Records Through A Form
  • Deleting An Unwanted Form

WORKING WITH RECORDS

  • Navigating To A Specific Record
  • Editing A Record
  • Deleting Record Data
  • Undoing A Change
  • Deleting A Record
  • Deleting Several Records
  • Searching In A Table
  • Searching In A Field
  • Finding And Replacing
  • Printing Records From A Table
  • Compacting A Database

SORTING AND FILTERING

  • Simple Sorting
  • Sorting On Several Fields
  • Simple Filtering
  • Working With Filters
  • Filtering Between Dates

QUERIES

  • Understanding Queries
  • Creating A Query Design
  • Working With A Query
  •  Changing A Query Design
  • Applying Record Criteria
  • Clearing Selection Criteria
  • Saving A Query
  • Running Queries From The Navigation Pane
  • Deleting A Query
  • Creating Queries

REPORTS

  • Reporting In Access
  • Creating A Basic Report
  • Working With Existing Reports
  • Previewing And Printing A Report
  • Changing The Report Layout
  • Using The Report Wizard
  • Creating A Grouped Report
  •  Creating A Statistical Report


ACCESS INTRODUCTORY