Back to Courses

Microsoft Access 2016 Intermediate Training Course

Training by Computer Tutoring Ltd

Enquire Now

On-Site / Training

Inquire to Request Schedule

Inquire for Price

Enquire Book Now

RESPONSE RATE

Details
Outline
About the Provider

Book Now

Enquire

Details

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.

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

Reviews

Be the first to write a review about this course.

Write a Review

For over 13 years Computer Tutoring have trained a wide range of web design, Microsoft and Adobe courses to individuals and businesses across London and East Anglia. Approachable and experienced trainers can help you to boost your confidence and enjoy learning.

To accommodate busy companies, Computer Tutoring can tailor the training so that the maximum benefit is felt in the shortest amount of time. For instance if a company would like help on how to transform their Adobe Photoshop images for use on their website, plus they need to alter an Adobe InDesign file and ensure that it is polished ready to go to print then we can combine the two. If you are not sure then just ask. An experienced Computer Tutoring Trainer can give you a no obligation call to discuss.

Computer Tutoring has trained people from many different companies / organisations. Clients have included: Argos. Walkers. Bokomo Foods. Home-Start UK. Smurfit Kappa. John West Foods. Europa Components. Humberside Airport. The Walt Disney Company. Royal Society of Chemistry. Many testimonials are listed on the Computer Tutoring website.

View Complete Profile

Office Application & Computer System