Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com
Phone: +27 10 020 2067

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Videos

Displaying 124
  1. Introduction
Video (as in order)
Access 2013 - Introduction 1
  1. Introduction
  1. Access 2013 Module 1
Video (as in order)
Section 1-1 - Creating Databases 2
  1. Access 2013 Module 1
Creating New Databases 3
  1. Access 2013 Module 1
Create Databases Using Templates 4
  1. Access 2013 Module 1
Create Databases In Older Formats 5
  1. Access 2013 Module 1
Section 1-2 - Creating Tables 6
  1. Access 2013 Module 1
Create New Tables 7
  1. Access 2013 Module 1
Import External Data Into Tables 8
  1. Access 2013 Module 1
Create Linked Tables From External Sources 9
  1. Access 2013 Module 1
Import Tables From Other Database 10
  1. Access 2013 Module 1
Create Tables From Templates And Application Parts 11
  1. Access 2013 Module 1
Section 1-3 - Format A Table 12
  1. Access 2013 Module 1
Hide Fields In Tables 13
  1. Access 2013 Module 1
Change Data Formats 14
  1. Access 2013 Module 1
Add Total Rows 15
  1. Access 2013 Module 1
Add Table Descriptions 16
  1. Access 2013 Module 1
Rename Tables 17
  1. Access 2013 Module 1
Section 1-4 - Manage Records 18
  1. Access 2013 Module 1
Update Records 19
  1. Access 2013 Module 1
Add New Records 20
  1. Access 2013 Module 1
Delete Records 21
  1. Access 2013 Module 1
Append Records From External Data 22
  1. Access 2013 Module 1
Find And Replace Data 23
  1. Access 2013 Module 1
Sort Records 24
  1. Access 2013 Module 1
Filter Records 25
  1. Access 2013 Module 1
Section 1-5 - Create And Modify Fields 26
  1. Access 2013 Module 1
Add Fields To Tables 27
  1. Access 2013 Module 1
Add A Validation Rules To Fields 28
  1. Access 2013 Module 1
Change Field Captions 29
  1. Access 2013 Module 1
Change Field Sizes 30
  1. Access 2013 Module 1
Change Field Data Types 31
  1. Access 2013 Module 1
Configure Fields To Auto-Increment 32
  1. Access 2013 Module 1
Set Default Values 33
  1. Access 2013 Module 1
Use Input Masks 34
  1. Access 2013 Module 1
Delete Fields 35
  1. Access 2013 Module 1
  1. Access 2013 Module 2
Video (as in order)
Section 2-1 - Create A Query 36
  1. Access 2013 Module 2
Run Queries 37
  1. Access 2013 Module 2
Create Crosstab Queries 38
  1. Access 2013 Module 2
Create Parameter Queries 39
  1. Access 2013 Module 2
Create Action Queries 40
  1. Access 2013 Module 2
Create Multi Table Queries 41
  1. Access 2013 Module 2
Save Queries And Delete Queries 42
  1. Access 2013 Module 2
Section 2-2 - Modify A Query 43
  1. Access 2013 Module 2
Rename Queries 44
  1. Access 2013 Module 2
Add New Fields 45
  1. Access 2013 Module 2
Remove Fields 46
  1. Access 2013 Module 2
Hide Fields 47
  1. Access 2013 Module 2
Sort Data Within Queries 48
  1. Access 2013 Module 2
Format Fields Within Queries 49
  1. Access 2013 Module 2
Section 2-3 - Utilize Calculated Fields And Grouping Within A Query 50
  1. Access 2013 Module 2
Add Calculated Fields 51
  1. Access 2013 Module 2
Add Conditional Logic 52
  1. Access 2013 Module 2
Group And Summarize Data 53
  1. Access 2013 Module 2
Use Comparison Operators 54
  1. Access 2013 Module 2
Use Basic Operators 55
  1. Access 2013 Module 2
  1. Access 2013 Module 3
Video (as in order)
Section 3-1 - Create A Form 56
  1. Access 2013 Module 3
Create New Forms 57
  1. Access 2013 Module 3
Create Forms With Application Parts 58
  1. Access 2013 Module 3
Save And Delete Forms 59
  1. Access 2013 Module 3
Section 3-2 - Set Form Controls 60
  1. Access 2013 Module 3
Move Form Controls 61
  1. Access 2013 Module 3
