Microsoft Access 2016 Training Course Intermediate

In this Microsoft Access 2016 intermediate course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports.
In this course, you will create and manage an Access 2016 database.

Course Duration: 1 Day

Course Outline

Designing a Relational Database using Microsoft Access 2016

Relational Database Design

Create a Table

Create Table Relationships

Joining Tables

Create Query Joins

Relate Data Within a Table

Work with Subdatasheets

Using Data Validation

Use Field Validation

Use Form and Record Validation

Creating Advanced Queries

Create Parameter Queries

Summarize Data

Create Subqueries

Create Action Queries

Create Unmatched and Duplicate Queries

Organising a Database for Efficiency

Data Normalization

Create a Junction Table

Improve Table Structure

Using Advanced Reporting Techniques in Access 2016

Include Control Formatting in a Report

Add a Calculated Field to a Report

Add a Subreport to an Existing Report

Intermediate Access Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

Number Students?

Laptop hire?

Offsite training?

Per Person £ *

Total Price:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

=

Please enter the answer to prove that you are human and not a machine.