Please click here to chat with a certified trainer
Access courses logo

 

MS Access courses

 


 

 

  • Access Level 1 Course
  • Access Level 2 Course
  • Access Level 3 Course

Course Date  City Course Times    Cost  
December        
19 Dec Port Elizabeth 0830 - 1600    R2350 Book
January        
15 Jan Pretoria 0830 - 1600    R2350 Book
29 Jan Midrand 0830 - 1600    R2350 Book
29 Jan Sandton 0830 - 1600    R2350 Book
February        
12 Feb Pretoria 0830 - 1600    R2350 Book
26 Feb Midrand 0830 - 1600    R2350 Book
26 Feb Sandton 0830 - 1600    R2350 Book
March        
12 Mar Pretoria 0830 - 1600    R2350 Book
April        
09 Apr Midrand 0830 - 1600    R2350 Book
09 Apr Sandton 0830 - 1600    R2350 Book
May        
07 May Pretoria 0830 - 1600    R2350 Book
21 May Midrand 0830 - 1600    R2350 Book
21 May Sandton 0830 - 1600    R2350 Book
June        
04 Jun Pretoria 0830 - 1600    R2350 Book
18 Jun Midrand 0830 - 1600    R2350 Book
18 Jun Sandton 0830 - 1600    R2350 Book
July        
16 Jul Midrand 0830 - 1600    R2350 Book
16 Jul Sandton 0830 - 1600    R2350 Book
August        
13 Aug Midrand 0830 - 1600    R2350 Book
13 Aug Sandton 0830 - 1600    R2350 Book
27 Aug Pretoria 0830 - 1600    R2350 Book
September        
10 Sep Midrand 0830 - 1600    R2350 Book
10 Sep Sandton 0830 - 1600    R2350 Book

Course Date  City Course Times    Cost  
 
29 Jan Midrand 0830 - 1600    R2350 Book
26 Feb Midrand 0830 - 1600    R2350 Book
09 Apr Midrand 0830 - 1600    R2350 Book
21 May Midrand 0830 - 1600    R2350 Book
18 Jun Midrand 0830 - 1600    R2350 Book
16 Jul Midrand 0830 - 1600    R2350 Book
13 Aug Midrand 0830 - 1600    R2350 Book
10 Sep Midrand 0830 - 1600    R2350 Book
 
19 Dec Port Elizabeth 0830 - 1600    R2350 Book
 
15 Jan Pretoria 0830 - 1600    R2350 Book
12 Feb Pretoria 0830 - 1600    R2350 Book
12 Mar Pretoria 0830 - 1600    R2350 Book
07 May Pretoria 0830 - 1600    R2350 Book
04 Jun Pretoria 0830 - 1600    R2350 Book
27 Aug Pretoria 0830 - 1600    R2350 Book
 
29 Jan Sandton 0830 - 1600    R2350 Book
26 Feb Sandton 0830 - 1600    R2350 Book
09 Apr Sandton 0830 - 1600    R2350 Book
21 May Sandton 0830 - 1600    R2350 Book
18 Jun Sandton 0830 - 1600    R2350 Book
16 Jul Sandton 0830 - 1600    R2350 Book
13 Aug Sandton 0830 - 1600    R2350 Book
10 Sep Sandton 0830 - 1600    R2350 Book

Access Level 1 Course

Course Description

Microsoft Office Access Beginners will assist organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing date is by using relational databases. Information can be sorted, linked and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various object using the Microsoft Office Access relational database application.

 

Prerequisites

Good working knowledge of the Windows Operating System

Access Level 1 Course

Download PDF

Simple Database Techniques

1. Explore an Access 2010 Database

  • Working in Access 2010
  • Understanding Database Concepts
  • Exploring Tables
  • Exploring Forms
  • Exploring queries
  • Exploring Reports
  • Previewing and Printing Access Objects

 

2. Create Database and Simple Tables

  • Creating Databases from Templates
  • Creating Databases and Tables manually
  • Manipulating Table Columns and Rows
  • Refining Table Structure
  • Creating Relationships Between Tables

 

3. Create Simple Forms

  • Creating Forms by Using the Form Tool
  • Changing the Look of Forms
  • Changing the Arrangement of Forms

 

4. Display Data

  • Sorting Information in Tables
  • Filtering Information in Tables
  • Filtering Information by Using Forms
  • Locating Information That Matches Multiple Criteria

 

5. Create Simple Reports

  • Creating Reports by Using a Wizard
  • Modifying Report Design
  • Previewing and Printing Reports

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

Course schedule subject to change without notice

