Find a course



Databases - SQL - MySQL - OLAP - Access - Oracle

Database Development with Access

  • Practical courses

Course and trainers' evaluations


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

Target Audience

Programmers, analysts, designers and database administrators.


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


  • 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


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

Customer Testimonials


% overall satisfaction for this course


% Participants who would recommend this course


« Highly appreciated training. The trainer is an excellent popularizer and listener. »
Jean D., Conseiller planification et optimisation, Hydro-Québec
Next Previous  

Trainers for this Course

  • Eric VaillancourtEric Vaillancourt More than twenty five years experience in database programming and project management. Has trained more than 4500 people since 2002.

    97% Trainer

    Andrew EdwardsAndrew Edwards Andrew has over 20 years’ experience as a computer solutions designer. He has worked as a consultant, team leader, director of development, trainer and has specialized in computer standards design and integration.

    93% Trainer

Selected course(s)

0 Item(s) in Cart

Proceed to Registration


Wish List

0 Items on Wishlist

Course Catalog

Online : Course Catalog

PDF : Course Catalog (4 Mo)

Next Previous  

Partner Associations

  • Chartered Professional Accountants Information Technology Infrastructure Library Project Management Institute
  • Quebec Association of IT Freelancers Réseau des ingénieurs du Québec
Next Previous  


  • Project Management Institute Microsoft BDC

Technologia : Know more. Worth more 440 René-Lévesque West Blvd,
5th Floor, Montreal (Quebec) H2Z 1V7