Microsoft Access 2016 Database Training in Cape Town - Advanced Level (Office 2016)
2KO offers Microsoft Access courses in Cape Town for three 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 Intermediate Course.
About Microsoft Access
2KO teaches students the fundamentals of Microsoft Access. We cover database basics beginning with database table structures, tables, forms, data queries and creating reports. Use Access to manipulate large data sets and quickly extract relevant data using powerful search tools. 2KO Africa offers 1 day Access 2016 courses for each level, in our state of the art training centre in central Cape Town, up the road from the V&A Waterfront. 2KO Africa is an IT consulting and training company, offering both business services and training across multiple platforms. 2KO Africa's various courses are available as full time classes, or as online e-learning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.
trained without coming to a class.
from work or home
the best IT training, from the security and safety
of your own environment
To find out more click
the button below
No Contact Training
Get trained without coming to a class.
No travel Required
Study from work or home
Enjoy the best IT training, from the security and safety of your own environment
To find out more click the button below
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.
Relational Database structure
Expert Form Design
Size and position of a Form
Modifying the record source for a form
Setting or changing the tab order on Forms
Creating an Option group using a wizard
Creating a form with sub forms using a wizard
Creating a sub form by adding a form to another form
Forms with a tab control
Forms with page breaks
Pivot Table Forms
Command buttons on a form
Make Table Queries
Query Joins and Join Properties
Types of joins
Cross tab Queries
Unmatched and Duplicates Queries
Creating a report with sub reports
Create a calculated control
Add Charts to Reports (or Forms)
E-mailing a report
Save the object using a different format
Working with Macro
Creating a macro
Running a macro
Expert Database Tools
Linked table manager
Compact and Repair
Printing from the Documenter
Analyse a Table
Analyse Database Performance
Improving the performance of an Access database
Editing data in a shared database
Database password security