Microsoft Access 2000 - 2003 Level 2 - Advanced Database Design

Microsoft Access 2000 - 2003 Level 2
Advanced Database Design

Course ID: D1N2
Duration: 1 day

Prerequisites

Access 2000 - 2003 Level 1 - Database Design

Course Objectives

After completing the course, participants will be able to:

Overview of the databases that will be used during the course
Enhance tables by creating lookups
Create various types of advanced queries
Create advanced forms by adding controls, subforms, calculations, and graphic images
Create relationships between tables to ensure data accuracy and to deploy referential integrity
Work with and create web-based objects

Course Content

Database Overview
Database Overview

Enhancing Tables
Copying a Database Object ; Lookup Fields ; Creating a Lookup

Advanced Queries
Query Overview ; The Query Wizard ; Nested Queries ; Query Joins ; Make Table Queries ; Append Queries ; Summary Queries ; Crosstab Queries

Advanced Forms
Form Design ; Controls ; Form Properties ; Subforms ; Advanced Calculations ; Customizing Forms

Advanced Reports
Designing Reports ; Sorting and Grouping ; Layout Properties ; Calculations ; Subreports ; Graphic Reports ; Chart Wizard

Supplemental Topics: Working with Web Tools
Working with Web Pages ; Data Access Pages ; Hyperlinks

More Information

For more information, contact us by phone or send us an e-mail.

Toll Free: (866) 926-5671

Halifax • Montreal • Ottawa • Toronto • Winnipeg
Regina • Saskatoon • Calgary • Edmonton • Vancouver