Access Advanced
One Day Course

Course Overview

This course is designed to give delegates a greater understanding of the advanced features in Access to enable them to produce more complex databases and administer these.

Delegates Requirements

A working knowledge of the Access interface, table creation, basic query and report writing functions gained from prior attendance on an Access Introduction Course and consolidation of experience is required

Who Should Attend

Experienced users of Access who have to administer or create complex Access databases

Course Outline

Database Design

Theory of Normal Forms

De-normalisation

Naming Conventions

Access  Performance Issues

Indexes

Data Validation

Table Level Validation

Relationships and Referential Integrity

Relationships

Field Types

Referential Integrity Options

Join Types

Using Lookups for Referential Integrity

Multi-Table Datasheet View

Access and the Internet

Using Hyperlinks

Using Hyperlinks in Forms

Exporting Datasheet Views to HTML

Data Access Pages

Advanced Form Design

Using Advanced Forms Features

The Form Worksurface

Creating a Calculated Control

Adding a Graphic to a Form

Multi-Table Forms

Using the Subform Control

Switchboard Forms

Action Queries

What is an Action Query

Planning an Action Query

Make Table Queries

Append Queries

Delete Queries

Update Queries

Advanced Report Design

Applying Sorting and Grouping to Reports

Performing Calculations on Reports

Adding a Graphic to a Report

Using the Subreport Control

Modifying Section Properties

Using the Chart Wizard

Creating Macros

What is a macro

Creating a macro

Running a Macro

Using Macros with Events

Grouped Macros

Using the Macro Builder

Attaching Macros to Controls

Form Events

Send Keys

Conditional Macros

TO BOOK A COURSE
Telephone 01794 521449