ECDL Advanced Databases for Microsoft Office XP & Office 2003

Description

Written by experienced trainers Paul Holden and Brendan Munnelly Clear, simple, friendly guidance on the Advanced module. Basic computer terms and concepts explained in plain English. Screen images and illustrations guide the student through the Microsoft Access application. "How-to" information based on practical examples of everyday tasks. Short cuts and insider tips drawn from the real-world experience of computer professionals. Summary of critical information at the end of each section. Easy-to-follow exercises in the book and on the CD-ROM to help you test your progress. Look up fields, calculated fields, Macros, Action queries, Find duplicated. Aimed at the more competent database user who needs to extract more sophisticated management data or organise data more efficiently.

CONTENTS:

Database development: Overview
Table design: What tables, what fields?
Data types, field sizes, field formats
Advanced field properties
Relationships
Joins
Action queries
Total queries
Custom calculations
Query design: Refining queries
Form design: Controls
Calculated controls
Subforms
Report design
Macros
Importing , linking & exporting data
In conclusion
CD contains exercises