Cours MS Access 2010 and 2007 Fundamentals English

Imprimer Retour


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.


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


  • 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


Support de cours

  • Training material in supplement


2 jour(s)

Nos cours collectifs

Disponibilité sur demande

Conditions générales de vente

Pour toute problématique d'accès ou de situation de handicap merci de contacter nos équipes.