Office 365 - Access 2016 - Level 1

About the course

The Office 365 - Access 2016 – Level 1 course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will learn about database fundamentals, screen components and templates. You will also preview and print database objects and export data to other file formats.

Modules

There are 6 modules in this course

• Starting Access and Help
• Screen Components
• Database Basics
• Using Templates
• Previewing and Printing
• Exporting Data

Course features

• Simulation training replicates the software you are learning providing a realistic learning experience.
• Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions.
• Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.
• Assess your skills at any time by undertaking the Course Test.
• Lessons can be completed within 30 minutes so training can be undertaken in “bite” size pieces.
• Bookmarking allows you to learn in multiple training sessions.
• Course navigation features allow you to jump directly to specific topics of interest quickly and easily.
• Designed for people who require initial and refresher training activities.
• Available on-line 24 hours a day.
• Version for Mobile Devices.
• Review course content with eBooks

Youll learn how to:

Introducing Access 2016
Starting Access and Help

• Understand Databases;
• Start Access;
• Preview Templates;
• Create a Blank Database;
• Navigate Help;
• Use Help Tools;
• Search Online Help;
• Quit Access.

Screen Components

• Identify Screen Components;
• List Database Objects;
• Open Database Objects;
• Open Backstage View;
• Pin Databases to the List;
• Understand Ribbons;
• Use Dialog Box Launchers;
• Open Task Panes;
• Modify the Quick Access Toolbar.

Database Fundamentals
Database Basics

• Open and View Tables;
• Set Data Types;
• Use Primary Keys;
• Index Fields;
• Utilise Table Relationships;
• Understand Referential Integrity;
• Open Queries;
• Open and View Forms;
• Open and View Reports.

Using Templates

• Search for Templates;
• Apply Filters;
• Remove Filters;
• Perform Keyword Searches;
• Preview Templates;
• Create Databases;
• View Database Objects;
• Enter Data in Tables;
• Delete Databases.

Printing and Exporting
Previewing and Printing

• Preview Datasheets;
• Print Datasheets;
• Print Subdatasheets;
• Print Selected Records;
• Preview Reports;
• Change the Page Setup;
• Print Reports;
• Print Query Output;
• Print Forms.

Exporting Data

• Export Database Objects;
• Use Export Options;
• Export to Access Database;
• Export to Excel;
• Save Exported Files;
• Export to XML;
• Export to PDF;
• Export to Text File;
• View Exported Files.