Home

Go


Find a course

Search

BD103

Databases - SQL - Access - Oracle

Database Development with Access

  • Practical courses

Course and trainers' evaluations

Objectives

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

Target Audience

Programmers, analysts, designers and database administrators.

Prerequisites

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

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

Note

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


Customer Testimonials

Evaluations

% overall satisfaction for this course

89%

% Participants who would recommend this course

100%

« Very interesting. »
Myrianne G., Conseillère commercialisation, Hydro-Québec
 
Next Previous  

Trainers for this Course

  • Eric VaillancourtEric Vaillancourt More than twenty years experience in database programming and project management. Has trained nearly three thousand people since 2002.

    97% Trainer
    evaluation

    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.

    89% Trainer
    evaluation

Selected course(s)

0 Item(s) in Cart

Proceed to Registration

 
 

Wish List

0 Items on Wishlist
 
 

Course Catalog


Online : Course Catalog

PDF file : Course Catalog 4 Mb (available in French only)


 
 
   
 
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  

Accreditations


  • Project Management Institute Microsoft BDC

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