Training: ICDL STANDARD – Using databases – SM1

Ref. ECDL2-SM1

Download PDF

Duration:

2

days

Exam:

Included

Level:

Intermediate

Funding:

Eligible

Home > Trainings > Office Automation > Office Automation Certifications > ICDL STANDARD – Using databases – SM1

Using Databases Training – ECDL STANDARD – SM1

This course, “ECDL STANDARD – Using Databases – SM1,” provides a clear and practical understanding of how a database works. You will learn to organize, store, and manage information efficiently while developing the essential skills needed for everyday data handling.

The ECDL database training helps you understand how a database is built, structured, and maintained. You will explore the relationships between tables, records, and fields, as well as the core principles of database design and organization. Through a step-by-step approach, you will learn to create your own tables, filter and sort data, build precise queries, and produce professional reports.

A recognized certification and practical skills

Preparing for the ECDL Standard certification allows you to officially validate your knowledge in data management. This course focuses on the practical skills most valuable in the workplace. Whether you are a beginner or an experienced user looking to strengthen your foundation, you will learn to handle data methodically and accurately. By the end of the training, you will not only be able to create and manage a simple database but also fully leverage its potential to enhance your daily tasks and the quality of your analyses.

Participant Profiles

Administrative employees managing lists and records
Assistants and coordinators handling operational information
Professionals aiming for the ECDL Standard certification
Users wishing to structure and secure their data

Objectives

To understand what a database is and how it is built and organized
Create a simple database and know the different elements that compose it
Create a table by specifying / modifying the fields that compose it. Enter and edit data in the table
Track / filter data in a table, in a form. Create, modify, execute queries to find specific information in a database
To know what a form is and create one to enter, edit or delete records or data in a table
Create reports and layout documents before distributing them

Prerequisites

Basic knowledge (ICDL Base)

Course Content

Using the Application

Module 1: Working with Presentations

Open, close a presentation application. Open, close presentation(s)
Create a new presentation based on default template, another available template locally or online
Save a presentation to a location on a local, online drive. Save a presentation under another name to a location on a local, online drive
Save a presentation as another file type : pdf, show, image file format
Switch between open presentations

Module 2: Enhancing Productivity

Set basic options/preferences in the application: username, default folder to open, save files
Use available help resources
Use magnification/zoom tools
Display, hide built-in toolbars. Restore, minimize the ribbon

Developing a Presentation

Module 1: Presentation Views

Understand the uses of different presentation view modes: normal, slide sorter, master, notes page, outline, slide show
Switch between presentation view modes: normal, slide sorter, master, notes page, outline
Recognize good practice in adding slide titles: use a different title for each slide to distinguish between slides in outline view, when navigating in slide show view

Module 2: Slides

Apply a different built-in slide layout to a slide
Apply a built-in design template, theme to a presentation
Apply background colour on specific slide(s), all slides in a presentation
Add a new slide with a specific slide layout like title slide, title and content, title only, blank
Copy, move slides within the presentation, between open presentations
Delete slide(s)

Module 3: Master Slide

Recognize good practice in maintaining a consistent design and format throughout a presentation by using the master slide
Insert a graphical object (picture, drawn object) into a master slide. Remove a graphical object from a master slide
Apply text formatting in a master slide: font sizes, font types, font color

Text

Module 1: Handling Text

Recognize good practice in creating slide content: use short concise phrases, bullet points, numbered lists
Enter text in a placeholder in normal view. Enter text in outline view
Edit text in a presentation
Copy, move text within a presentation, between open presentations
Delete text
Use the undo, redo command
Apply, modify, remove indents on text, bulleted lists, numbered lists

Module 2: Formatting

Apply text formatting: font size, font type
Apply text formatting: bold, italic, underline, shadow
Apply font colour to text
Apply case changes to text
Align text left, centre, right in a text frame
Apply spacing above, below text, bulleted lists, numbered lists. Apply line spacing within text, bulleted lists, numbered lists: single, 1.5 lines, double
Switch between the different standard bullet, number styles in a list
Insert, edit, remove a hyperlink

Module 3: Tables

Create, delete a table
Enter, edit text in a table
Select cells, rows, columns, entire table
Insert, delete rows and columns
Modify column width, row height

Charts

Module 1: Using Charts

Input data to create built-in charts in a presentation: column, bar, line, pie
Select a chart
Change the chart type
Add, remove, edit a chart title
Add data labels to a chart: values/numbers, percentages
Change the background colour of a chart
Change the column, bar, line, pie slice colours in a chart

Module 2: Organisation Charts

Create an organisation chart with a labelled hierarchy using a built-in organisation chart feature
Change the hierarchical structure of an organisation chart
Add, remove co-workers, subordinates in an organisation chart

Graphical Objects

Module 1: Insert, Manipulate

Insert a graphical object (picture, drawn object) into a slide
Select graphical object(s)
Copy, move graphical objects, charts within the presentation, between open presentations
Resize a graphical object maintaining, not maintaining aspect ratio. Resize a chart
Delete a graphical object, chart
Rotate, flip a graphical object
Align graphical object(s) relative to a slide: left, centre, right, top, bottom
Align graphical objects relative to each other left, centre, right, top, bottom, middle

