ICDL Module 5: ES WSQ - Perform Advanced Database Functions (Microsoft Access 2007)

Course details

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