For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Office 365 - Access 2016 - Level 4

About the course

The Office 365 - Access 2016 - Level 4 covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will learn how to create and design forms by adding controls. You will also use navigation forms, sort records, apply filters, and set printing options.

Modules

There are 6 modules in this course

  • Creating and Using Forms
  • Modifying Forms and Controls
  • Creating Navigation Forms
  • Form Design and Formatting
  • Adding Controls to Forms
  • Sorting, Filters and Printing

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:

Creating and Designing FormsCreating and Using Forms

  • Open Forms;
  • Create New Forms;
  • Add Fields to Forms;
  • Choose the Form Layout;
  • Navigate Forms;
  • Add New Records;
  • Enter and Modify Data;
  • Delete Records;
  • View Table Data

Modifying Forms and Controls

  • Use Form Design Tools;
  • Adjust the Size of Sections;
  • Work with Controls in Forms;
  • Change Label Names;
  • Add Existing Fields;
  • Insert Hyperlinks;
  • Change the Tab Order;
  • Save and Close Forms;
  • Delete Forms.

Creating Navigation Forms

  • Create Navigation Forms;
  • Edit the Header;
  • Add the Date and Time;
  • Add Images;
  • Save Navigation Forms;
  • Display Form as Default;
  • Modify Navigation Options;
  • Hide the Navigation Pane.

Form Design and Formatting

  • Create Blank Forms;
  • Apply Themes;
  • Change Layouts;
  • Change the Field Order;
  • Add Margins to Controls;
  • Add Padding to Controls
  • Show and Hide Gridlines;
  • Format Controls;
  • Add Background Images.

Adding Controls to Forms

  • Create Combo Boxes;
  • Create List Boxes;
  • Modify Control Properties;
  • Create Option Group Controls;
  • Add Check Boxes;
  • Modify Data Sources;
  • Add Unbound Controls;
  • Add Images;
  • Delete Bound Controls.

Sorting, Filters and Printing

  • Sort Records;
  • Apply Filters;
  • Filter By Selection;
  • Apply Multiple Criteria;
  • Toggle Filters;
  • Print Preview Forms;
  • Change Page Orientation;
  • Adjust Margins;
  • Change the Paper Size.