Intermediate Access 2016 Training

Intermediate Microsoft Access 2016 in Cape Town


2KO offers Microsoft Access courses in Cape Town for two levels of difficulty. If you are not sure which level you ought to begin with, click here for the content of the MS Access 2016 Beginners Course.


Intermediate Level


SAQA Unit Standards
258875 - Design forms and reports using a Graphic User Interface (GUI) based database (Level 4) Credits 4 258881 - Design complex tables and queries using a graphical user interface (GUI) based database to solve a given problem (Level 4) Credits 5

Prior knowledge and skills to:
Mathematical Literacy at NQF Level 3.
Communication at NQF Level 3.
Knowledge of GUI based database application.

Intermediate Level


1 Day

Typical Course Content Covers:


Correctly relating Tables
Linking Tables
Changing Field position
More data properties
Freezing/unfreezing Columns
Spellchecking/proofreading data

Filtering with Forms
Combo Boxes
Command Buttons
Distributing & Aligning Fields evenly
Basic formatting of Controls
Stacking & Layouts

Grouping records in a Query
The Summarising and Total Fields
Formulas in Queries
Date range Queries
Formatting Fields
Modifying existing Queries
Beginner Formula Expressions
Functions using Expression Builder

Changing design & format Report
Changing orientation
Consolidating formatting commands
Creating professional Reports with Logos
Adding Page headers & footers
Adding Report headers & footers
Managing space to enable Printing

Sort multiple Database Fields
Reversing & removing a Sort
Creating a built-in template Database
Importing Data
Importing Excel files
Compact & Repair a Databases