Intermediate Microsoft Access 2016 in Cape Town
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 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 International delivers consulting services, in the IT and Business space, as well as being a training provider for IT certification and user level courses. Training can be any blend of bespoke, classroom and online 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
117927 - Use a Graphical User Interface (GUI)-based database application to solve a given problem.
Mathematical literacy and communication skills at least at NQF level 3.
Use generic functions in a Graphical User Interface (GUI)-environment (ID 117902 - NQF level 1).
Use a Graphical User Interface (GUI)-based database application to work with simple databases (ID 116936 - NQF level 3).
Typical Course Content Covers:
Relational database structure
Creating relationships using the Lookup Wizard
Understanding the relationships window
Creating relationships in the relationship window
Editing a relationship
Print the database relationships
Creating a new table
Changing data type
Using the data type gallery
Setting field properties
Setting the field size property
Setting the format property
Creating custom formats
Using input masks
Setting validation rules
Setting the Indexed Property
Setting the primary key
Working with the Lookup property window
Managing the database
Compact and repair
Working with Queries
Creating select queries
Using the Expression builder
Summarizing query values
Creating parameter queries
Creating append queries
Creating delete queries
Creating update queries
Working with Forms
Creating new forms
Working with control layouts
Understanding the property sheet
Sections in the Design view
Creating calculated controls
Creating summary calculations on a form
Creating a combo box on a form
Setting the tab order on a form
Applying conditional formatting on controls
Working with Reports
Creating new reports
Working with Report views
Modifying a report design
Print preview reports
Send the report as an e-mail message