ICDL Module 5: Using Databases (Microsoft Access 2007)

Select Industry/Course: Select Course Introduction To Computers ICDL Module 2: Using the Computer and Managing Files (Microsoft Windows XP) Microsoft Project 2003 ICDL Module 3: Word Processing (Microsoft Word 2003) ICDL Module 4: Spreadsheets (Microsoft Excel 2003) ICDL Module 5: Using Databases (Microsoft Access 2003) ICDL Module 6: Presentations (Microsoft PowerPoint 2003) Microsoft Office Specialist Certificate – Word 2003 (Core) Microsoft Office Specialist Certificate – Excel 2003 (Core) Microsoft Office Specialist Certificate – Access 2003 (Core) Microsoft Office Specialist Certificate – PowerPoint 2003 Microsoft Office Specialist Certificate – Word Expert 2003 Microsoft Office Specialist Certificate – Excel Expert 2003 Microsoft Certified Application Specialist: Word 2007 Microsoft Certified Application Specialist: Excel 2007 WebPage Fundamentals using Microsoft FrontPage AutoCAD 2009 Essential AutoCAD 2009 Intermediate AutoCAD 2009 – Creating & Presenting 3D Models PC Building and Maintenance PC Networking Course Office Networking Jumpstart to Microsoft Visual Basic .Net Autodesk 3D Studio Max for Design Visualization Microsoft Certified Application Specialist (MCAS) - PowerPoint 2007 Microsoft Certified Application Specialist (MCAS) - Access 2007 ICDL Module 3 : Word Processing (Microsoft Word 2007) ICDL Module 4: Spreadsheets (Microsoft Excel 2007) ICDL Module 5: Using Databases (Microsoft Access 2007) ICDL Module 6: Presentations (Microsoft PowerPoint 2007) ICDL Module 2: Using the Computer and Managing Files (Microsoft Windows Vista) AutoCAD 2010 Essential AutoCAD 2010 Intermediate Learning AutoCAD 3D Web Communication using Dreamweaver CS4 Rich Media Communication using Flash CS4 Visual Communication using Photoshop CS4

Course Schedule & Online Registration

If you are an individual, please click here.
If you are representing a company, please click here

Target Audience

Individuals who are interested to learn how to manage data / information in a database.

Course Overview

1. Understand the main concepts of databases
2. Demonstrate the ability to use a database on a computer
3. Able to create and modify tables, queries, forms and reports
4. Able to relate tables and to retrieve and manipulate information from a database by using query and sort tools available in the package

Course Duration

16 hours / 2 days

Assessment

Participants are required to sit for ICDL examination.

Course Outline

Using the Application

• Database Concepts
• First Steps with Databases
• Adjust Settings

Tables

• Main Operations
• Define Keys
• Table Design/Layout
• Table Relationships

Retrieving Information

• Main Operations
• Queries
• Sort Records

Advance Query

• Query with multiple table
• Update and Delete Table
• Creating new Table
• Parameter Query

Forms

• Working with Forms
• Printing in forms

Reports

• Working with Reports
• Printing in Reports

Pre-requisites

ICDL Certification in Using the Computer & Managing Files‚ ESS Basic ICT Skills‚ ESS Workplace ICT Applications

Course Location

NTUC Trade Union House
73 Bras Basah Road
#02-01
Singapore 189556

Methodology

Instructor-Led

Certification

Successful trainees will receive the internationally recognised ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore, a new initiative from ECDL Foundation.

Price

Without GST
Non Union Members:
Course Fee: $300.00
Exam Fee: $20.00

Union Members:
Course Fee: $250.00 (exam fees inclusive)

With GST
Non Union Members:
Course Fee: $321.00
Exam Fee: $21.40

Union Members:
Course Fee: $267.50 (exam fees inclusive)

Funding Info

SPUR funding is available for Singaporeans/Permanent Resident and Corporate Sign up Trainees Only
* SPUR Funding is not applicable for individual sign up trainees and online registration