Course Date  City Course Times    Cost  
December        
18 Dec Port Elizabeth 0830 - 1600    R2500 Book
21 Dec Cape Town 0830 - 1600    R2500 Book
January        
16 Jan Pretoria 0830 - 1600    R2500 Book
30 Jan Midrand 0830 - 1600    R2500 Book
30 Jan Sandton 0830 - 1600    R2500 Book
February        
13 Feb Pretoria 0830 - 1600    R2500 Book
27 Feb Midrand 0830 - 1600    R2500 Book
27 Feb Sandton 0830 - 1600    R2500 Book
March        
13 Mar Pretoria 0830 - 1600    R2500 Book
13 Mar Pretoria 0830 - 1600    R2500 Book
April        
10 Apr Midrand 0830 - 1600    R2500 Book
10 Apr Sandton 0830 - 1600    R2500 Book
May        
08 May Pretoria 0830 - 1600    R2500 Book
22 May Midrand 0830 - 1600    R2500 Book
22 May Sandton 0830 - 1600    R2500 Book
June        
05 Jun Pretoria 0830 - 1600    R2500 Book
19 Jun Midrand 0830 - 1600    R2500 Book
19 Jun Sandton 0830 - 1600    R2500 Book
July        
03 Jul Pretoria 0830 - 1600    R2500 Book
17 Jul Midrand 0830 - 1600    R2500 Book
17 Jul Sandton 0830 - 1600    R2500 Book
31 Jul Pretoria 0830 - 1600    R2500 Book
August        
14 Aug Midrand 0830 - 1600    R2500 Book
14 Aug Sandton 0830 - 1600    R2500 Book
28 Aug Pretoria 0830 - 1600    R2500 Book
September        
11 Sep Midrand 0830 - 1600    R2500 Book
11 Sep Sandton 0830 - 1600    R2500 Book

Course Date  City Course Times    Cost  
 
21 Dec Cape Town 0830 - 1600    R2500 Book
 
30 Jan Midrand 0830 - 1600    R2500 Book
27 Feb Midrand 0830 - 1600    R2500 Book
10 Apr Midrand 0830 - 1600    R2500 Book
22 May Midrand 0830 - 1600    R2500 Book
19 Jun Midrand 0830 - 1600    R2500 Book
17 Jul Midrand 0830 - 1600    R2500 Book
14 Aug Midrand 0830 - 1600    R2500 Book
11 Sep Midrand 0830 - 1600    R2500 Book
 
18 Dec Port Elizabeth 0830 - 1600    R2500 Book
 
16 Jan Pretoria 0830 - 1600    R2500 Book
13 Feb Pretoria 0830 - 1600    R2500 Book
13 Mar Pretoria 0830 - 1600    R2500 Book
13 Mar Pretoria 0830 - 1600    R2500 Book
08 May Pretoria 0830 - 1600    R2500 Book
05 Jun Pretoria 0830 - 1600    R2500 Book
03 Jul Pretoria 0830 - 1600    R2500 Book
31 Jul Pretoria 0830 - 1600    R2500 Book
28 Aug Pretoria 0830 - 1600    R2500 Book
 
30 Jan Sandton 0830 - 1600    R2500 Book
27 Feb Sandton 0830 - 1600    R2500 Book
10 Apr Sandton 0830 - 1600    R2500 Book
22 May Sandton 0830 - 1600    R2500 Book
19 Jun Sandton 0830 - 1600    R2500 Book
17 Jul Sandton 0830 - 1600    R2500 Book
14 Aug Sandton 0830 - 1600    R2500 Book
11 Sep Sandton 0830 - 1600    R2500 Book

Access Level 2 Course

Course Description

Microsoft Office Access Intermediate will provide the basic skills needed to work with Microsoft Office Access database, including creating and working with Access tables, relationships, queries, forms and reports. But so far you have been focusing only on essentials database user skills. In this course, you will consider how to maintain data consistency, how to customize database components and how to share Access data with other applications.

 

Prerequisites

Microsoft Office Access: Beginners training or equivalent working knowledge

Access Level 2 Course

Download PDF

Relational Database Techniques

1. Maintain Data Integrity

  • Restricting the Type of Data
  • Restricting the Amount of Data
  • Restricting the Format of Data
  • Restricting Data by Using Validating Rules
  • Restricting Data to Values in Lists
  • Restricting Data to Values in Other Tables

 

2. Create Custom Forms

  • Modifying Forms Created by Using a Wizard
  • Adding Controls
  • Adding Subforms
  • Using E-Mail forms to Collect Data

 

3. Create Queries

  • Creating Queries by Using a Wizard
  • Creating Queries Manually
  • Using Queries to Summarize Data
  • Using Queries to Perform Calculations
  • Using Queries to Updated Records
  • Using Queries to Delete Records

 

