Technologia
Technologia
995 850 CAD

This training course is no longer available.

Please return to Databases category or contact our customer service for more details.

BD103

Database Development with Access

89%
293

overall satisfaction for this course

?
  • Duration 3 days
  • Regular fee 995 $
  • Preferential fee 850 $  ?
  • Locations
  • Laboratory
    course

Accreditation and partners association

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

Formation path :

Databases training paths

View path
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

Mr Bourgeois is very dynamic and transfer his knowledge very well.

Caroline P. / Adjointe-juricomptable As_01, Travaux publics et Services gouvernementaux Canada

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.

Are you interested by this training course ?

Enter your email to be informed of upcoming dates for this training course.

Invalid email address

Trainer(s) assigned(s)

Other course(s) in this category