About the course

The Office 365 - Access - Level 5 course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will learn how to create, design and modify controls in reports. You will also use calculated controls, use Find to locate data, sort records, and apply filters.

Modules

There are 6 modules in this course

• Using the Report Wizard
• Modifying Reports
• Creating Reports in Design View
• Using Calculated Controls
• Blank Reports and Formatting Tools
• Finding, Sorting and Filtering

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 Reports Using the Report Wizard

• Generating Reports;
• Selecting a Table or Query;
• Adding Fields to Reports;
• Grouping Report Records;
• Sort and Summary Options;
• Layout and Orientation;
• Title and Display Options;
• Creating Automatic Reports;
• Saving and Closing Reports;
• Deleting Reports.

Modifying Reports

• Previewing Reports;
• Layouts;
• Removing Layouts from Controls;
• Creating Layouts;
• Moving Layouts;
• Changing Label Text;
• Formatting Labels;
• Numeric Formatting;
• Page Header and Footer;
• Report Header and Footer;
• Adding Labels;
• Adding Images;
• Adding Subforms;
• Add/Remove Sections.

Creating Reports in Design View

• Reports;
• Creating Underlying Queries;
• Creating Reports in Design View;
• Displaying the Report Header;
• Report Headers;
• Managing Labels;
• Creating Group Headers;
• Creating Group Expressions;
• Concatenating Text Strings;
• Setting Group Properties; 
• Group Header Controls;
• Layout View;
• Running Sums;
• Adding Date/Time Fields;
• Adding Page Numbers;
• Print Preview.

Using Calculated Controls

• Underlying Query Design;
• Count Function;
• Joining Queries;
• Creating Reports;
• Suppressing Page Headers;
• Mathematical Controls;
• Percentage Controls;
• Logical Controls;
• Applying Conditional Formatting;
• Viewing Conditional Formatting.

Blank Reports and Formatting Tools

• Creating Blank Reports;
• Adding Fields;
• Resizing Controls;
• Adjusting Page Width;
• Applying Themes;
• Show/Hide Gridlines;
• Changing the Layout;
• Control Padding;
• Control Margins 
• Adding Background Images;
• Adding Background Colours;
• Using Page Setup;
• Sizing & Ordering Controls.

Finding, Sorting and Filtering

• Finding Data;
• Applying Filters;
• Sorting Data in Reports.