Back to Top

MS Access Advanced

This is equivalent to ECDL Extra module

In this course learners can demonstrate their ability to apply and understand key database concepts and use a relational database application to create an advanced database structure and outputs.

After completing this workshop the learner should be able to:

  • Understand further concepts of database development and usage.
  • Create a relational database using advanced table creation features and complex relationships between tables.
  • Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations.
  • Use controls and subforms to enhance forms and improve functionality.
  • Create report controls to perform calculations. Create subreports and enhance report presentation.
  • Enhance productivity by working with macros and use linking and importing features to integrate data.

Who is it for?

Learners would include individuals who use a wide range of advanced functionalities within a database application in a personal or professional context.

  • Ideally have previous experience using computers.
  • A basic knowledge of databases and Microsoft Access Knowledge (e.g. gained from the Access Basics Workshop) is also required.
  • What Qualifications will be received?

    • All attendees will receive a Certificate of Achievement on completion.
    • You can choose to sit the ECDL exam for the modules you have completed

    There are further opportunities for learners to build upon what they have learnt. For Example:

  1. Progress to the Advanced Workshop
  2. Attend further workshops and courses which can be used to build up a full IT User Qualification e.g.
  • BCS ITQ qualification
  • European Computer Driving Licence (ECDL)