100 megs data gift for every genuine quote requested

So you’re ready to take your MS Access 2016 skills to the next level beyond simple database queries. This intermediate level course is designed to give you a deeper understanding of the powerful data mining tools available in this software.

The MS Access 2016 Intermediate Training Course provides training in setting table relationships, customising reports, create pivot tables and pivot charts, conducting self-join queries, work with orphan records and much more.

This dynamic training course is now available in Gauteng, Durban and Cape Town.

Contact us today for a group quote.

Excel

Word

PowerPoint

Outlook

Access

Project

Who Should Attend

This course is designed for people who have attended the Access Beginner course or have a comprehensive working knowledge of Access.

They should be confident in designing tables, forms queries and reports.

 

Learning Outcomes - Microsoft Access 2016 Intermediate Training

Upon successful completion of this course, participants will be able to:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organise a database for efficiency and performance, and to maintain data integrity.
  • Customise reports to organise the displayed information and produce specific print layouts.
  • Create and manage custom categories and groups in the Navigation Pane

Course Content - Microsoft Access 2016 Intermediate Training

Lesson 1: Designing a Relational Database
Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships

Lesson 2: Joining Tables
Topic A: Create Query Joins
Topic B: Relate Data Within a Table
Topic C: Work with Subdatasheets

Lesson 3: Using Data Validation
Topic A: Use Field Validation
Topic B: Use Form and Record Validation

Lesson 4: Creating Advanced Queries
Topic A: Create Parameter Queries
Topic B: Summarise Data
Topic C: Create Subqueries
Topic D: Create Action Queries
Topic E: Create Unmatched and Duplicate Queries

Lesson 5: Organising a Database for Efficiency
Topic A: Data Normalisation
Topic B: Create a Junction Table
Topic C: Improve Table Structure

Lesson 6: Using Advanced Reporting Techniques
Topic A: Include Control Formatting in a Report
Topic B: Add a Calculated Field to a Report
Topic C: Add a Subreport to an Existing Report