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 Forms
Creating 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.