Access courses logo

 

Microsoft Access courses
in Stellenbosch

 


 


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


Sorry, we currently do not have any public courses scheduled for the Access level 1 course in Stellenbosch. Please contact us to see if we can put one on the schedule for you

 


We offer all of these courses in Stellenbosch.

Access training courses in Stellenbosch
Excel training courses in Stellenbosch
Outlook training courses in Stellenbosch
Powerpoint training courses in Stellenbosch
Project training courses in Stellenbosch
Publisher training courses in Stellenbosch
Sharepoint training courses in Stellenbosch
SQL Server training courses in Stellenbosch
Visio training courses in Stellenbosch
Word training courses in Stellenbosch
HTML training courses in Stellenbosch
PHP training courses in Stellenbosch
Java training courses in Stellenbosch
JavaScript training courses in Stellenbosch
SQL training courses in Stellenbosch

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

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 Date  City Course Times    Cost  
 
28 Jun Bloemfontein 0830 - 1600    R2950 Book
26 Jul Bloemfontein 0830 - 1600    R2950 Book
23 Aug Bloemfontein 0830 - 1600    R2950 Book
27 Sep Bloemfontein 0830 - 1600    R2950 Book
25 Oct Bloemfontein 0830 - 1600    R2950 Book
15 Nov Bloemfontein 0830 - 1600    R2950 Book
13 Dec Bloemfontein 0830 - 1600    R2950 Book
 
10 Jul Cape Town 0830 - 1600    R2950 Book
07 Aug Cape Town 0830 - 1600    R2950 Book
09 Sep Cape Town 0830 - 1600    R2950 Book
08 Oct Cape Town 0830 - 1600    R2950 Book
04 Nov Cape Town 0830 - 1600    R2950 Book
02 Dec Cape Town 0830 - 1600    R2950 Book
 
25 Jun Durban 0830 - 1600    R2950 Book
19 Jul Durban 0830 - 1600    R2950 Book
20 Aug Durban 0830 - 1600    R2950 Book
 
26 Jul Fourways 0830 - 1600    R2950 Book
06 Sep Fourways 0830 - 1600    R2950 Book
08 Nov Fourways 0830 - 1600    R2950 Book
 
24 Jun Midrand 0830 - 1600    R2950 Book
22 Jul Midrand 0830 - 1600    R2950 Book
26 Aug Midrand 0830 - 1600    R2950 Book
30 Sep Midrand 0830 - 1600    R2950 Book
28 Oct Midrand 0830 - 1600    R2950 Book
25 Nov Midrand 0830 - 1600    R2950 Book
 
24 Jul Port Elizabeth 0830 - 1600    R2950 Book
18 Sep Port Elizabeth 0830 - 1600    R2950 Book
13 Nov Port Elizabeth 0830 - 1600    R2950 Book
 
08 Jul Pretoria 0830 - 1600    R2950 Book
12 Aug Pretoria 0830 - 1600    R2950 Book
09 Sep Pretoria 0830 - 1600    R2950 Book
14 Oct Pretoria 0830 - 1600    R2950 Book
11 Nov Pretoria 0830 - 1600    R2950 Book


Sorry, we currently do not have any public courses scheduled for the Access level 2 course in Stellenbosch. Please contact us to see if we can put one on the schedule for you

 

 


We offer these courses in Stellenbosch.

Access training courses in Stellenbosch
Acrobat training courses in Stellenbosch
After Effects training courses in Stellenbosch
Captivate training courses in Stellenbosch
Dreamweaver training courses in Stellenbosch
Excel training courses in Stellenbosch
Final Cut Pro training courses in Stellenbosch
Flash training courses in Stellenbosch
Illustrator training courses in Stellenbosch
InDesign training courses in Stellenbosch
Motion training courses in Stellenbosch
Outlook training courses in Stellenbosch
Photoshop training courses in Stellenbosch
PowerPoint training courses in Stellenbosch
Premiere training courses in Stellenbosch
Project training courses in Stellenbosch
QuarkXpress training courses in Stellenbosch
SQL Server training courses in Stellenbosch
Word training courses in Stellenbosch

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

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 Date  City Course Times    Cost  
 
