Access 2002:
Intermediate

Topic-Level Outline

Days: 1

Prerequisites: Access 2001: Basic or equivalent experience

Unit 1 : Creating relational databases

Topic A: 0 Database normalization

A-1: Determining first normal form

A-2: Determining second normal form

A-3: Determining third normal form

Topic B: 0 Relating tables

B-1: Establishing a one-to-one table relationship

B-2: Establishing a one-to-many table relationship

B-3: Establishing a many-to-many relationship

Topic C: 0 Implementing referential integrity

C-1: Planning table relationships

C-2: Working with orphan records

C-3: Setting cascading deletes

C-4: Testing cascading deletes

C-5: Setting cascading updates

C-6: Testing cascading updates

Unit 2 : Working with related tables

Topic A: 0 Using the Lookup Wizard

A-1: Examining table relationships

A-2: Creating a Lookup list field

Topic B: 0 Modifying Lookup fields

B-1: Modifying Lookup field properties

B-2: Changing a text box control to another type of control

Topic C: 0 Adding data to related tables

C-1: Adding data to related tables

Unit 3 : Defining data entry rules

Topic A: 0 Working with input masks

A-1: Creating an input mask to control how data is entered in a field

A-2: Creating an input mask for a combo box in a form

A-3: Working with the Input Mask Wizard

Topic B: 0 Setting properties

B-1: Setting the Required property for a field

B-2: Using the AllowZeroLength property for a field

B-3: Setting the Field Size property to limit field length

Topic C: 0 Setting validation rules

C-1: Establishing default values

C-2: Creating validation rules

C-3: Setting validation text

Unit 4 : Using advanced query features

Topic A: 0 Joining tables in queries

A-1: Using a query to join tables

A-2: Creating a join in Design view

A-3: Creating an outer join

A-4: Creating a join by using an intermediate table

A-5: Creating a self-join query

Topic B: 0 Creating calculated fields

B-1: Creating a calculated field

B-2: Modifying the format of a displayed value

B-3: Using the Expression Builder

Topic C: 0 Using action queries

C-1: Copying a table object

C-2: Using an append query to add a record to a table

C-3: Deleting records with a delete query

C-4: Modifying records with an update query

C-5: Creating a make-table query

Unit 5 : Creating advanced queries

Topic A: 0 Summarizing and grouping values

A-1: Creating a query to display summary values

A-2: Concatenating values

A-3: Finding records that do not match between tables

Topic B: 0 Creating crosstab queries

B-1: Viewing a crosstab query

B-2: Creating a crosstab query with the Crosstab Query Wizard

Topic C: 0 Using parameter queries

C-1: Creating a single-criterion parameter query

C-2: Creating a query with multiple parameters

C-3: Using a wildcard in a parameter query

Topic D: 0 Using indexes

D-1: Creating a single-field index

D-2: Creating a multiple-field index

Unit 6 : Creating advanced form design

Topic A: 0 Adding graphics

A-1: Adding a graphic to a form

A-2: Embedding a graphic in an unbound object frame

Topic B: 0 Adding calculations

B-1: Binding a control to a calculated field

B-2: Creating a calculated control

B-3: Aligning objects

Topic C: 0 Adding combo boxes

C-1: Adding a combo box to a form

C-2: Modifying the properties of a combo box

Topic D: 0 Adding unbound controls

D-1: Adding an unbound control to a form

D-2: Drawing a rectangle around a control

D-3: Changing tab order

Unit 7 : Using advanced report features

Topic A: 0 Creating customized headers and footers

A-1: Adding a report header

A-2: Adding a report footer

A-3: Applying conditional formatting

A-4: Keeping parts of the report on the same page

A-5: Adding controls to group footers

A-6: Forcing a new page

A-7: Working with the HideDuplicates property

Topic B: 0 Adding calculated values

B-1: Working with the DateDiff function

B-2: Using the IIF function

Topic C: 0 Working with subreports

C-1: Embedding the subreport

C-2: Viewing and troubleshooting report results

Unit 8 : Creating charts

Topic A: 0 Creating charts in forms

A-1: Creating a chart in a form

A-2: Enhancing a chart in a form

Topic B: 0 Creating charts in reports

B-1: Adding a chart to a report

B-2: Modifying a chart in a report

Appendix A : Working with data access pages

Topic A: 0 Creating a data access page

A-1: Creating a data access page by using the Page Wizard

Appendix B : MOUS exam objectives map

Topic A: 0 Core exam objectives

Topic B: 0 Expert exam objectives