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.