Step by Step Databases by Alan Dillon

Step by Step Databases by Alan Dillon

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]

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.

SKU	Unavailable
ISBN 13	9780717160433
ISBN 10	0717160432
Title	Step by Step Databases
Author	Alan Dillon
Series	Step By Step
Condition	Unavailable
Binding Type	Paperback
Publisher	Gill
Year published	2014-03-21
Number of pages	384
Cover note	Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
Note	Unavailable