Add Form Controls 62
  1. Access 2013 Module 3
Modify Data Sources 63
  1. Access 2013 Module 3
Remove Form Controls 64
  1. Access 2013 Module 3
Set Form Control Properties 65
  1. Access 2013 Module 3
Manage Labels 66
  1. Access 2013 Module 3
Section 3-3 - Format A Form 67
  1. Access 2013 Module 3
Modify Tab Order In Forms And Auto-Order Forms 68
  1. Access 2013 Module 3
Format Print Layouts 69
  1. Access 2013 Module 3
Sort Records 70
  1. Access 2013 Module 3
Apply Themes 71
  1. Access 2013 Module 3
Change Margins 72
  1. Access 2013 Module 3
Insert Backgrounds 73
  1. Access 2013 Module 3
Insert Images 75
  1. Access 2013 Module 3
Modify Existing Forms 76
  1. Access 2013 Module 3
  1. Access 2013 Module 4
Video (as in order)
Insert Headers And Footers 74
  1. Access 2013 Module 4
Section 4-1 - Create A Report 77
  1. Access 2013 Module 4
Create New Reports 78
  1. Access 2013 Module 4
Create Reports With Application Parts 79
  1. Access 2013 Module 4
Delete Reports 80
  1. Access 2013 Module 4
Section 4-2 - Set Report Controls 81
  1. Access 2013 Module 4
Group Data By Fields 82
  1. Access 2013 Module 4
Sort Data 83
  1. Access 2013 Module 4
Add Sub-Forms 84
  1. Access 2013 Module 4
Modify Data Sources 85
  1. Access 2013 Module 4
Add Report Controls 86
  1. Access 2013 Module 4
Manage Labels 87
  1. Access 2013 Module 4
Section 4-3 - Format A Report 88
  1. Access 2013 Module 4
Format Reports Into Multiple Columns 89
  1. Access 2013 Module 4
Add Calculated Fields 90
  1. Access 2013 Module 4
Set Margins 91
  1. Access 2013 Module 4
Add Backgrounds 92
  1. Access 2013 Module 4
Change Report Orientation 93
  1. Access 2013 Module 4
Change Sort Order 94
  1. Access 2013 Module 4
Insert Headers And Footers 95
  1. Access 2013 Module 4
Insert Images & Insert Page Numbers 96
  1. Access 2013 Module 4
Apply Themes 97
  1. Access 2013 Module 4
Modify Existing Reports 98
  1. Access 2013 Module 4
  1. Access 2013 Module 5
Video (as in order)
Section 5-1 - Manage Relationships And Keys 99
  1. Access 2013 Module 5
Create And Modify Relationships & View Relationships 100
  1. Access 2013 Module 5
Set Primary Key Fields 101
  1. Access 2013 Module 5
Set Foreign Keys 102
  1. Access 2013 Module 5
Enforce Referential Integrity 103
  1. Access 2013 Module 5
Section 5-2 - Navigate Through A Database 104
  1. Access 2013 Module 5
Navigate To Specific Records 105
  1. Access 2013 Module 5
Set A Form As The Startup Option 106
  1. Access 2013 Module 5
Use Navigation Forms 107
  1. Access 2013 Module 5
Set Navigation Options 108
  1. Access 2013 Module 5
Change Views 109
  1. Access 2013 Module 5
Section 5-3 - Protect And Maintain A Database 110
  1. Access 2013 Module 5
Compact Databases & Repair Databases 111
  1. Access 2013 Module 5
Back Up Databases 112
  1. Access 2013 Module 5
Split Databases 113
  1. Access 2013 Module 5
Encrypt Databases With A Password 114
  1. Access 2013 Module 5
Merge Databases 115
  1. Access 2013 Module 5
Recover Data From Backups 116
  1. Access 2013 Module 5
Section 5-4 - Print And Export A Database 117
  1. Access 2013 Module 5
Print Reports 118
  1. Access 2013 Module 5
Print Records 119
  1. Access 2013 Module 5
Maintain Backward Compatibility 120
  1. Access 2013 Module 5
Save Databases As Templates 121
  1. Access 2013 Module 5
Save Databases To External Locations 122
  1. Access 2013 Module 5
Export To Alternate Formats 123
  1. Access 2013 Module 5
Program Close 124
  1. Access 2013 Module 5
Back to Top