About the course

The Office 365 - Access – 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
• 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

You'll learn how to:

Introducing Access 2019
Starting Access

• Databases;
• Starting Access;
• Previewing Templates;
• Creating Blank Databases;
• Quitting Access.

Screen Components

• Access Screen Components;
• Status Bar;
• Taskbar;
• Navigation Pane;
• Opening Database Objects;
• Backstage View;
• Pin to List;
• Ribbons;
• Dialog Box Launchers;
• Task Panes;
• Contextual Tabs;
• Quick Access Toolbar.

Database Fundamentals
Database Basics

• Databases;
• Opening Database Objects;
• Tables;
• Viewing Tables;
• Data Types for Fields;
• Indexing Fields;
• Primary Key Fields;
• Table Relationships;
• Referential Integrity;
• Queries;
• Forms;
• Viewing Forms;
• Reports;
• Viewing Reports

Using Templates

• Access Templates
• Searching for Templates;
• Keyword Searches;
• Previewing Templates;
• Creating Databases;
• Database Objects;
• Entering Data into Tables;
• Deleting Databases.

Printing and Exporting
Previewing and Printing

• Previewing Datasheets;
• Printing Datasheets;
• Printing Subdatasheets;
• Printing Selected Records;
• Previewing Reports;
• Changing the Page Setup;
• Printing Reports;
• Printing Query Output;
• Printing Forms

Exporting Data

• Exporting Database Objects;
• Export Options;
• Exporting to Access Database;
• Exporting to Excel;
• Saving Exported Files;
• Exporting Data in XML Format;
• Exporting Data in PDF Format;
• Exporting Data as Text Files;
• Viewing Exported Files.