Pagoda Training Ltd - Course Outline

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.

Content	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 Workgroups 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

Pagoda Training Ltd, 2nd Floor, Thornborough Hall, Leyburn, North Yorkshire, DL8 5AB
Tel 01969 625596 Email training@pagoda.co.uk
Incorporated in England Registration No. 3132465