ICDL Module 5: ES WSQ - Perform Database Functions (Microsoft Access 2007) Central Area, Central

Course details

The course provides the learners the basic concepts of databases and to demonstrate the ability to use a database on a personal computer. The module is divided in two sections; the first section, 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