Access Introduction 2007
Two Day Course

Course Overview

This course is designed to give delegates a good working knowledge of Access 2007 with its new interface and features so they 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

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

Course Outline

New Features in 2007

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

Sharing Information and Collaboration

New Security Features

Proofing Tools

Database Design

Relationships

Designing Databases

Relational Database Theory

Object Creation

Microsoft Access

File Menu

Layout View

Database Window

Results Orientated User Interface

Contextual Tabs

Quick Access Tool Bar

Using Galleries

Creating Tables

Field and Table Templates

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

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