ES WSQ – 3 Days – Perform Advanced Databases Functions (Ms Advanced Access 2013) (ICDL Certification Module: Advanced Databases)

Commencement Dates

Training location Schedule

Overview

Course Duration

24 Hours

Target Audience

For beginner and professional who in need of Advanced Databases applications to better manage and organize structured information.

Pre-requisites

Need to possess basic knowledge of Access 2013

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 60 minutes online assessment at the end of the course.

Course Pathway

Any other ICDL courses

Objectives

ICDL Advanced Database is a high level certification program which enables candidates gets more from the database application by giving them the skills to use the many advanced tools available in database applications to better manage and organize structured information.


Individuals with ICDL Advanced Database certified skills can:

 

  • Produce better reports with deeper data analysis
  • Produce higher quality management information
  • Use advanced features in table, query, form and report design
  • Use macros within the database application
  • Import, export and link data

Course Details

SECTION

DESCRIPTION

Section 1 - Fundamentals

Understand Database Concepts
Understand SQL
Create a Database
Design a Table

Section 2 – Field Properties

Create Lookup Fields
Set and Modify Default Values
Set Mandatory Fields
Create Validation Rules and Text
Create Input Masks

Section 3 - Queries

Create Sum and Count Queries
Use Group By in Queries
Show Average, Maximum and Minimum Values
Create Calculated Fields
Create Parameter Queries
Use Wildcards

Section 4 - Relationships

Apply Primary Keys
Apply and Modify Different Types of Relationship
Query Related Tables
Understand Joins
Apply Referential Integrity
Update and Delete Related Records
Work with Subdatasheets

Section 5 - Forms

Create Main Forms and Sub Forms
Link Forms
Create Forms from Multiple Tables

Section 6 - Form Controls

Create the following controls:
Calculated Fields on Forms
Command Buttons
Combo Boxes
List Boxes and Check Boxes
Option Groups
Add Data Fields to Headers and Footers

Section 7 - Reports

Create Grouped Reports
Create Sub reports
Insert Page Breaks
Create Calculated Fields in Reports
Calculate Percentages
Insert Data Fields in Headers and Footers
Print Reports

Section 8 - Import and Link Data

Import Data from Spreadsheets
Import Data from Text Files
Import Data from Tables
Link a Database to External Data

Section 9 - Action Queries

Create Append Queries
Create Delete Queries
Make a Table from a Query
Create an Update Query

Section 10 – Query Wizards

Create a Crosstab Query
Create a Find Duplicates Query
Create a Find Unmatched Query

Section 11 - Macros

Understand Macro Actions
Create a Macro
Attach a Macro to a Control or Object
Create Macros from Controls
Create Command Button Macros

Fees Structure

Subsidy and Nett Payable Amount

Subsidy Categories

Fees after subsidy

Fees payable with GST

Company

SME Company

$46/-

$78.20/-

Non – SME Company

$92/-

$124.20/-

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

$460/-

$492.20/-

Individual

Singaporean - 40 yrs and above

$46/-

$78.20/-

Singaporean – 21 – 39 yrs

$92/-

$124.20/-

Singapore PR

$92/-

$124.20/-

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

$23/-

$55.20/-

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

E-Pass, Dependant Pass)

$460/-

$492.20/-

SME: Small and Medium Enterprise

WTS: Workfare Training Support

Participant need to pass the test to get subsidy


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