Access 2000 - Advanced

Access 2000

  

Database Design

·       Theory of Normal Forms

·       De-normalisation

·       Naming Conventions

 

Access 2000 Performance Issues

·       Indexes

·       Data Validation

·       Table Level Validation

·       Relationships and Referential Integrity

·       Relationships

·       Field Types

·       Referential Integrity Options

·       Join Types

·       Using Lookups for Referential Integrity

·       Multi-Table Datasheet View

 

Building and Modifying Forms

·       Using Advanced Forms Features

·       The Form Worksurface

·       Creating a Calculated Control

·       Adding a Graphic to a Form

·       Multi-Table Forms

·       Using the Subform Control

·       Switchboard Forms

 

Access and the Internet

·       Using Hyperlinks

·       Using Hyperlinks in Forms

·       Exporting Datasheet Views to HTML

·       Data Access Pages

 

Advanced Queries

·       Filtering Query Results

·       Parameter Queries

·       Creating Summary Queries

·       Formatting Query Output

·       Query Join Types

·       Self Joins and Aliases

·       Cross Joins

 

Action Queries

·       What is an Action Query?

·       Planning an Action Query

·       Make Table Queries

·       Append Queries

·       Delete Queries

·       Update Queries

 

Producing Reports

·       Applying Sorting and Grouping to Reports

·       Performing Calculations on Reports

·       Adding a Graphic to a Report

·       Using the Subreport Control

·       Modifying Section Properties

·       Using the Chart Wizard

 

 

Excel 2000

Word 2000

PowerPoint 2000

Windows

Miscellaneous

Office 97