About this Course
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
PRE-REQUISITE
An understanding of Windows / MS Access 2007 will be an added advantage.
Course Rating
- /5 from users
Course Enquiry
Course Info
- Course Provider COMAT TRAINING SERVICES PTE LTD
- Course Category Technology
- Course Price n/a
Comments