Cantitate/Preț
Produs

Pass ECDL4 Module 5: Payne-Gallway Pass ECDL


en Limba Engleză Paperback – 3 apr 2005
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 ECDL
Citește tot Restrânge

Din seria Payne-Gallway Pass ECDL

Preț: n/a

Nou

Disponibilitate incertă

Doresc să fiu notificat când acest titlu va fi disponibil:

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781904467335
ISBN-10: 1904467334
Pagini: 104
Dimensiuni: 189 x 246 x 6 mm
Greutate: 0.21 kg
Ediția:1
Editura: Pearson Education
Colecția Payne-Gallway
Seria Payne-Gallway Pass ECDL

Locul publicării:Oxford, United Kingdom

Cuprins

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 report

Notă biografică

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.