02 4967 5631

0416 056 759


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