Microsoft Office Specialist Certificate – Access 2003 (Core)

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 about the usage of database in terms of storing‚ organizing and retrieving data.

Course Duration

21 hours / 3 days exclude examination hours

Assessment

Participants are required to sit for 1 Microsoft Office Specialist (MOS) examination.
*Any amendments (subject to availability) to a confirmed exam booking, an administrative charge of $21.40 will be imposed.

Course Outline

Structuring Databases

• Create Microsoft Access databases
• Create and modify tables
• Define and modify field types
• Modify field properties
• Create and modify one-to-many relationships
• Enforce referential integrity
• Create and modify queries
• Create forms
• Add and modify form controls and properties
• Create reports
• Add and modify report control properties
• Create a data access page

Entering Data

• Enter‚ edit‚ and delete records
• Find and move among records
• Import data to Access

Organizing Data

• Create and modify calculated fields and aggregate functions
• Modify form layout
• Modify report layout and page setup
• Format datasheets
• Sort records
• Filter records

Managing Databases

• Identify object dependencies
• View objects and object data in other views
• Print database objects and data
• Export data from Access
• Back up a database
• Compact and repair databases

Pre-requisites

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

Course Location

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

Methodology

Instructor-led class

Certification

• Certificate of Completion from NTUC LearningHub /
• Microsoft Office Specialist Certification upon passing the exam

Price

Without GST
Non Union Members:
Course Fee: $420.00
Exam Fee: $114.00

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

With GST
Non Union Members:
Course Fee: $449.40
Exam Fee: $121.98

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