ICDL Module 5: ES WSQ – Perform Database Functions (Microsoft Access 2013 Fast Track)

Course details

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

This course provides the learners an understanding of the basic concepts of databases and demonstrates the ability to use a database on a personal computer. The module is divided in two sections; the first section tests the learners' ability to design and plan a simple database using a standard database package; the second section requires the learners 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 learners 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