Keep compliant with our newly updated RoSPA assured Health and Safety courses

Microsoft Access 2016: Intermediate

Previous
Microsoft_Access_2016_Intermediate
Intermediate screenshot
Ms Access advanced screenshot
MS access intro
Next
Microsoft_Access_2016_Intermediate

Course Overview

Format

  • Intermediate
  • 11-12 Study Hours
  • Online Study
  • Self-Printed Certificate

Accreditation

  • Online Interactive Course
  • Virtual College Endorsed

Course description

Become more familiar with Microsoft Access and the various tools and features that are available to use with our online course.

In the course Microsoft Access 2016: Intermediate, you will learn to create calculated fields in queries that operate with functions.

You will create totals queries and parameter queriesnand will familiarise yourself with the properties of table joins and will examine how they can affect the result of queries.

You will create forms in the Design view and will learn to insert calculated fields into them and will also design and edit reports and will learn to perform various calculations in them.

You will also learn how to insert controls into forms and reports, including subforms and subreports.

You will learn

  • Parameter query
  • Join properties in queries
  • Creating manual joins in queries
  • Expressions in queries
  • Use of functions in more complex expressions
  • Advanced setting of table fields properties
  • Totals
  • Aggregate queries
  • Crosstab query
  • Sorting and filtering data in forms
  • Design View of forms
  • Form creation in the Design View
  • Editing a form
  • Editing form controls
  • Calculated form fields and conditional formatting
  • Combo box in forms
  • Option buttons in forms
  • Tab order of form controls
  • Form with a subform
  • Subform insertion in the Design view
  • Restricting data editing in forms
  • Grouping and summarising data in reports
  • Editing created reports
  • Advanced report options
  • Setting reports before printing them

Who is it for?

Roles including:

  • Office computer user
  • Those wanting to develop Microsoft Access skills and knowledge
  • Job Seekers
  • Those working with computers
  • Those using Microsoft Access at work, home or in education

How the online courses work