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

Check out more MS Access courses in Canada

ETS Formation Logo

Become Efficient With Excel

Effectively use formatting techniques to present data in an Excel spreadsheet. Focus on presenting beautiful spreadsheets.

by ETS Formation [Claim Listing ]
Mohawk College Logo

Excel 101 Workshop (INFO10255)

Learn a variety of Excel features through this half-day workshop. The user will be introduced to pivot tables and pivot charts, lookup functions, auto outlines, subtotals, scenarios, financial functions, filters, and advanced tips and tricks.

by Mohawk College [Claim Listing ]
Office Instructor Logo

Microsoft Power Point

Learn how to use the vast array of features and functionality contained within PowerPoint to create engaging, dynamic, multimedia presentations. Gain the skills you need to organize your content, enhance it with high-impact tables, charts, and graphics, and deliver it with a punch.

by Office Instructor [Claim Listing ]
CIMT College Logo

Microsoft Access

The course covers from basic to advance functions and features of Access. Students will learn how to design and create databases; work with tables, fields and records; sort and filter data; and create queries, data entry forms, multilevel reports, and multi-table queries.

by CIMT College [Claim Listing ]
Learning Tree International Logo

Microsoft Excel Training (Intro)

Introduction to Microsoft Excel training empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers.

by Learning Tree International [Claim Listing ]

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