4. Create Custom Reports

  • Creating Reports Manually
  • Modifying Report Content
  • Adding Sub-reports

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

Course schedule subject to change without notice

Course Date  City Course Times    Cost  
December        
15 Dec Cape Town 0830 - 1600    R2700 Book
January        
17 Jan Pretoria 0830 - 1600    R2700 Book
31 Jan Midrand 0830 - 1600    R2700 Book
31 Jan Sandton 0830 - 1600    R2700 Book
February        
14 Feb Pretoria 0830 - 1600    R2700 Book
28 Feb Midrand 0830 - 1600    R2700 Book
28 Feb Sandton 0830 - 1600    R2700 Book
March        
14 Mar Pretoria 0830 - 1600    R2700 Book
April        
11 Apr Midrand 0830 - 1600    R2700 Book
11 Apr Sandton 0830 - 1600    R2700 Book
May        
09 May Pretoria 0830 - 1600    R2700 Book
23 May Midrand 0830 - 1600    R2700 Book
23 May Sandton 0830 - 1600    R2700 Book
June        
06 Jun Pretoria 0830 - 1600    R2700 Book
20 Jun Midrand 0830 - 1600    R2700 Book
20 Jun Sandton 0830 - 1600    R2700 Book
July        
04 Jul Pretoria 0830 - 1600    R2700 Book
18 Jul Midrand 0830 - 1600    R2700 Book
18 Jul Sandton 0830 - 1600    R2700 Book
August        
01 Aug Pretoria 0830 - 1600    R2700 Book
15 Aug Midrand 0830 - 1600    R2700 Book
15 Aug Sandton 0830 - 1600    R2700 Book
29 Aug Pretoria 0830 - 1600    R2700 Book
September        
12 Sep Midrand 0830 - 1600    R2700 Book
12 Sep Sandton 0830 - 1600    R2700 Book
October        
03 Oct Pretoria 0830 - 1600    R2700 Book
31 Oct Pretoria 0830 - 1600    R2700 Book


Course Date  City Course Times    Cost  
 
15 Dec Cape Town 0830 - 1600    R2700 Book
 
31 Jan Midrand 0830 - 1600    R2700 Book
28 Feb Midrand 0830 - 1600    R2700 Book
11 Apr Midrand 0830 - 1600    R2700 Book
23 May Midrand 0830 - 1600    R2700 Book
20 Jun Midrand 0830 - 1600    R2700 Book
18 Jul Midrand 0830 - 1600    R2700 Book
15 Aug Midrand 0830 - 1600    R2700 Book
12 Sep Midrand 0830 - 1600    R2700 Book
 
17 Jan Pretoria 0830 - 1600    R2700 Book
14 Feb Pretoria 0830 - 1600    R2700 Book
14 Mar Pretoria 0830 - 1600    R2700 Book
09 May Pretoria 0830 - 1600    R2700 Book
06 Jun Pretoria 0830 - 1600    R2700 Book
04 Jul Pretoria 0830 - 1600    R2700 Book
01 Aug Pretoria 0830 - 1600    R2700 Book
29 Aug Pretoria 0830 - 1600    R2700 Book
03 Oct Pretoria 0830 - 1600    R2700 Book
31 Oct Pretoria 0830 - 1600    R2700 Book
 
31 Jan Sandton 0830 - 1600    R2700 Book
28 Feb Sandton 0830 - 1600    R2700 Book
11 Apr Sandton 0830 - 1600    R2700 Book
23 May Sandton 0830 - 1600    R2700 Book
20 Jun Sandton 0830 - 1600    R2700 Book
18 Jul Sandton 0830 - 1600    R2700 Book
15 Aug Sandton 0830 - 1600    R2700 Book
12 Sep Sandton 0830 - 1600    R2700 Book

Access Level 3 Course

Course Description

Microsoft Office Access has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access . You have worked with the various Access objects, such as tables, queries, forms and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database.

 

Prerequisites

Microsoft Office Access: Beginners and Microsoft Office Access: Intermediate training or equivalent working knowledge

Access Level 3 Course

Download PDF

Database Management and Security

1. Import and Export Data

  • Importing Information
  • Exporting Information
  • Copying o and from Other Office Programs

 

2. Make Database User Friendly

  • Creating Navigation Forms
  • Creating Custom Categories
  • Controlling which Features are Available

 

3. Project Database

  • Assigning Passwords to Database
  • Splitting Databases
  • Securing Databases for Distribution
  • Preventing Database Problems

 

4. Customize Access

  • Changing Defaults Program Options
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

Course schedule subject to change without notice