Access 2000
Power User

Topic-Level Outline

Days: 1

Prerequisites: Access 2000: Application Development or equivalent experience

Unit 1 : Working with objects and collections

Topic A: 0 Using objects

A-1: Discussing objects

A-2: Modifying object properties by using Code window

A-3: Using object methods and events

A-4: Examining the Object Browser

A-5: Searching in the Object Browser

Topic B: 0 Using collections

B-1: Understanding collection objects

B-2: Using the Controls collection

Unit 2 : Working with ActiveX Data Objects

Topic A: 0 Getting started with ActiveX Data Objects (ADO)

A-1: Discussing ADO

A-2: Discussing ADO collections

Topic B: 0 Working with ActiveX Data Objects

B-1: Connecting to a database

B-2: Creating and opening a Recordset object

B-3: Navigating a recordset

B-4: Adding a record to a recordset

B-5: Modifying a record

B-6: Canceling changes to a record

B-7: Deleting a record

B-8: Creating a parameter query

Unit 3 : Working with ActiveX controls

Topic A: 0 Getting started with ActiveX controls

A-1: Discussing the ActiveX Windows Common Controls

Topic B: 0 Using ActiveX controls

B-1: Using the ActiveX ProgressBar Control

B-2: Using the StatusBar Control

Unit 4 : Working with VBA debugging tools

Topic A: 0 Errors in code

A-1: Discussing types of errors

Topic B: 0 Using debugging techniques

B-1: Discussing debugging tools

B-2: Setting a breakpoint

B-3: Adding a watch expression

B-4: Using Step Into

B-5: Deleting a watch expression

B-6: Working with the Immediate window

B-7: Using the Locals window

Topic C: 0 Handling runtime errors

C-1: Writing error-handling code

Unit 5 : Integrating Access with MS Office

Topic A: 0 Automating MS Office

A-1: Introducing automation

A-2: Setting references to object libraries

Topic B: 0 Working with Word from Access

B-1: Creating an Automation object

B-2: Opening a Word document from within Access

B-3: Creating a Word document from within Access

Topic C: 0 Working with Excel from Access

C-1: Opening a workbook from within Access

C-2: Creating a workbook from within Access