Access 2002:
Advanced

Topic-Level Outline

Days: 1

Prerequisites: Access 2002: Intermediate or equivalent experience

Unit 1 : PivotTables and PivotCharts

Topic A: 0 Creating PivotTables

A-1: Examining PivotTable view

A-2: Adding fields to a PivotTable

Topic B: 0 Modifying PivotTables

B-1: Creating totals

B-2: Moving fields in a PivotTable

B-3: Showing and hiding detail in a PivotTable

B-4: Formatting fields

Topic C: 0 Working with PivotCharts

C-1: Creating a PivotChart

Unit 2 : Creating advanced forms

Topic A: 0 Building a form based on joined tables

A-1: Creating a form to display data from two tables

A-2: Modifying a query to display all fields on a form

Topic B: 0 Automating data entry

B-1: Using the Date function

B-2: Using the DateAdd function

Topic C: 0 Using grouped controls

C-1: Creating and using grouped controls

C-2: Adding an option group control to a form

C-3: Modifying the option group control

Topic D: 0 Improving the user interface

D-1: Adding a tab control to a form

D-2: Setting form properties to prevent all modifications

D-3: Creating a Startup form

D-4: Creating a Switchboard form

Topic E: 0 Creating Subforms

E-1: Examining and using a subform

E-2: Creating a subform

Unit 3 : Creating macros

Topic A: 0 Creating and running macros

A-1: Examining and running a macro

A-2: Creating and running a macro to open a table

A-3: Modifying a macro to add an action

Topic B: 0 Attaching macros to events of database objects

B-1: Attaching a macro to the open event of a form

B-2: Attaching a macro to a command button

B-3: Using a macro to resize and move a form’s window

Unit 4 : Creating advanced macros

Topic A: 0 Creating macros to provide user interaction

A-1: Creating a data validation macro

A-2: Creating a data-entry macro

Topic B: 0 Creating macros that require user decision

B-1: Creating a user-decision macro

Topic C: 0 Using AutoKeys and AutoExec macros

C-1: Creating an AutoKeys macro

C-2: Creating an AutoExec macro

Unit 5 : Exploring Access SQL

Topic A: 0 Identify different clauses in an SQL statement

A-1: Discussing Structured Query Language

A-2: Examining an SQL statement in Access

Topic B: 0 Writing SQL statements

B-1: Writing an SQL SELECT statement

B-2: Using the WHERE clause

B-3: Creating a query to display matching data from related tables

B-4: Using an SQL statement to find unmatched records

Topic C: 0 Attaching an SQL statement to database objects

C-1: Assigning an SQL statement to a command button

Unit 6 : Internet integration

Topic A: 0 Working with hyperlink fields

A-1: Creating a hyperlink field

A-2: Using a hyperlink field to enter data

A-3: Modifying data in a hyperlink field

Topic B: 0 Working with data access pages

B-1: Creating and using a data access page

B-2: Creating a grouped data access page based on multiple tables

B-3: Saving database objects as data access pages

B-4: Creating a PivotTable and a PivotChart on a data access page

Unit 7 : Managing databases

Topic A: 0 Working with database utilities to optimize resources

A-1: Converting a database to a prior version

A-2: Analyzing performance

A-3: Splitting a database

A-4: Protecting a split database from modification

A-5: Compacting and repairing a database

Topic B: 0 Securing data by database replication

B-1: Replicating a database

B-2: Synchronizing replicated databases

Topic C: 0 Encrypting and decrypting databases

C-1: Encrypting a database

C-2: Decrypting a database

Unit 8 : Security fundamentals

Topic A: 0 Protecting databases

A-1: Assigning a password to a database

A-2: Removing a password

Topic B: 0 User-level security

B-1: Providing security by using Security Wizard

B-2: Creating a new user group

B-3: Specifying permissions on database objects

Appendix A : Discussing modules and MDE files

Topic A: 0 Understanding modules

A-1: Discussing modules and VBA

Topic B: 0 Understanding MDE files

B-1: Discussing MDE files

Appendix B : MOUS exam objectives map

Topic A: 0 Core exam objectives

Topic B: 0 Expert exam objectives