Module 2: Drawing

Add different types of drawn object to a slide: line, arrow, block arrow, rectangle, square, oval, circle, text box
Enter text into a text box, block arrow, rectangle, square, oval, circle
Change drawn object background colour, line colour, line width, line style
Change arrow start style, arrow finish style
Apply a shadow to a drawn object
Group, ungroup drawn objects in a slide
Bring a drawn object one level forward, one level backward, to the front, to the back of other drawn objects

Prepare Outputs

Module 1: Preparation

Add, remove built-in transition effects between slides
Add, remove preset animation effects for different slide elements
Add presenter notes to slide(s)
Hide, show slide(s)
Enter text into footer of specific slide(s), all slides in a presentation
Apply automatic slide numbering, automatically updated date, fixed date to the footer of specific slide(s), all slides in a presentation

Module 2: Check and Deliver

Spell check a presentation and make changes: correcting spelling errors, ignoring specific words, deleting repeated words
Change slide orientation to portrait, landscape. Select appropriate output format for slide presentation: paper, on-screen show
Print a presentation using output options: entire presentation, specific slide(s), handouts, notes pages, outline view of slides, number of copies of a presentation
Start a slide show from first slide, from current slide. End a slide show
Navigate to next slide, previous slide, specified slide during a slide show

Documentation

Digital courseware included

Lab / Exercises

This course includes hands-on exercises designed to reinforce your knowledge and apply your skills in real-world professional scenarios.

Exam

This course prepares for the ICDL Standard – Using databases (SM1). If you wish to take this exam, please contact our secretariat who will let you know the cost of the exam and will take care of all the necessary administrative procedures for you

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

The database at the heart of information management

In a world where organizations depend on ever-increasing volumes of data, knowing how to structure and efficiently use that information has become essential. A database is not just a storage tool; it is a true system for organizing knowledge. This ECDL Standard training provides a practical understanding of these mechanisms and teaches you the best practices in data management. You will learn how to organize, secure, and enhance your information to better serve your professional activity.

From design to data structuring

Before creating a database, it is crucial to understand its logic. Each element—tables, fields, and records—must be designed coherently. A clear structure makes maintenance easier and avoids duplication. You will learn how to model information, define meaningful relationships, and select appropriate data types. These skills enable you to build a powerful and sustainable database that can evolve with your professional needs.

Reliability at the core of information management

A reliable database is built on simple principles: logical structure, field validation, and referential integrity. The course guides you through applying these concepts to prevent input errors and ensure data accuracy. You will also discover how to use queries to analyze your information precisely and extract actionable insights in just a few clicks. These techniques strengthen both consistency and traceability—two essential qualities in any professional environment.

Using and enhancing data in everyday work

The true value of a database lies in its ability to deliver the right information at the right time. You will learn to sort, filter, and search specific records efficiently. With these skills, you can generate reliable and relevant reports for your team or clients. Forms will help you simplify data entry and updates, making every action faster, smoother, and more secure. These methods significantly improve productivity in your daily data management tasks.

Clear reports for informed decision-making

This course teaches you how to produce professional reports that make data easier to read and interpret. You will explore formatting options, grouping, and automatic calculations. Mastering these reporting tools transforms your database into a genuine decision-making resource. In the workplace, this skill is highly valued as it enhances responsiveness and the quality of strategic analyses.

A valuable ECDL Standard certification

The ECDL Standard certification officially recognizes your competence in using databases. It validates your ability to structure, query, and manage digital information effectively. This international credential is a real asset on the job market. Employers appreciate its credibility, as it demonstrates practical technical skills and a methodical approach to data management. It also represents a mark of professionalism for anyone seeking to prove their ability to work accurately and efficiently.

Useful skills for multiple professions

The skills acquired in this course are applicable across many fields. Whether you work in administration, finance, communication, or logistics, database management is a universal need. The ECDL Standard training allows you to create and manage data independently, without constant technical support. You gain efficiency and accuracy while contributing to the overall improvement of your organization’s internal processes.

Combining theory, practice, and certification

The strength of this course lies in its balance between theory and practice. You will understand the principles of database design and immediately apply them to real-world scenarios. The goal is not only to pass the ECDL exam but also to truly integrate these skills into your daily work. This hands-on approach makes the training engaging, accessible, and directly applicable to your professional responsibilities.

FAQ

Is this course suitable for beginners?
Yes, it is designed for anyone with basic ECDL knowledge. Concepts are presented clearly and progressively.

What are the concrete benefits of mastering a database?
It helps you organize information better, avoid duplication, and produce reliable analyses for informed decision-making.

How is the ECDL Standard certification recognized?
ECDL is an internationally recognized benchmark that validates essential digital skills. It enhances your profile among employers and business partners.

Does the course include practical exercises?
Yes, each module includes hands-on activities that allow you to immediately apply what you learn to real database scenarios.

Which types of jobs can benefit from this training?
Administrative assistants, data managers, analysts, and anyone looking to improve their information management skills will benefit from this training.