Step by Step Databases - Softcover

Alan Dillon

Softcover

ISBN 10: 0717160432 ISBN 13: 9780717160433

Publisher: Gill & Macmillan Ltd, 2014

Synopsis

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 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] * Can be used as an introduction to Level 6

About this title

About the Author

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.

Edition details

• Publisher: Gill & Macmillan Ltd
• Publication date: 2014
• Language: English
• ISBN 10: 0717160432
• ISBN 13: 9780717160433
• Binding: Paperback
• Edition number: 3
• Number of pages: 384