ao link

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]


130 Available

Add To Basket



Publication Date

March 2014




Paperback, 384 pages

Country of Origin



Gill Education


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


245 x 171 mm


By Alan Dillon

Availability Status


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

Add To Basket
Gill Education,
Hume Avenue,
Park West,
D12 YV96,
Follow Gill Education on:
Like us on Facebook
Follow us on Twitter
Follow us on Instagram
© 2021 M.H. Gill & Co. Unlimited Company