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.
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
An understanding of MS Access 2010 basic and intermediate level is required.
- /5 from users
- Course Provider COMAT TRAINING SERVICES PTE LTD
- Course Category Technology
- Course Price n/a