Click Here For Our Featured Training Course

Microsoft Access Level 3 

Duration

2 days

Overview

This course teaches advanced facilities and functions available in Access.

Prerequisites

Familiarity with a keyboard and with using a mouse is essential. 

You should have attended courses Access 2000 Introduction  (CTAC20-10) and Access 2000 Intermediate  (CTAC20-20) or have similar knowledge and experience. 

Outline

·          examine and create key fields and indexes

·          edit relationships and joins

·          create and use hyperlinks

·          use expression builder to create complex expressions

·          build criteria expressions

·          create and use crosstab queries

·          adjust detail level

·          work with advanced forms

·          define option and toggle buttons

·          define unbound controls

·          add custom control tips

·          create option groups

·          use combo boxes

·          change tab order

·          build advanced reports

·          change sorting and grouping

·          create calculated controls

·          create and use macros and macro groups

·          add macro command buttons

·          define macro conditions

·          format command buttons

·          define and plan Switchboards

·          create a Switchboard form

·          set the Main Switchboard

·          Startup options

·          Securing a database