fbpx ICDL - Perform Advanced Database Functions (Advanced Access 2013) | Eagle Infotech Skip to main content

ICDL - Perform Advanced Database Functions (Advanced Access 2013)

Download PDF Outline

Download PDF Outline

-------------------------------------

ICDL Advanced Database is a high level certification programme which enables learners to get more from the database application by giving them the skills to use the many advanced tools available in database applications to better manage and organise 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

Target Audience

Prospective learners should ideally have the ICDL certification and/or previous experience using computers and common software applications. Typically, these would be individuals who use a wide range of advanced functionalities within a database application in a personal or professional context. Database applications are a powerful resource, managing and analysing high volumes of data to produce the quantity and quality of information that business today demands. The ICDL Advanced Database certification has been specifically designed to provide learners with the skills and competences that enable them to use database applications to their full potential

Course Content

Database Concepts

Database Development and Use

  • Know that different types of database models exist.
  • Know the life cycle stages of database.
  • Recognize common business applications of databases.
  • Know the term SQL (structured query language) and understand its main use in querying database content.

Tables and Relationships

Fields/Columns

  • Create, modify, delete a lookup in a field/column.
  • Create, modify, delete an input mask in a field/column.
  • Set data entry for a field/column.

Relationships and Joins

  • Create, modify, delete a one-to-one, one-to-many relationship between tables.
  • Create, modify a many-to-many relationship using a junction table.
  • Apply referential integrity between tables.
  • Apply automatic update of related fields.
  • Apply automatic deletion of related records.
  • Apply, modify an inner join, outer join.
  • Create, modify a subtract join.
  • Apply a self join.

Queries

Query Types

  • Create, run a query to update data in a table.
  • Create, run a query to append records to a table.
  • Create, run a query to delete records in a table.
  • Create, run a query to save selected data as a new table.
  • Create, run a crosstab query.
  • Create, run a query to show duplicated records within a table.
  • Create, run a query to show unmatched records in related tables.

Refining a Query

  • Create, modify, run a one, two variable parameter query.
  • Use wildcards in a query.
  • Show highest, lowest range of values in a query.
  • Create and name a calculated field that performs arithmetic operations.
  • Group information in a query using functions.

Forms

Controls

  • Create, modify, delete bound controls.
  • Apply, remove bound control properties.
  • Create, modify, delete unbound controls containing arithmetic, logical expressions.
    Modify sequential tab order of controls on a form
  • Create, delete a linked subform.

Reports

Controls

  • Format arithmetic calculation controls in a report.
  • Apply a running sum for a group, over all.
  • Concatenate fields in a report.

Presentation

  • Insert, delete a data field in group, page, report headers and footers.
  • Sort, group records in a report by field(s).
  • Force page breaks for groups in a report.
  • Create, delete a linked subreport.

Enhancing Productivity

Linking, Importing

  • Link external data to a database.
  • Import spreadsheet, text, XML, existing database files into a database.

Automation

  • Create a simple macro.
  • Assign/attach a macro to a command button, object, control.

Company-Sponsored (Effective till 31st December 2021)

Funding Type Full Fee GST Funding Amount Nett Fee Payable (Incl. GST)
Funding TypeSME Full Fee$495 GST$34.65 Funding Amount($445.50) Nett Fee Payable$84.15
Funding TypeNon-SME Full Fee$495 GST$34.65 Funding Amount($396.00) Nett Fee Payable$133.65
Funding TypeNon-SME (MCES) Full Fee$495 GST$34.65 Funding Amount($445.50) Nett Fee Payable$84.15
  • SME: Singapore registered companies with (i) at least 30% local sharing AND (ii) Group annual sales less than $100 million OR Group employment size less than 200
  • Non-SME (MCES): Employee is Singaporean age 40 and above 

 

Self-Sponsored (Effective till 31st December 2021)

Funding Type Full Fee GST Funding Amount Nett Fee Payable (Incl. GST)
Funding TypeMCES Full Fee$495 GST$34.65 Funding Amount($445.50) Nett Fee Payable (Incl. GST)$84.15
Funding TypeNormal Full Fee$495 GST$34.65 Funding Amount($396.00) Nett Fee Payable (Incl. GST)$133.65
  • MCES: Singaporean age 40 and above
  • Normal: Singaporean age below 40 or PR

 


Company-Sponsored *(NEW FUNDING effective 1st January 2022)*

Funding Type Full Fee GST Funding Amount Nett Fee Payable (Incl. GST)
Funding TypeSME Full Fee$495 GST$34.65 Funding Amount($346.50) Nett Fee Payable$183.15
Funding TypeNon-SME Full Fee$495 GST$34.65 Funding Amount($247.50) Nett Fee Payable$282.15
Funding TypeNon-SME (MCES) Full Fee$495 GST$34.65 Funding Amount($346.50) Nett Fee Payable$183.15
  • SME: Singapore registered companies with (i) at least 30% local sharing AND (ii) Group annual sales less than $100 million OR Group employment size less than 200
  • Non-SME (MCES): Employee is Singaporean age 40 and above 

 

Self-Sponsored *(NEW FUNDING effective 1st January 2022)*

Funding Type Full Fee GST Funding Amount Nett Fee Payable (Incl. GST)
Funding TypeMCES Full Fee$495 GST$34.65 Funding Amount($346.50) Nett Fee Payable (Incl. GST)$183.15
Funding TypeNormal Full Fee$495 GST$34.65 Funding Amount($247.50) Nett Fee Payable (Incl. GST)$282.15
  • MCES: Singaporean age 40 and above
  • Normal: Singaporean age below 40 or PR
Course Duration
24
Course Reference Number
TGS-2013501051
Funding Validity Period
From 01 Jan 2019 To 04 Dec 2022
Mode of Training
Classroom