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
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
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