Cours MS Access 2010 and 2007 Fundamentals English

Imprimer Retour

Objectif

Fundamentals of MS Access 2010 and 2007 is an introductory course that teaches you how to use databases in Microsoft Access 2010 and 2007. This course lasts two days and allows you to become familiar with databases and the extraction of data using simple queries and forms.

Pré-requis

  • Knowledge of the Windows environment
  • Knowledge of Excel is strongly recommended
  • Course on database modeling (optional)

Contenu

  • Introduction to Microsoft Access 2010 
  • Overview on the Access interface
  • Reminder of key database concepts
  • Creation of a relational database
  • Creation of tables (types and field properties, indexing, primary key, attachments, multiple values fields, calculated fields, input masks)
  • Formatting of data (conditional formatting)
  • Manipulation of data (navigation toolbar, advanced filter on forms, synthesis row, integrated calendar)
  • Definition of relationships with or without referential integrity
  • Simple queries using parameters, containing formulas or not.
  • Creation of forms (sub-forms, buttons, lists)
  • Creation of reports
  • Import of or connection to external data (Excel)

Langue du cours

EN

Support de cours

  • Training material in supplement

15.- CHF

Durée

2 jour(s)

Prix

1300.- CHF

Nos cours collectifs

Aucune session programmée

Conditions générales de vente