MicroKnowledgeAccess XP Advanced

MicroKnowledge Inc.

Contact | Driving Directions | Home

Access XP Advanced

Create PivotTables and PivotCharts, improve form interfaces and automate data entry, use macros, explore Access SQL.

Recommended Preparation: Access 2000/XP Intermediate or equivalent knowledge

Register for a class
Personalized training and consulting is available upon request.

Lesson 1: PivotTables and PivotCharts

Creating PivotTables
Modifying PivotTables
Working with PivotCharts

Lesson 2: Creating Advanced Forms

Building a form based on joined tables
Automating data entry
Using grouped control
Improving the user interface
Creating sub-forms

Lesson 3: Creating Macros

Creating and running macros
Attaching macros to events of database objects

Lesson 4: Creating Advanced Macros

Creating macros to provide user interaction
Creating macros that require user decision
Using AutoKeys and AutoExec macros

Lesson 5: Exploring Access SQL

Identify different clauses in an SQL statement
Writing SQL statements
Attaching an SQL statement to database objects

Discussion: Security fundamentals

Protecting databases
User-level security

Optional Topic: Internet integration

Working with hyperlink fields
Working with data access pages

Optional Topic: Managing Databases

Working with database utilities to optimize resources
Securing data by database replication
Encrypting and decrypting databases

Dates:
Please contact us for training options.

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile