ECDL Advanced Syllabus 2.0 Module AM5 Database using Access XP

Description

If databases are your preference, then this manual could be for you. It covers all aspects required by the ECDL Advanced AM5 syllabus, but could assist those wishing to further their database knowledge. Included are exercises ranging from creating a database to creating complex grouped reports and performing action queries. Data is available to download. The data files allow you to practise the different software features. Approved by the ECDL Foundation.

CONTENTS:

Database concepts and developments

SQL

Creating a database

Lookup fields

Setting a mandatory field

Input masks

Performing various queries

Query wizards

Action queries

Wildcards in queries

Applying relationships

Applying joins

Referential integrity

Forms and subforms

Calculated fields

Command buttons

Combo boxes

Other form controls

Creating and printing reports

Grouped reports

Subreports

Importing and linking data

Creating and using macros