ES WSQ – 2 Days – Perform Using Databases Functions (Ms Access 2013 – 17 hrs) (ICDL Certification Module: Using Databases)

Overview

Course Duration

17 Hours 

Target Audience

For beginner and professional who in need of Word Processing in order to create documentations.

Pre-requisites

Need to possess the knowledge of basic PC

Certification

Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between WDA and ICDL Singapore. Student must take a 45 min online assessment at the end of the course.

Course Pathway

ICDL - Perform Advanced Database Functions (Advanced Access 2013)

 

Objectives

This module enables candidates to understand some of the main concepts of databases and demonstrate the ability to use a database application. This includes creating and modifying tables, queries, forms and reports, and preparing outputs ready for distribution, as well as learning to relate tables and to retrieve and manipulate information from a database by using query and sort tools.

On completion of this module each candidate will be able to:

  1. Understand what a database is and how it is organized and operated
  2. Create a simple database and view the database content in various modes
  3. Create a table, define and modify fields and their properties; enter and edit data in a Table
  4. Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database
  5. Understand what a form is and create a form to enter, modify and delete records and data in records

Course Details

SECTION

DESCRIPTION

Section 1 : Concepts and Introducing Access

Database Principles
Designing & Planning a Database
Starting & Exiting Access
Screen Layout
Ribbon & QAT
Getting Help

Section 2 : Working with Databases

Opening & Closing a Database
Navigating in the Database

Section 3 : Tables

Using the Mouse & Keyboard to Move
Create a New Database & Table
Format & Edit Field Properties
Define a Primary Key
Create Index Fields
Create Validation Rules & Text

Section 4 : Table Design

Adding Fields
Field Properties
Editing Field Properties
Indexes
Duplicates
Validation Rules / Text

Section 5 : Editing

Change Column Width
Find Text
Edit & Delete Data
Add Records
Delete & Edit
Use Wildcards to Search
Edit & Enter Data Using Shortcuts

Section 6 : Table Relationships

Understand & Apply Relationships
Create Various Types of Relationship
Defining a Primary Key
Relationship Concepts & Types
Applying Relationships
Referential Integrity
Updating / Deleting Records

Section 7 : Forms

Overview
Quick Forms & the Form Wizard
Form Design (Create / Delete)
Editing a Form Design
Using the Form (Sorting / Editing)
Filtering & Printing From a Form

Section 8 : Report

Using Quick Report
Creating & Deleting a Report
Modifying a Report
Creating Calculations in Reports
Printing From a Report

Section 9 : Queries

Finding Specific Text
Using Wildcards
Querying a Table
The Select Query
Editing / Deleting Queries
Using Value Ranges
Querying Related Tables
AND & OR Queries
Non-Matches
Sorting Query Results
Saving & Printing Queries

Section 10 : Exporting Exporting Data

 

Fees Structure

Subsidy and Nett Payable Amount

Subsidy Categories

Fees after subsidy

Fees payable with GST

Company

SME Company

$36/-

$61.20/-

Non – SME Company

$72/-

$97.20/-

Foreigner (WP, S-Pass, E-Pass, Dependant Pass)

$360/-

$385.20/-

Individual

Singaporean - 40 yrs and above

$36/-

$61.20/-

Singaporean – 21 – 39 yrs

$72/-

$97.20/-

Singapore PR

$72/-

$97.20/-

WTS (35 yrs and above - salary less than $2000)

$18/-

$43.20/-

Foreigner and work pass holders – WP, S-Pass,

E-Pass, Dependant Pass)

$360/-

$385.20/-

SME: Small and Medium Enterprise

WTS: Workfare Training Support

Participant need to pass the test to get subsidy

Commencement Dates

Weekend Classes: Sunday, 4 June 2017 (4 & 11 June - 9am to 6.15pm)
Weekend Classes: Saturday, 17 June 2017 (17 & 24 June - 9am to 6.15pm)
Full Time: Monday, 19 June 2017 (19 & 20 June - 9am to 6.15pm)

Thank you for your enquiry. One of our course consultants will keep in touch with you shortly.

Request more information

What would you like to request?



+



WE ARE...
Adobe authorized training center
WSQ work skills qualification training center
ICDL test center
EduTrust CPE Singapore
GENETIC COMPUTER SCHOOL
Registration No: 198902296M
24 June 2015 to 23 June 2019
OUR LOCATION
Block 118 Aljunied Avenue 2
#02-100 Singapore 380118
Tel: +65 6339 7588