Access Introduction
Two Day Course

Course Overview

This course is designed to give the delegate a good working knowledge of Access so that the delegate can create and edit Access databases

Delegates Requirements

It is essential that the delegate has completed a Windows Introduction course, or has gained similar knowledge within the work environment.

Who Should Attend

Anyone who is responsible for creating or maintaining an existing Access database management system or needs to search and find information and prepare reports and lists.

Course Outline

Database Design

Relationships

Designing Databases

Relational Database Theory

Database Objects and Container

Microsoft Access

File Menu

Icon Bar

Database Window

Status Bar

Creating Tables

Field Properties

Data Types

Views

Data Entry

Creating Key Fields

Forms

Using Form Wizards

Auto Forms

Form Properties

Queries

Different Query Types

Queries Select and Action Queries

Setting Criteria

Update Queries

Multi-table Queries

Adding a Calculated Field to a Query

Reports

Wizards

Using Report Wizards

Designing Reports

Sorting and Grouping Data in Reports

Using the Expression Builder

Automatic Summary Reports

Adding Controls to a Report

Using Field Properties for Protection

Required

Default Value

Input Mask

Validation Rule and Validation Text

Lookups  

TO BOOK A COURSE
Telephone 01794 521449