Training: ICDL STANDARD – Using databases – SM1

Ref. ECDL2-SM1
Duration:
2
 days
Exam:
Included
Level:
Intermediate

Description

This training covers fundamental knowledge regarding the structure and management of databases.

Participant profiles

  • Anyone who already have basic knowledge of the Access database and wish to obtain ICDL certification

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

  • Practice exercises will be offered during and at the end of each module

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

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.
Prix de l'inscription
CHF 1'200.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • Exam fee (Skills Card not included)
  • Pre-training level evaluation
  • Digital documentation

jeu23Mai(Mai 23)09:00ven24(Mai 24)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu23Mai(Mai 23)09:00ven24(Mai 24)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL2-SM1

jeu27Juin(Juin 27)09:00ven28(Juin 28)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu27Juin(Juin 27)09:00ven28(Juin 28)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL2-SM1

lun29juil(juil 29)09:00mar30(juil 30)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

lun29juil(juil 29)09:00mar30(juil 30)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL2-SM1

jeu01Aoû09:00ven02(Aoû 2)17:00VirtuelAnnuléeVirtual Etiquettes de sessionECDL2-SM1

jeu01Aoû09:00ven02(Aoû 2)17:00Genève, Route des Jeunes 33B, 1227 CarougeAnnulée Etiquettes de sessionECDL2-SM1

jeu05Sep(Sep 5)09:00ven06(Sep 6)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu05Sep(Sep 5)09:00ven06(Sep 6)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL2-SM1

jeu10Oct(Oct 10)09:00ven11(Oct 11)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu10Oct(Oct 10)09:00ven11(Oct 11)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL2-SM1

jeu14Nov(Nov 14)09:00ven15(Nov 15)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu14Nov(Nov 14)09:00ven15(Nov 15)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL2-SM1

jeu19Déc(Déc 19)09:00ven20(Déc 20)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu19Déc(Déc 19)09:00ven20(Déc 20)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL2-SM1

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X