Access Intermediate
One-Day Course

Course Overview

This course is designed to give the delegate a good working knowledge of Access building on the skills learnt on the Introduction Course. At the end of the course the delegate will have a greater knowledge to design and run reports, queries and forms using the Access software.

Delegates Requirements

It is essential that the delegate has completed a Windows introductory course, and has attended an Access Introductory Course, or has gained similar knowledge within the work environment.

Who Should Attend

Anyone who is responsible for maintaining an existing Access database management system or needs to search and find information and assist in the design of reports and has either attended an Introduction course but requires a greater working knowledge to design and use their Access database.

Course Outline

Database Design

What is a Relational Database

Primary and Foreign Keys

Relationships

Using Field Properties for Protection

Required

Default Value

Input Mask

Validation Rule and Validation Text

Lookups

Table Relationships

What Is a Relationship

Relationship Types

Creating and Editing Relationships

Using Lookups for Referential Integrity

Multi-table Datasheet View

Forms

What is a Form

Form Sections

Form Controls

Form Control Layout

Using form Controls

Control Properties

Control Wizards

Multiple Table Forms

Reports

Using Report Wizards as the Basis for

Reports

Report Sections

Report Controls

Report Control Layout

Using Specific Controls

Publishing Datasheet Views on the Internet

Adding Hyperlinks to Datasheet Views

Adding Hyperlinks to HTML Pages

Queries

Multi-table Queries

Calculated Fields

Adding a Calculated Field to a Query

The Expression Builder

Calculating Summary Information

Crosstab Queries

General Query Properties

Checking Referential Integrity

Access Forms

Importing from Other Data Sources

Importing Data Using Drag-and-Drop

Backing Up and Restoring a Database

Compacting and Repairing a Database

TO BOOK A COURSE
Telephone 01794 521449