All our training courses can be designed to suit your company's needs. Take a look at all the different features that separate us from other XP Access 2002 Intermediate training courses.

Objectives - Delegates will acquire the necessary skills to becomeproductive in the chosen package at the desired level.

Duration: 1 day

Advanced Forms and Reports Topic A: Using Properties Topic B: Sub Forms and Sub Reports Topic C: Calculated Fields in Forms and Reports Topic D: Tabbed Forms Topic E: Graphics in Forms and Reports Topic F: Programming with Command Buttons Topic G: Using Active-X Controls   Queries Topic A: What are Queries? Topic B: Query Types Topic C: Designing a simple Select query using the QBE grid Topic D: Calculated Fields Topic E: View Totals and Subtotalling Topic F: Parameter Queries Topic G: Setting Parameters Topic H: Running the Query Topic I: Conditional Branching -the IF function Topic J: Action Queries Topic K: Make Table Query Topic L: Update, Append and Delete Queries Topic M: Programming

Database Maintenance Topic A: Compacting and Repairing a Database Topic B: Backing Up Topic C: Upsizing to a MS SQL Server Database Topic D: Analysing the Database   Database Security Topic A: Password Protecting the Database Topic B: Removing a Password Topic C: Encryption Topic D: Setting User-Level Security with the Wizard   User and Group Accounts Topic A: Predefined Accounts   Permission Topic A: What are Permissions Topic B: Assigning Permissions   Access and MS Office   Access and the Web