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
Youll 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.