KNOWHOW2 maximise your return on investment for each course by designing it so its serves both initial training and post training needs. If you are new to a subject you are taken step-by-step through each lesson building your knowledge in a simple but informative way. For more experienced users, you can access the courses like a reference tool by utilising the "just-in-time" training features which allow you to jump directly to specific topics of interest. Read more...

Other Courses From This Provider

Access 2019 - Level 5 - Designing Reports

Access 2019 - Level 5 - Designing Reports
 0 (0)
$18.00 per seat

Buy Now

About the course

The Access 2019 - Designing Reports 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.


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.