5 Microsoft Access Introduction 2007 Courses 2 Day Training Course

£ 370.00 

Two-Day Course



Course Outline

Access Overview

Database Overview

Database Wizards

Flat File Databases

Relational Databases

Planning a simple Database

Database Naming Conventions


Database Views

Datasheet View

Design View

Adding Records

Modifying Data

Deleting Records

Finding Data

Filtering Records

Sorting Records


Tables

Table Creation

Fieldnames

Field Properties

Primary Keys

Table Relationships

Import External Data


Queries

Select Queries

Sort Options

Criteria

Wildcards

Concatenation

Between….And Function

Groups & Totals

Parameter Query


Forms

Form Wizard

Form Design

Modifying Form Objects

Data Entry

Tab Order


Reports

Report Wizard

Report Design

Page Breaks

Title Front Pages


Multi-Table Environment

Multi-table Queries

Multi-table Forms

Multi-table Reports