Access 2000 Foundation

Core Topics

Database Concepts

· What Is Data?

· What Is A Database?

· Basic Concepts

· The Telephone Directory - An Example Of A Database

· Tables And Relationships

· Types Of Relationships

· Why Use An Electronic Database?

· Why Use Access?

· An Introduction To Access

· Introducing Access Tools

· Using Access As Part Of Microsoft Office Professional

· Starting Microsoft Access

· The Access Application Window

Terminology and Usage

· Opening A Database

· The Access Database Window

· Closing A Database

· Opening A Table

· The Table Window

· Exploring The Table

· Table Design View

· Introducing Queries

· Introducing Forms

· Types Of Form

· Opening An Existing Form

· Form Design View

· Introducing Reports

Database Design

· Design And Document Your Database

· Questions To Ask Yourself

· Define Your Needs

· Basic Design Rules

· Determine Relationships

· Creating A Database

· Using The Table Wizard

· Adding Fields Using The Table Wizard

· Creating A Table Without A Wizard

· Adding Fields To A New Table

· Field Properties

· The Input Mask Property

· Setting A Primary Key

· Saving A Table

· Adding Records To A Table Datasheet

Formatting a Table

· Editing Records

· Selecting Records With The Mouse

· Selecting Records Using The Keyboard

· Selecting Fields With The Mouse

· Selecting Columns Using The Mouse

· Selecting Fields And Columns Using The Keyboard

· Deleting Records And Fields

· Viewing Or Setting Datasheet Default Values

· Re-Ordering Columns Within A Table

· Re-Ordering Fields In The Table

· Changing Column Width And Row Height

· Hiding And Un-Hiding Columns

· Freezing Columns

· Formatting Datasheet Cells

· Changing Datasheet Fonts

· Copying And Moving Fields And Records

· Another Look At The Database Window

· Printing