Welcome, Guest

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

You'll learn how to:

Introducing Access 2016Starting 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 FundamentalsDatabase 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 ExportingPreviewing 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.