Access (2013/2016/2019/2021/365 Regular)

by Versalys Claim Listing

Understand the basic notions related to the construction and querying of simple databases.

$350

Contact the Institutes

Fill this form

Advertisement

Versalys Logo

img Duration

2 Days

Course Details

Understand the basic notions related to the construction and querying of simple databases.

 

Content Elements:

  • JOUR 1
  • General presentation :
  • Basic concepts;
  • Start Microsoft Access;
  • Discover the Access interface;
  • Customize the ribbon;
  • Customize the Quick Access Toolbar;
  • Import/export customizations;
  • Use the “backstage”;
  • Use Access help;
  • Access features;
  • Database objects;
  • A database project.
  • The tables :
  • Definition and usage;
  • Create a table;
  • Create fields;
  • Field properties;
  • Field masks;
  • The new fields;
  • Attachments;
  • Multiple choice;
  • Calculated fields;
  • Working with fields;
  • Working with a table;
  • Working with data from a table;
  • Import data;
  • Export data;
  • Relationships between tables.
  • JOUR 2
  • The requests :
  • Definition and usage;
  • Create a query with wizard;
  • Working with a query;
  • Relationships in queries.
  • The forms :
  • Definition and usage;
  • The notion of user interface;
  • The new page mode;
  • The new mode of creation;
  • New layout elements (stacked and tabular);
  • Organization of arranged elements;
  • The new anchors;
  • Working with forms.
  • The states :
  • Definition and usage;
  • Types of state;
  • Modes of creation;
  • Working with states.
  • Quebec City Branch

    850, Ernest-Gagnon, Building 5, office 166, Quebec City
  • Montreal Branch

    1440, rue Ste-Catherine Ouest,, Montreal

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy