How to work with relational database applications, create and run SQL queries, and build advanced forms and reports.
Become confident, efficient and effective in working with relational database applications.
Design and apply SQL queries to read, create, update and delete tables and data.
Use various controls and subforms to enhance the layout and functionality of input forms.
Enhance report presentation by applying various report controls and subreport options.
Master the more advanced features of spreadsheet applications – such as logical, statistical, financial and mathematical functions, input validation and spreadsheet auditing, and collaboration, tracking and security options.
Understand key concepts of database development and usage.
Create a relational database using advanced table creation features and complex relationships between tables.
Design and use queries to create a table, update, delete and append data.
Refine queries using wildcards, parameters and calculations.
Use controls and subforms to enhance forms and improve functionality.
Create report controls to perform calculations, and create subreports and enhance report presentation.
Work with macros and use linking and importing features to integrate data.
Online programme delivery, learner administration, training content development, online testing and certification, telephone and online support, membership, event and project management, and digital marketing and brand promotion – these are among the services provided by ICS Skills. Here are a few of the clients we serve:
ECDL Ireland Ltd. trading as ICS Skills. Registered in Dublin, Ireland No. 265078. ICS Skills is a Registered Charity in Ireland No. CHY 12259