995 850 CAD

Database Development with Access


overall satisfaction for this course

  • Duration 3 days
  • Regular fee 995 $
  • Preferential fee 850 $  ?
  • Locations
    • Montreal
  • Practical

Accreditation and partners association

  • Réseau des ingénieurs du Québec

Formation path :

Databases training paths

View path


To provide the knowledge and skills required to develop databases with Access.

Targeted audience

Programmers, analysts, designers and database administrators.


Knowledge of conceptual data modeling (Course BD101) and of Windows.

Customer Testimonials

Highly appreciated training. The trainer is an excellent popularizer and listener.

Jean D. / Conseiller planification et optimisation, Hydro-Québec

Very interesting.

Myrianne G. / Conseillère commercialisation, Hydro-Québec


  • Strengths and weaknesses of MS Access: comparison with MS SQL Server
  • Tables: modeling, structure, creating tables and fields, primary keys, relations and data validation
  • Working with data sheets: usage, formatting, sorting and filters
  • Importing and linking to external data
  • Designing and using queries: simple queries, multiple table queries, action queries, parameter queries, crosstab queries and calculated fields
  • Forms: types of forms, using the assistants, modifying forms and adding controls
  • Designing and printing reports
  • Managing the database: analysis and documentation, compacting and multi-user environment
  • A look at the other capabilities of Access: macros, security and replication

General Note

Note: Although the course is given using Access 2010, the concepts covered can be applied to Access 2007.


*Unless stated otherwise, all sessions are in French.
  • Montreal

    February 9 to February 11 2015

  • Montreal

    June 1 to June 3 2015

Trainer(s) assigned(s)

Other course(s) in this category