Pass ECDL4 Module 5

Pass ECDL4 Module 5

List price: US$14.22

Currently unavailable

We can notify you when this item is back in stock

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

The European Computer Driving Licence (ECDL) is an internationally recognised qualification for IT skills. There are 7 modules in total. Written in a lively but straightforward and easy-to-follow style, this book will be an indispensable guide for all students studying for the ECDL qualification. Module 5: Database This module covers the main concepts of databases. You will learn how to use a database application to keep records so that you can easily make queries to retrieve the information you need, sort it in any order and print reports. Step-by-step instructions, jargon-free text and lots of screenshots make this book ideal for either class teaching or individual study. Requires no previous knowledge; Uses Access 2003 software (can also be used with Access 2000 and 2002 (XP)); Practical approach and sample exercises to build confidence; Endorsed by ECDLshow more

Product details

  • Paperback | 104 pages
  • 187 x 245 x 6mm | 230g
  • Pearson Education Limited
  • PAYNE-GALLWAY PUBLISHERS
  • Harlow, United Kingdom
  • 1904467334
  • 9781904467335

Table of contents

Chapter 5.1 Introduction to Databases What is Microsoft Access? Planning a database A flat file database A relational database Entity-relationship diagrams Data Types Field properties The database structure Naming conventions Chapter 5.2 Creating a New Database Opening Access The Database window Hiding and displaying toolbars Using the Help functions Creating a new table Defining the primary key Saving the table structure Indexing Closing the database application Chapter 5.3 Setting up Relationships Relationships window Creating a relationship Deleting a relationship Saving the relationships Chapter 5.4 Datasheet View Opening an existing database Table views Entering data in a table Using the record selectors Finding a record Modifying data Adding a new record Deleting a record Chapter 5.5 Data Validation Comparison operators Entering the validation rules Testing the validation rule More testing! Chapter 5.6 Sorting, Formatting and Printing Sorting records Formatting and printing a datasheet Changing the Page layout Printing only selected records Hiding and Unhiding columns Moving columns Chapter 5.7 Forms User interface Creating a new form Changing view mode Adding text to the header The Formatting toolbar Adding text to the footer Closing and opening a form Entering data using the form The record selectors Going to specific records Printing the form Page setup Chapter 5.8 Applying Filters Using a filter in a form Filter by selection Removing the filter Filter by Form Using filter in a table Chapter 5.9 Making Queries Creating a new query Selecting fields to appear in the query Resizing columns Removing fields from the grid Adding and removing criteria Running the query Hiding and unhiding fields Saving the query Sorting data in a query output Sorting on two fields Moving fields Adding a second table to the query Using operators Printing a query Chapter 5.10 Reports Reports based on tables Adding text on Headers and Footers Reports based on queries Creating the report Adding a Sum field Adding a Count field Other useful expressions Printing a reportshow more

Author information

Flora Heathcote is the author of many of Payne-Gallway's successful IT books including Basic Access, Further Access, Access Right from the Start and Dreamwaver Right from the Start.show more