Technologia
Technologia
995 850 CAD
BD103

Database Development with Access

89%

overall satisfaction for this course

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

Objectives

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

Targeted audience

Programmers, analysts, designers and database administrators.

Prerequisite

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

Content

  • 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.

Dates (unless stated otherwise, all sessions are in French)

  • Montreal

    October 20 to October 22 2014

  • Montreal

    February 9 to February 11 2015

  • Montreal

    June 1 to June 3 2015

Trainer(s) assigned(s)

Other course(s) in this category