Access XP 2002 Advanced

Core Topics

Structured Query Language

· Writing SQL Commands

· Writing SQL Queries

· Writing SQL Sub queries

· Writing SQL Joins

· Inserting Data

· Updating Data

· Deleting Data

· Writing SQL Queries In Access 2002

Working With Macros

· Automating Tasks

· Introducing The Macro Window 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

· Using Macros Versus Visual Basic

· Understanding Visual Basic Concepts

· Using The Visual Basic Editor Window

· Getting Help With Visual Basic

Using Data Access Pages

· Creating Data Access Pages

· Modifying Data Access Pages

· Sorting Data In Data Access Pages

· Summarizing Data In Data Access Pages

· Editing Data In Data Access Pages

· Protecting Data In Data Access Pages

Converting Access Databases

· Converting Databases To Access 2002

· Converting From Access 2002 To Access 97

· Converting From Access 2002 To Access 2000

Customising Access 2002

· Configuring Access 2002 Options

· Configuring Autocorrect Options

· Customizing Menus And Toolbars

Analysing Access Databases

· Optimizing Databases With Table Analyzer

· Optimizing Databases With Performance Analyzer

· Documenting Databases With Documenter Analyzer