ABOUT THIS COURSE

ECDL Level 3 Advanced Database requires the candidate to understand key database concepts and use a relational database application to create an advanced database structure and outputs. 

After completing this course you will be able to: 

  • Understand key 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.  


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 centre. 

COURSE CURRICULUM

  • 01

    Course Files

    • Course Files

  • 02

    Database Concepts

    • Database Development and Use

  • 03

    Tables and Relationships

  • 04

    Queries

    • Query Types - Action Queries

    • Query Types - Crosstab Query and Duplicate Records Query

    • Query Types - Unmatched Records Query

    • Refining a Query - Calculated Field and Grouping by Function Queries

    • Refining a Query - Highest and Lowest Ranges Query

    • Refining a Query - Parameter Query

    • Refining a Query - Wildcard Queries

  • 05

    Forms

    • Bound Control Properties - Apply and Remove

    • Combo Box and Text Box - Create, Modify and Delete

    • Form Calculations - Managing Unbound Controls

    • List Box, Check Box and Option Groups - Creating, Modifying and Deleting

    • Sub Forms and Controlling Tab Order

  • 06

    Reports

    • Controls - Calculation Controls

    • Presentation - Reports and Sub Reports

    • Presentation - Grouping, Sorting and Page Breaks

  • 07

    Enhancing Productivity

    • Automation - Command Button - Assigning a Macro

    • Automation - Recording a Macro

    • Linking and Importing - Importing into a Database

    • Linking and Importing - Linking External Data to a Database

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.