ECDL Syllabus 5.0 Module 5 using Databases using Access XP

Description

Learn how to design a database, create tables, and how to retrieve and manipulate data and present it in a report format. The manual comes with its own data files on the web that you use for practising the relevant exercises. Approved by the ECDL Foundation.

CONTENTS:

Understanding Database Principles

Using the Menus Toolbars and Task Pane

Help

Opening a Database

Closing Tables and Databases

Moving Around a Table

Planning and Creating a Database and Table

Defining Field Properties

Primary Key and Indexes

Creating Validation Rules

Previewing and Printing from Tables, Forms and Reports

Editing Data

Adding and Deleting Records

Sorting and Filtering Data

Creating Editing and Deleting Queries

Saving and Printing Queries

Creating Forms

Sorting and Editing Form Data

Database

Administration