This is an example of a simple banner

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

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.
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
Mois actuel

jeu20Fév(Fév 20)09:00ven21(Fév 21)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu20Fév(Fév 20)09:00ven21(Fév 21)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionECDL2-SM1

jeu27Mar(Mar 27)09:00ven28(Mar 28)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

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

jeu01Mai09:00ven02(Mai 2)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu01Mai09:00ven02(Mai 2)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionECDL2-SM1

jeu05Juin(Juin 5)09:00ven06(Juin 6)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

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

jeu10juil(juil 10)09:00ven11(juil 11)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu10juil(juil 10)09:00ven11(juil 11)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionECDL2-SM1

jeu14Aoû(Aoû 14)09:00ven15(Aoû 15)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

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

jeu18Sep(Sep 18)09:00ven19(Sep 19)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu18Sep(Sep 18)09:00ven19(Sep 19)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionECDL2-SM1

jeu23Oct(Oct 23)09:00ven24(Oct 24)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu23Oct(Oct 23)09:00ven24(Oct 24)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL2-SM1

jeu27Nov(Nov 27)09:00ven28(Nov 28)17:00VirtuelVirtual Etiquettes de sessionECDL2-SM1

jeu27Nov(Nov 27)09:00ven28(Nov 28)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionECDL2-SM1

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

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

Contact us

Your request