Access Advanced 2007
One Day Course

Course Overview

This course is designed to give delegates a greater understanding of the advanced features using the new interface and features in Access 2007 and to design and use macros.

Delegates Requirements

A good 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 through practical experience is essential

Who Should Attend

Experienced users of Access who have to administer or create complex Access databases in the 2007 version

Course Outline

Access 2007 New Features

New Layout View

Database Templates

Field and Table Templates

Improves Datasheet

Results Oriented User Interface

Contextual Command Tabs

Galleries

The Quick Access Toolbar

Object Creation Tools

New Data Types and Controls

The Field List Pane

Sorting and Filtering Tools

Proofing Tools

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