Course MS Access 2010 and 2007 Advanced English

Imprimer Retour

Goal

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.

Prerequisites

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

Content

  • 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

Course Language

EN

Course material

  • Training support in supplement

Duration

2 day(s)

Our group lessons

Availability on request

General conditions of sales

If you have any difficulties with physical access or require any assistance please contact our teams.