Training: ICDL ADVANCED – Database – AM5

Ref. ECDL3-AM5
Duration:
2
 days
Exam:
Optional
Level:
Advanced

Description

This course covers the key database concepts necessary to understand a relational database and use an appropriate application to create an advanced database structure and outputs.

Participant profiles

  • Individuals wishing to develop their skills and Knowledge about the use of a database

Objectives

  • 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. Create subreports and enhance report presentation
  • Enhance productivity by working with macros and use linking and importing features to integrate data

Prerequisites

  • Advanced knowledge on databases
  • 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
  • Create subreports and enhance report presentation

Course content

Chapter 1: Database Concepts

  • Module 1: Database Development and Use
    • Know that different types of database models exist like: hierarchical, relational, object-oriented
    • Know the life cycle stages of a database: logical design, database creation, data entry, data maintenance, information retrieval
    • Recognize common business applications of databases like: dynamic website, customer relationship management systems, enterprise resource planning systems, website content management systems
    • Know the term SQL (structured query language) and understand its main use in querying database content

Chapter 2: Tables and Relationships

  • Module 1: Fields/Columns
    • Create, modify, delete a lookup in a field/ column
    • Create, modify, delete an input mask in a field/ column
    • Set data entry for a field/column: required, not required
  • Module 2: Relationships and Joins
    • Create, modify, delete a one-to-one, one-tomany relationship between tables
    • Create, modify a many-to-many relationship using a junction table
    • Apply referential integrity between tables
    • Apply automatic update of related fields
    • Apply automatic deletion of related records
    • Apply, modify an inner join, outer join
    • Create, modify a subtract join
    • Apply a self join

Chapter 3: Queries

  • Module 1: Query Types
    • Create, run a query to update data in a table
    • Create, run a query to append records to a table
    • Create, run a query to delete records in a table
    • Create, run a query to save selected data as a new table
    • Create, run a crosstab query
    • Create, run a query to show duplicated records within a table
    • Create, run a query to show unmatched records in related tables
  • Module 2: Refining a Query
    • Create, modify, run a one, two variable parameter query
    • Use wildcards in a query: [ ], !, -, #
    • Show highest, lowest range of values in a query
    • Create and name a calculated field that performs arithmetic operations
    • Group information in a query using functions: sum, count, average, max, min

Chapter 4: Forms

  • Module 1: Controls
    • Create, modify, delete bound controls: text box, combo box, list box, check box, option groups
    • Apply, remove bound control properties like: limit to list, distinct values
    • Create, modify, delete unbound controls containing arithmetic, logical expressions
    • Modify sequential tab order of controls on a form
    • Create, delete a linked subform

Chapter 5: Reports

  • Module 1: Controls
    • Format arithmetic calculation controls in a report: percentage, currency, to a specific number of decimal places
    • Apply a running sum for a group, over all
    • Concatenate fields in a report
  • Module 2: Presentation
    • Insert, delete a data field in group, page, report headers and footers
    • Sort, group records in a report by field(s)
    • Force page breaks for groups in a report
    • Create, delete a linked subreport

Chapter 6: Enhancing Productivity

  • Module 1: Linking, Importing
    • Link external data to a database: spreadsheet, text (.txt, .csv), existing database files
    • Import spreadsheet, text (.txt, .csv), XML, existing database files into a database
  • Module 2: Automation
    • Create a simple macro like: close an object and open another object, open and maximize an object, open and minimize an object, print and close an object
    • Assign/attach a macro to a command button, object, control

Documentation

  • Digital courseware included

Lab / Exercises

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

Exam

  • This course prepares to the exam ICDL Database Advanced (AM5). 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

lun22Avr(Avr 22)09:00mar23(Avr 23)17:00VirtuelVirtual Etiquettes de sessionECDL3-AM5

lun22Avr(Avr 22)09:00mar23(Avr 23)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL3-AM5

lun27Mai(Mai 27)09:00mar28(Mai 28)17:00VirtuelVirtual Etiquettes de sessionECDL3-AM5

lun27Mai(Mai 27)09:00mar28(Mai 28)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL3-AM5

lun01juil09:00mar02(juil 2)17:00VirtuelVirtual Etiquettes de sessionECDL3-AM5

lun01juil09:00mar02(juil 2)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL3-AM5

lun05Aoû(Aoû 5)09:00mar06(Aoû 6)17:00VirtuelVirtual Etiquettes de sessionECDL3-AM5

lun05Aoû(Aoû 5)09:00mar06(Aoû 6)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL3-AM5

lun09Sep(Sep 9)09:00mar10(Sep 10)17:00VirtuelVirtual Etiquettes de sessionECDL3-AM5

lun09Sep(Sep 9)09:00mar10(Sep 10)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL3-AM5

lun14Oct(Oct 14)09:00mar15(Oct 15)17:00VirtuelVirtual Etiquettes de sessionECDL3-AM5

lun14Oct(Oct 14)09:00mar15(Oct 15)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL3-AM5

lun18Nov(Nov 18)09:00mar19(Nov 19)17:00VirtuelVirtual Etiquettes de sessionECDL3-AM5

lun18Nov(Nov 18)09:00mar19(Nov 19)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionECDL3-AM5

lun23Déc(Déc 23)09:00mar24(Déc 24)17:00VirtuelVirtual Etiquettes de sessionECDL3-AM5

lun23Déc(Déc 23)09:00mar24(Déc 24)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionECDL3-AM5

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