22 Aug Bloemfontein 0830 - 1600    R3200 Book
14 Oct Bloemfontein 0830 - 1600    R3200 Book
09 Dec Bloemfontein 0830 - 1600    R3200 Book
 
09 Jul Cape Town 0830 - 1600    R3200 Book
15 Aug Cape Town 0830 - 1600    R3200 Book
17 Sep Cape Town 0830 - 1600    R3200 Book
11 Oct Cape Town 0830 - 1600    R3200 Book
 
25 Jun Durban 0830 - 1600    R3200 Book
28 Jun Durban 0830 - 1600    R3200 Book
25 Jul Durban 0830 - 1600    R3200 Book
30 Jul Durban 0830 - 1600    R3200 Book
21 Aug Durban 0830 - 1600    R3200 Book
28 Aug Durban 0830 - 1600    R3200 Book
03 Oct Durban 0830 - 1600    R3200 Book
21 Nov Durban 0830 - 1600    R3200 Book
 
31 Jul Fourways 0830 - 1600    R3200 Book
23 Aug Fourways 0830 - 1600    R3200 Book
30 Sep Fourways 0830 - 1600    R3200 Book
11 Oct Fourways 0830 - 1600    R3200 Book
11 Nov Fourways 0830 - 1600    R3200 Book
22 Nov Fourways 0830 - 1600    R3200 Book
 
24 Jul Port Elizabeth 0830 - 1600    R3200 Book
26 Sep Port Elizabeth 0830 - 1600    R3200 Book
13 Nov Port Elizabeth 0830 - 1600    R3200 Book


Sorry, we currently do not have any public courses scheduled for the Access level 3 course in Stellenbosch. Please contact us to see if we can put one on the schedule for you

 


We offer all of these courses in Stellenbosch.

Access training courses in Stellenbosch
Excel training courses in Stellenbosch
Outlook training courses in Stellenbosch
Powerpoint training courses in Stellenbosch
Project training courses in Stellenbosch
Publisher training courses in Stellenbosch
Sharepoint training courses in Stellenbosch
SQL Server training courses in Stellenbosch
Visio training courses in Stellenbosch
Word training courses in Stellenbosch
HTML training courses in Stellenbosch
PHP training courses in Stellenbosch
Java training courses in Stellenbosch
JavaScript training courses in Stellenbosch
SQL training courses in Stellenbosch

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

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 Date  City Course Times    Cost  
 
20 Aug Bloemfontein 0830 - 1600    R3300 Book
15 Oct Bloemfontein 0830 - 1600    R3300 Book
 
03 Jul Cape Town 0830 - 1600    R3300 Book
18 Sep Cape Town 0830 - 1600    R3300 Book
20 Nov Cape Town 0830 - 1600    R3300 Book
 
05 Jul Durban 0830 - 1600    R3300 Book
12 Aug Durban 0830 - 1600    R3300 Book
 
10 Jul Fourways 0830 - 1600    R3300 Book
18 Sep Fourways 0830 - 1600    R3300 Book
23 Oct Fourways 0830 - 1600    R3300 Book
27 Nov Fourways 0830 - 1600    R3300 Book
 
25 Jun Midrand 0830 - 1600    R3300 Book
23 Jul Midrand 0830 - 1600    R3300 Book
27 Aug Midrand 0830 - 1600    R3300 Book
01 Oct Midrand 0830 - 1600    R3300 Book
29 Oct Midrand 0830 - 1600    R3300 Book
26 Nov Midrand 0830 - 1600    R3300 Book
 
02 Jul Port Elizabeth 0830 - 1600    R3300 Book
05 Sep Port Elizabeth 0830 - 1600    R3300 Book
13 Nov Port Elizabeth 0830 - 1600    R3300 Book
 
09 Jul Pretoria 0830 - 1600    R3300 Book
13 Aug Pretoria 0830 - 1600    R3300 Book
10 Sep Pretoria 0830 - 1600    R3300 Book
15 Oct Pretoria 0830 - 1600    R3300 Book
12 Nov Pretoria 0830 - 1600    R3300 Book