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.

This course has a minimum of 25 learner registrations for us to provide a quotation.

Request a Quotation
Language
UK
Date last updated
2/6/2020
Duration
3 Hours 17 Minutes
Suitable Devices
  • PC
  • Phone
  • Tablet
Audio is Required
  • Yes
Includes Video
  • No
Downloadable Resources
  • eBook
  • Hints and Tips
Completion Criteria
  • Multiple Choice Assessment
Pass Mark
  • 70% pass mark required
Course Technology
  • HTML5
  • SCORM 1.2
Can be customised
  • No
Accreditation or Endorsements
  • No
Languages
  • English
Image of a SkillStation dashboard

Let's get started

with a demo and a 30-day free trial.

Cookies

To provide you with the best experience, we use cookies. You can read the details on our

Privacy Policy.