This course is for individuals whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
Level 3 Advanced
What Can You Expect?
This course is for individuals whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
What Is Required from You?
To ensure success in this course, knowledge of intermediate features of Access tables, relationships, queries, forms, and reports is recommended. Learners should be competent in SAQA US ID: 117927 – Use a database application to solve a given problem, or have the equivalent knowledge.
Unit Standard Alignment
2 Day Course Content
Relationships
Create Primary Keys
Establish Multiple Field Primary Keys
Understand Table Relationships
Create One to One Relationships
Create One to Many Relationships
Create Many to Many Relationships
Enforce Referential Integrity
Edit and Delete Relationships
Manage the Relationship Window
Explore Benefits of Relationships
Advanced Queries
Use Unmatched Queries to Solve Integrity Conflicts
Create Joins in Queries
Create Parameter Queries
Use Advanced Functions in Queries:
Concatenation
If Statements
Text Functions
Date Functions
Simple SQL Syntax
Create, Implement and Edit Action Queries:
Make Table Query
Update Query
Append Query
Delete Query
Advanced Forms
Create Forms with SubForms
Insert and Edit Controls on Forms
Modify Form Properties
Create Calculate Field in Forms
Apply Form AutoFormats
Advanced Reports
Create Reports using Parameter Queries
Modify Report Properties
Create Grand Totals and Calculated Field
Print Preview and Print Reports
Other
Create, Run and Edit Macros
Use the Autoexec Macro
Create, Edit and Implement a Switchboard
Customise the Quick Access Toolbar
Define Start Up Options
Compact and Repair a Database
Understand and Explore Database Replication
Keybase Pretoria is an accredited training centre based in Moreleta Park, Pretoria East. We specialize in all Microsoft courses from Basic to Advanced as well as soft skill courses.
The purpose of this short course is to develop knowledge and basic skills using a GUI based electronic mail application.
MS Word course is offered by ExecuTrain for all skill levels. ExecuTrain has a team of fully-certified Microsoft trainers and all our Microsoft Computer skills courses are aligned to NQF standards. In addition to this, ExecuTrain’s venue is a certified Certiport assessment venue.
Successful candidates will have a fundamental understanding of the PowerPoint environment and demonstrate the correct application of PowerPoint 2016. Candidates create, edit, and enhance presentations and slideshows.
Microsoft Excel (Spreadsheets) Training Course is offered by Susca Watts Middelburg. The Academy focuses holistically on providing students with stimulating and comprehensive qualifications as well as short skills courses recognized nationally and internationally ensuring dynamic careers.
This two-day course is designed to help delegates to apply project management concepts using the Microsoft Project software. Objectives Creating the Gantt Chart and setting durations and milestones Creating links between tasks Understanding Lag & Lead times Working with Resources
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy