Access 2000:
Intermediate

Topic-Level Outline

Days: 1

Prerequisites: Access 2000: 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 table 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: Working with orphan records

Topic B: 0 Modifying Lookup fields

B-1: Modifying Lookup field properties

B-2: Changing a text box 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 form

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 FieldSize 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: Designing an outer join

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

A-5: Designing 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 single field index

D-2: Creating a multiple field index

Unit 6 : Enhancing forms

Topic A: 0 Adding graphics

A-1: Adding a graphic to the 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: Enhancing the display of data by using a conditional format

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

A-5: Adding controls to a group footer

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 a 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

Topic B: 0 Creating charts in reports

B-1: Adding a chart to a report

B-2: Modifying a chart

Appendix A : Database administration

Topic A: 0 Compacting and repairing databases

Topic B: 0 Backing up and restoring databases