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

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

Level
Intermediate Level

 

Duration
1 Day


Typical Course Content Covers:

 

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


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

Queries
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

Reports
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

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