About this Course

This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.

The exam requires the candidate to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The candidate shall be able to use the database to organize, extract, view and report on data using what are deemed to be advanced data management skills. The candidate shall understand the variety of ways that data can be related and organized. In addition the candidate shall be able to run and record simple macros and to import, export and link data.

COURSE OUTLINE

Module 1. Designing Advanced Queries

Module 2. Creating Action Queries

Module 3. Using Advanced Query Wizards

Module 4. Using Advanced Form Design

Module 5. Using Advanced Report Design

Module 6. Using Subforms/Subreports

Module 7. Using Other Form Techniques

Module 8. Creating Macros

Module 9. Using Macros

Module 10. Using Advanced Database Features

Module 11. Exporting Data

Module 12. Replicating Database

PRE-REQUISITE

An understanding of MS Access 2010 basic and intermediate level is required.

Rate this course:

Log in to submit

Comments