Microsoft Access 2003 Advanced

Prerequisites

Delegates must have working knowledge of the previous course material.

Structured Query Language In Access 2003

• Writing SQL Commands

• Writing SQL Queries

• Writing SQL Subqueries

• Writing SQL Joins

• Inserting Data

• Updating Data

• Deleting Data

• Writing SQL Queries In Access 2003

Working With Macros In Access 2003

• Automating Tasks

• Introducing The Macro Design Toolbar

• Creating Macros

• Testing And Debugging Macros

• Modifying Macros

• Conditional Programming In Macros

• Adding Macros To Forms

• Adding Macros To Reports

• Filtering Data

• Documenting Macros

Using Visual Basic In Access 2003

• Using Macros Versus Visual Basic

• Understanding Visual Basic Concepts

• Using The Visual Basic Editor Window

• Getting Help With Visual Basic

Using Data Access Pages In Access 2003

• Creating Data Access Pages

• Modifying Data Access Pages

• Sorting Data In Data Access Pages

• Summarising Data In Data Access Pages

• Editing Data In Data Access Pages

• Protecting Data In Data Access Pages

Converting Access Databases In Access 2003

• Converting Databases To Access 2003

• Converting From Access 2003 To Access 97

• Converting From Access 2003 To Access 2000

Customising Access 2003

• Configuring Access 2003 Options

• Configuring Autocorrect Options

• Customising Menus And Toolbars

Managing And Maintaining Databases In Access 2003

• Optimising Databases With Table Analyzer

• Optimising Databases With Performance Analyzer

• Documenting Databases With Documenter Analyzer

• Avoiding Errors with The Object Dependencies Task