+ 27 (0)10 110 0296    :   +27 (0)11 803 4216     email@m-cot.com

Microsoft Access 2016 Mastering - DLS Consulting


Increasing effectiveness in developing and manipulating databases

Unit Standards

117927 - Use a Graphical User Interface (GUI)-based database application to solve a given problem.


Prior knowledge and skills to:
  • 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)
The estimated course duration may not be met should the learner not have achieved these prerequisites




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
Working with Tables
Creating a new table
Customising 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
Working with Queries
Understanding queries
Creating select queries
Understanding the Datasheet and Design query views
Entering criteria
Using the Expression builder
Summarising query values
Creating parameter queries
Creating append queries Creating delete queries
Exporting data
Creating update queries
Working with Forms
Creating new forms
Creating forms instantly
Form views
Creating forms using the Form Wizard
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
Managing the database
Compact and repair
Database password
Importing data

...download the programme in Pdf format

...back to ITC Training