+

links

A one day course designed to get you right to the heart of Microsoft Access.

In this course, you will be introduced to the concept of the relational database and the Microsoft Access relational database application and its information management tools.

An Overview of Access

Relational Databases

The Access Environment

The Database Environment

Examine an Access Table

Managing Data

Examine an Access Form

Add and Delete Records

Sort Records

Display Record Sets

Update Records

Run a Report

Establishing Table Relationships

Identify Table Relationships

Identify Primary and Foreign Keys in the Relationships Window

Working with Subdatasheets

Querying the Database

The Select Query

Add Criteria to a Query

Add a Calculated Field to a Query

Perform a Calculation on a Record Grouping

Designing Forms

Form Design Guidelines

Create AutoForms

Create a Form Using the Form Wizard

Modify the Design of a Form

Producing Reports

Create an AutoReport

Create a Report by Using the Wizard

Examine a Report in Design View

Add a Calculated Field to a Report

Modify the Format Properties of a Control

AutoFormat a Report

Adjust the Width of a Report

Next Course

phone
028 4461 7701

£300.00 + VAT pp

One day course.

10.00am to 4.00pm

Refreshments and luncheon included.