ICDL Module 5: ES WSQ - Perform Database Functions (Microsoft Access 2010 Fast Track)

Course details

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

The exam requires the candidate to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. The module is divided in two sections; the first section tests the candidate's ability to design and plan a simple database using a standard database package; the second section requires the candidate to demonstrate that he or she can retrieve information from an existing database by using the query, select and sort tools available in the data-base. The candidate shall also be able to create and modify reports.

COURSE OUTLINE

• Module 1. Exploring Access
• Module 2. Creating Tables
• Module 3. Setting Field Properties
• Module 4. Working with Tables
• Module 5. Editing Tables
• Module 6. Finding and Filtering Data
• Module 7. Using Simple Queries
• Module 8. Modifying Query Results
• Module 9. Using Operators in Queries
• Module 10. Creating Relationships
• Module 11. Creating Basic Forms
• Module 12. Using Design View
• Module 13. Creating Basic Reports
• Module 14. Using Advanced Report Design