Pagoda Training Ltd
Helping clients deliver effective IT training projects
Microsoft Access 2003 Advanced - Course outline
Duration One Day
Objectives To enable delegates to administer and automate the operation of their database and apply security for multi-user applications.
Who should attend People who intend to design databases at an advanced level or improve existing Access databases. Also those who wish to convert databases created in other applications. Sharing and security is also covered.
Experience needed Delegates should have attended an intermediate Access course, or gained the relevant experience through working with Access.

Introduction to macros
Form and report Navigation
Creating a switchboard
Assigning macros to toolbars

Macro names
Macro conditions

Creating a dialogue box
Assigning macros to control properties

Optimising and administering access
Optimising performance
The Performance Analyzer
Compacting your database
The Database Documentor
The Database Splitter
Recovering damaged databases
Importing and linking tables

PivotTables and PivotCharts
Data access pages (off-line)

Securing a database
Adding a database password
Setting user level security
Activating the log-on procedure
Creating and managing security accounts
Creating a security group account
The Security Wizard
Changing ownership
Assigning and removing permissions
Encrypting and decrypting a database

  Back to top