Afiniti

Access XP 2002 Advanced

Afiniti
In London

Price on request
Prefer to call the centre directly?
02073... More

Important information

Typology Course
Location London
Duration 2 Days
  • Course
  • London
  • Duration:
    2 Days
Description

The aim of this course is to increase delegates understanding of the advanced features available in Microsoft Access 2002. By the end of the course delegates will be able use structured querying language, automate procedures using macros, customise databases and understand the basic concepts of VBA.
Suitable for: current users of Microsoft Access

Facilities (1)
Where and when
Starts Location
On request
London
Lower Ground Floor Russell Square House 10 - 12 Russell Square, WC1B 5EH, London, England
See map
Starts On request
Location
London
Lower Ground Floor Russell Square House 10 - 12 Russell Square, WC1B 5EH, London, England
See map

Frequent Asked Questions

· Requirements

Delegates must have good knowledge of Access and experience of creating databases through either attending the Access Intermediate Course or experience in the workplace.

Course programme

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


Students that were interested in this course also looked at...
See all