SkillsFuture Credit
Notice Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided. You may opt to bring along your laptop if you wish to use Excel 2013. Programme ObjectiveAfter the course, participants will be able to:Work with Excel and external databases such as MS-Access using SQLUnderstand and use advanced Excel statistical and data manipulation functions for business analysis and reportingMove datasets between MS-Access and MS-ExcelUnderstand the strengths and weaknesses in MS-Access, MS-Excel
Notice Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided. You may opt to bring along your laptop if you wish to use Excel 2013. Programme ObjectiveAfter the course, participants will be able to:
Understanding DataFundamentals of Data Analysis & SynthesisTypes of dataDeveloping a Data Analysis StrategyBasic Data Analysis Techniques Understanding database design basics What are databases?Introduction to data modelingOrganizing and manipulating the data in databasesWorking with relational databases Building and working with tables including linked tables Creating FormsCreating QueriesReportsSorting and Filtering DataViewing Data Working with TablesCustomizing TablesFormatting TablesControlling Table Data EntryManaging Table Data Entry Relational Database BasicsBrief history of SQLOverview of relational databasesAnatomy of a relational database Acquiring & Exporting DataMethods of accessing dataWorking with AccessWorking with other DAO Databases Excel and SQLConnect from Excel to a databaseExport: Query data into ExcelExcel database communication features, commands, etc. SQL BasicsTerminologyBasic Select StatementsSelect listFROM clauseWHERE clauseORDER BY clauseGROUP BY and HAVING clauseSubqueriesJoinsTo view our full list of Infocomm courses, please click here.Training Methodology Lecture style, with computer hands-on Exercises Closing Date for Registration 1 Week before Programme or Until Full Enrolment
Understanding Data
Understanding database design basics
Building and working with tables including linked tables
Working with Tables
Relational Database Basics
Acquiring & Exporting Data
Excel and SQL
SQL Basics
To view our full list of Infocomm courses, please click here.Training Methodology Lecture style, with computer hands-on Exercises Closing Date for Registration 1 Week before Programme or Until Full Enrolment
This course is useful for anyone who works with external relational databases and wishes to learn SQL to enhance on their data analysis, synthesis and reporting in Excel.
1] SkillsFuture Credit (SFC)Funding Period: Until 15 Dec 2022Course Reference Number: TGS-2020500387
All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. You may wish to use your SFC to pay for partial/full ISCA course fees.
On 1 Oct 2020, the Government provided a one-off SkillsFuture Credit Top-up of $500 for all eligible Singaporeans aged 25 or above by 31 Dec 2020. Singaporeans aged 40 to 60 by 31 Dec 2020 will also receive an Additional SkillsFuture Credit (Mid-Career Support) of $500 which can be used for courses under: (i) SGUnited Skills Programme, (ii) SGUnited Mid-Career Pathways Programme – Company Training, and (iii) Career Transition Programmes. This additional SFC (Mid-Career Support) is NOT applicable for use on ISCA courses. (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)
If you wish to enrol for the course with SFC Funding, please proceed with the following steps:
Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $42.80 for any revision of invoice.
2] WDA Training Grant - SDF FundingThis course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply).
Funding Period: Until 15 Dec 2022Funded Hours: 14 hoursCourse Reference Number: TGS-2020500387
If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :
For course run start date before 1 Nov 2020, submit training grant application in SCN until 30 Nov 2020.
For course run start date on or after 1 Nov 2020, Enterprises/employers are NOT required to log into TPGateway/SCN to submit training grant.
Remarks
• Step 2: After receiving email that the programme status is confirmed, please proceed to submit the Training Grant application via SkillsConnect Portal (https://www.skillsconnect.gov.sg/).
Employers of company-sponsored participants must submit training grant via SkillsConnect to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date.
The employee’s enrolment, attendance and assessment recordswill be submitted by ISCA onto TPGateway.
Please note that there will be an administrative fee of $42.80 for any revision of invoice.
Eligibility Criteria:
You are about to leave ISCA eServices Portal and the registration link will be opened in a new tab. Do you wish to continue?
This course has been added successfully
Declaration to be provided by CPE
This Course is Intended for CA Singapore Users..
If you have an account with us, please sign-in first. If you do not have an account with us, create one now for free.
Do you wish to apply for SFC funding? (Singapore Citizenship Only)