Access 2013/2016/2019/2021/365 Beginner Regular AC-020

Course Overview

Understanding the basic notions that are necessary to create a simple database and basic queries.

Prerequisites

Microsoft Access 2013 Beginner.

Syllabus

Overview:

  • Basic concepts;
  • Launching Microsoft Access;
  • Exploring the Access user interface;
  • Customizing the Ribbon;
  • Customizing the Quick Access toolbar;
  • Importing and exporting customizations;
  • Using the “Backstage”;
  • Using the help features in Access;
  • The properties of Access Objects inside a database;
  • A database project.

Tables:

  • Definition and use;
  • Creating a table;
  • Creating database fields;
  • The field properties;
  • Input masks for fields;
  • The new fields;
  • Attachments;
  • Multiple choices;
  • Calculated fields;
  • Working with fields;
  • Working with a table;
  • Working with the data contained in a table;
  • Importing data;
  • Exporting data;
  • Relationships between tables.

Queries:

  • Definition and use;
  • Creating a query using the wizard;
  • Working with queries;
  • The relationships in queries.

Forms:

  • Definition and use;
  • The user interface concept;
  • The new page mode;
  • The new design mode;
  • The new layout elements (stacked and tabular);
  • Organizing elements;The new anchors;
  • Working with forms.

Reports:

  • Definition and use;
  • Types of reports;
  • The design modes;
  • Working with reports.
Duration : 2 Days
Regular Rate : 350.00 $
Preferential Rate : 297.50 $
Note :

Upcoming Dates

qty

Quebec

19 to 20 December 2024 from 9:00 to 16:00

Virtual Class

19 to 20 December 2024 from 9:00 to 16:00

Virtual Class

20 to 21 February 2025 from 9:00 to 16:00

Virtual Class

6 to 7 March 2025 from 9:00 to 16:00

Laval

3 to 4 April 2025 from 9:00 to 16:00

Virtual Class

3 to 4 April 2025 from 9:00 to 16:00

Montreal

8 to 9 May 2025 from 9:00 to 16:00

Virtual Class

8 to 9 May 2025 from 9:00 to 16:00

Quebec

12 to 13 June 2025 from 9:00 to 16:00

Virtual Class

12 to 13 June 2025 from 9:00 to 16:00

Virtual Class

14 to 15 August 2025 from 9:00 to 16:00