ABOUT THIS COURSE

This module sets out essential concepts and skills relating to understanding the concept of a database and demonstrating competence in using a database application. 

After completing this course candidates will be able to: 

  • Understand what a database is and how it is organised. 
  • Create a simple database and view the database content in various modes.
  • Create a table, define and modify fields, and create relationships between tables. Enter and edit data in a table.
  • Use filters and queries to retrieve specific information from a database. 
  • Create a form to enter, modify and delete records and data in records.
  • Create routine reports and prepare outputs ready for print or electronic distribution.


Please note examinations are not included as part of the course fee. These need to be purchased and arranged with your nearest ECDL Testing Centre. Please click here to find your nearest BCS centre. 

COURSE CURRICULUM

  • 01

    Course Files

    • Course Files To Download

  • 02

    Understanding The Databases

  • 03

    Using The Application

    • Common Tasks

    • Working With Databases

  • 04

    Tables

    • Design

    • Records

    • Relationships

  • 05

    Retrieving Information

    • Main Operations - Searching and Filtering

    • Queries - Operators and Logical Operators in Queries

    • Queries - Single Table and Two Table Queries

    • Queries - Wildcards in Queries

  • 06

    Forms

    • Using Forms

  • 07

    Outputs

    • Exporting Access Objects and Reports

    • Printing and Page Setup

    • Reports

MEET YOUR INSTRUCTOR

Richard Walters is one of NILC's senior level Microsoft Office trainer's and has more than a decade of experience in IT and Business Skills training. Richard has an advanced-level understanding of all Microsoft Office packages and specialises in Excel, Word, PowerPoint, Visio and Project.

Richard Walters

Senior Microsoft Application Instructor

FAQ's

  • When does the course start and finish?

    The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

  • How long do I have access to the course?

    How does 1 years access sound? After enrolling, you have unlimited access to this course for 365 days - across any and all devices you own.

  • What if I am unhappy with the course?

    We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.