Cours MS Access 2010 and 2007 Advanced English

Imprimer Retour

Objectif

Access 2010 and 2007 Advanced is an advanced course that gives you a complete training on Microsoft Access 2010 and 2007 and teaches you how to develop Access applications in a more efficient way. This course lasts two days and allows you to perfectly master the fundamental and complementary tools of Access 2010 and 2007 databases.

Pré-requis

  • Good knowledge of the Windows environment
  • Knowledge of databases
  • Having followed the course Fundamentals of MS Access 2010 and 2007 or having equivalent knowledge

Contenu

  • Reminders on basic concepts of Access 2010 and 2007
  • Improving the structure of tables and databases
    • Database modeling
    • Multi-list and calculated fields
    • Performance analysis of the database
    • Dependent objects
  • Advanced queries
    • Introduction to the SQL language
    • Create queries for pivot tables and pivot charts
    • Create multi-join queries
    • Create advanced queries using the expression builder
  • Creating advanced forms
    • Creating a navigation form
    • Using controls and ActiveX controls (calendar)
    • Inserting sub-forms
    • Inserting calculated fields
    • Creating links between forms and customized queries
    • Using functions from the expression builder (ex: RechDom())
  • Creating advanced reports
    • Including a chart in a report
    • Selections and groups
    • Headers & Footers
  • Simplifying tasks with Macros and VBA
    • Creating a macro
    • Converting a macro in VBA
    • Initiation to VBA
    • Trigger generator
    • Database starting options
    • Security
    • Integration of data with Outlook, SharePoint or InfoPath

Langue du cours

EN

Support de cours

  • Training support in supplement

15.- CHF

Durée

2 jour(s)

Prix

1950.- CHF

Nos cours collectifs

Aucune session programmée

Conditions générales de vente