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

Global Knowledge Logo

Microsoft Visio 2016

Learn how to use the core features of Visio 2016 to create and manipulate various business drawings, such as flowcharts, process diagrams, and organizational charts.

by Global Knowledge [Claim Listing ]
ES Computer Training Logo

Microsoft Publisher

All of the necessary learning tools are provided, including class notes, computers, and software. All we require is a meeting room. Our unique training style will ensure no topic is unexplored, no question remains unanswered, and all participants exit the course more knowledgeable than they entered...

by ES Computer Training [Claim Listing ]
Office Instructor Logo

Microsoft Office Specialist

Microsoft Office Specialist (MOS) 2016 provides industry-leading assessments of skills and knowledge through our new project-based testing, giving students and professionals real-world exercises to appraise their understanding of Microsoft Office.

by Office Instructor [Claim Listing ]
Academy of Learning Logo

Microsoft Excel (Level 1)

In this course, students learn to create and manage Excel worksheets and workbook files, enter data, and create basic formulas to perform calculations. They learn to format cell content, view and format work-sheets, and practice preparing, previewing, and printing workbooks.

by Academy of Learning [Claim Listing ]
(BTT) Business And Technical Training College Logo

Microsoft PowerPoint

Organizations use Microsoft PowerPoint to design presentations that include slide shows, animation, sounds, and video. At BTT College, we provide two different levels of Microsoft PowerPoint.

by (BTT) Business And Technical Training College

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