Step by Step Databases - Brossura

Alan Dillon

Brossura

ISBN 10: 0717160432 ISBN 13: 9780717160433

Casa editrice: Gill & Macmillan Ltd, 2014

Riassunto

Third edition of this popular, easy-to-use textbook, updated for the revised Database Methods Level 5 module [5N0783], which details fundamental database methods while providing for practical experience in database design, implementation and organisation.

 - New to this edition:

• Updated for the revised Database Methods module [5N0783] and Access 2010 (all assignments can be completed using Access 2007)

• Includes new material on the following topics:

• • Understanding SQL code in a Query

  • Building Pivot Queries and Pivot Charts

• Provides instruction on how to create reports in a format suitable for emailing or printing
• Demonstrates how to import data from external data sources such as text files, spreadsheets or existing database files
• Details how to create relationships between tables to develop a database design to a given design brief.

- Shows how to design and format Access forms, create queries using a range of logical operators, organise data in a report using sorting and grouping, set up a table to store different types of data, and use report functions.

- Brings the learner from the basics of database design to an advanced level.

- Emphasises learning through practice.

- No previous experience in databases is required.

 

Written for:

• Database Methods Level 5 module [5N0783]

Su questo libro

Informazioni sull'autore

Alan Dillon teaches Information Technology in Roslyn Park College, Dublin. He has been teaching IT for 20 years and has worked as a computer programmer.

Dettagli dell'edizione

• Editore: Gill & Macmillan Ltd
• Data di pubblicazione: 2014
• Lingua: Inglese
• ISBN 10: 0717160432
• ISBN 13: 9780717160433
• Rilegatura: Copertina flessibile
• Numero edizione: 3
• Numero di pagine: 384
• Contatto del produttore: non disponibile
• Persona responsabile: non disponibile