Welcome, Guest

Office 365 - Access 2019 - Level 4

About the course

The Office 365 - Access - Level 4 course 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 Forms Creating and Using Forms

  • Forms;
  • Opening Forms;
  • Creating New Forms;
  • Using the Form Wizard;
  • Adding Fields to Forms;
  • Choosing the Form Layout;
  • Moving in Forms;
  • Form Navigation Buttons;
  • Adding New Records;
  • Entering Data in Forms;
  • Editing Data in Forms;
  • Editing Records;
  • Deleting Records;
  • Viewing Table Data.

Modifying Forms and Controls

  • Modifying Forms;
  • Form Design View;
  • Form Controls;
  • Form Design Screen;
  • Changing the Section Sizes;
  • Controls on Forms;
  • Re-sizing Text Boxes;
  • Moving Controls on Forms;
  • Selecting Multiple Controls;
  • Adding Labels to Forms;
  • Adding Existing Fields;
  • Deleting Controls;
  • Changing Label names;
  • Inserting Hyperlinks;
  • Changing the Tab Order;
  • Saving Forms;
  • Deleting Forms

Creating Navigation Forms

  • Creating Navigation Forms;
  • Editing the Header;
  • Adding Date and Time;
  • Adding Images;
  • Saving Navigation Forms;
  • Display Form as Default;
  • Navigation Options;
  • Hiding the Navigation Pane.

Form Design and Formatting

  • Blank Forms;
  • Applying Themes;
  • Changing Layouts;
  • Changing the Field Order;
  • Position Group Settings;
  • Adding Margins to Controls;
  • Adding Padding to Controls;
  • Anchoring Controls;
  • Showing Gridlines;
  • Formatting Controls;
  • Adding Background Images;
  • Saving Forms.

Adding Controls to Forms Create Combo Boxes;

  • Create Combo Boxes;
  • Modifying Control Properties;
  • Creating Option Group Controls;
  • Adding Check Boxes;
  • Modifying Data Sources;
  • Adding Unbound Controls;
  • Adding Images;
  • Deleting Bound Controls.

Sorting, Filters and Printing Sort Records;

  • Sorting Records
  • Applying Filters;
  • Filter By Selection;
  • Filter with Multiple Values;
  • Toggling Filters;
  • Print Preview Forms;
  • Changing Page Orientation;
  • Formatting the Print Layout;
  • Changing Page Margins;
  • Changing the Paper Size.