Intermediate Access 2016 Training

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.


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


Intermediate Level


1 Day

Typical Course Content Covers:


Database Basics

Database planning
Database normalization
Relational database structure
Understanding relationships



Using relationships
Creating relationships using the Lookup Wizard
Understanding the relationships window
Creating relationships in the relationship window
Editing a relationship
Print the database relationships


Customizing Tables

Creating a new table
Customizing tables
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
Database password
Importing data
Exporting data

Working with Queries

Understanding queries
Creating select queries
Entering criteria
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
Form views
Understanding controls
Working with control layouts
Resizing controls
Formatting controls
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
Printing reports
Send the report as an e-mail message