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.