Step by Step Databases

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]

€29.99 VAT Inc.

259 Available

Add To Basket

ISBN

9780717160433

Publication Date

March 2014

Language(s)

English

Format

Paperback, 384 pages

Country of Origin

IRELAND

Publisher

Gill Education

Index

Introduction
Section 1: Beginners Database Assignments
Section 2: Intermediate Database Assignments
Section 3: Advanced Database Assignments
Section 4: Introduction to Relational Databases
Glossary of Database Terms

Dimensions

245 x 171 mm

Author(s)

By Alan Dillon

Availability

Available

Availability Status

Available

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.


Additional Resources

€29.99 VAT Inc.
Add To Basket
Gill Education,
Hume Avenue,
Park West,
D12 YV96,
Ireland.
Follow Gill Education on:
Like us on Facebook
Follow us on Twitter
© 2019 M.H. Gill & Co. Unlimited Company