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.
About Microsoft Access
2KO teaches students to stretch their Microsoft Access knowledge to a more advanced level with the Intermediate Access 2016 course in Cape Town. Our intermediate course covers more advanced database table structures, tables, forms, data queries and reports. Microsoft Access is a tool used to manipulate very large data sets to extract exact data, based on specific criteria, using powerful search tools encased within the Access framework. 2KO Africa offers 1 day Access 2016 intermediate courses in our state of the art training centre in central Cape Town, up the road from the V&A Waterfront. 2KO delivers cutting-edge IT products in the consulting and business services space, as well as offering top-rated training for various IT vendors. Our internationally recognised courses can be offered either as hands-on full time classes, or as online learning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.
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.
Typical Course Content Covers:
Correctly relating Tables
Changing Field position
More data properties
Filtering with Forms
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
Modifying existing Queries
Beginner Formula Expressions
Functions using Expression Builder
Changing design & format Report
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 Excel files
Compact & Repair a Databases