Irvine Training Company                               www.IrvineTrainingCo.com
Access 115

Access 115 - Work with MS Access Databases

1/2 day

This is the first in a series of half-day MS Access classes

The next class in this series is Access 125


click here to return
Topics may include:

An Overview of MS Access
   Relational Databases: Tables, Records, Fields, Values
   Examine the Microsoft Access Environment
   The Database Environment’s Naming Conventions
   View a List of Tables, Queries, Forms, and Reports in a Database

Work With Tables and Table Properties
    Navigate an Access Table in Datasheet View
    Field names, Data Types and Field Properties
    Examine the Field Properties of an Access Table in Design View

Manage Data
    The Microsoft Access Form
    Navigate in an Access Form
    Use a Form to Add Records
    Use a Form to Delete Records
    Sort Records in a Table
    Filter Sets of Records in a Table
    Display Sets of Records in a Table
    Update Records Individually
    Update Multiple Records Simultaneously
    Select and Run a Report

Establish Table Relationships
    Identify Primary and Foreign Keys in the Relationships Window
    View a Table’s Subdatasheets
    Create Table Relationships
    Remove Table Relationships

End


This is the first in a series of half-day MS Access classes.

The next class in this series is Access 125
Computer training in Orange County California