Access 2000 Intermediate

Database Design

·       What is a Relational Database?

·       Primary and Foreign Keys

·       Relationships

Using Field Properties for Protection

·       Required

·       Default Value

·       Input Mask

·       Validation Rule and Validation Text

·       Lookups

Table Relationships

·       What is a Relationship?

·       Relationship Types

·       Creating and Editing Relationships

·       Using Lookups for Referential Integrity

·       Multi-table Datasheet View

Queries

·       Multi-table Queries; Calculated Fields

·       Adding a Calculated Field to a Query

·       The Expression Builder

·       Calculating Summary Information

·       Crosstab Queries; General Query Properties

·       Checking Referential Integrity

Forms

·       What is a Form?

·       Form Sections

·       Form Controls

·       Form Control Layout

·       Using Form Controls

·       Control Properties

·       Control Wizards

·       Multiple Table Forms

Reports

·       Using Report Wizards as the Basis for Reports

·       Report Sections

·       Report Controls

·       Report Control Layout

·       Using Specific Controls

·       Publishing Datasheet Views on the Internet

·       Adding Hyperlinks to Datasheet Views

·       Adding Hyperlinks to HTML Pages

Access Tools

·       Importing from Other Data Sources

·       Importing Data Using Drag-and-Drop

·       Backing Up and Restoring a Database

·       Compacting and Repairing a Database  

• Introduction

• Intermediate

• Advanced

Excel 2000

• Introduction

• Intermediate

• Advanced

Word 2000

• Introduction

• Intermediate

• Advanced

PowerPoint 2000

• Introduction

• Intermediate

Windows

• 2000 Foundation

• 2000 Intermediate

• 98 - Foundation

• 98 - Intermediate

• 98 - Update

Miscellaneous

• Project

• Publisher

• FrontPage

• Outlook

Office 97

• List of office 97 Courses