Microsoft Courses > Microsoft Access 2000 Level 2 Training Course

Access 2000: Level 2 is a hands-on course that will help you enhance your database designs by using the principles of data normalization and table relationships, querying multiple tables for data used in customized forms and reports, and using data access pages.

Delegates attending this course should have previously attended the PTR Access 2000: Level 1 course or have equivalent knowledge

What’s Next: Access 2000: Level 2 is the second course in this series. Access 2000: Advanced, the next course in this series, teaches delegates how to use a variety of query techniques, and how to create more efficient forms and reports, and macros. After taking the Advanced course, students who want to learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic for Applications code can take Access 2000: Introduction to Application Development.

Topics covered on the 2 day Microsoft Access 2000 Level 2 course

Principles of Table Design

Normalizing Data

Normalizing Data for Fourth and Fifth Normal Forms

Principles of Table Relationships

Analyzing Table Relationships

Establishing and Testing Referential Integrity

Table Design Techniques

Data Validation Techniques

Indexing Techniques

Designing Select Queries

Using Calculated Fields in Queries

Creating Multiple-table Queries

Customizing Form Designs

Customizing the Form Design

Performing Calculations on a Form

Adding Combo Boxes to a Form

Adding Unbound Controls

Working with Data Access Pages

Creating Data Access Pages

Integrating with Other Applications

Customizing Reports

Customizing a Report Created by the Report Wizard

Working with Subreports

Creating a Report in Design View

   (excl.VAT)