Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

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

You are here

Microsoft Office 2013 - Access

EDUTAINMENT COURSE E-Learning

Microsoft Office 2013 - Access

Interactive and entertaining talk-show style format presented by industry leading experts.
Overview

This course Microsoft Office Access 2013 prepare students for their certification exam 77-424, Microsoft Access 2013 guides about the scenarios for creating databases. You will learn to create a very simple, standardized database from a template and then create a customized database. At the completion of this course, you will understand tables, relationships, queries, forms, and reports.

Objectives
  • Create a new database
  • Create and format table
  • Modifying fields
  • Modifying fields
  • Building forms
  • Using calculated fields and groups in a query
  • Protecting a database
  • Create and modify the query
  • Creating different types of queries
  • Create, set report controls and format report
Target Audience
  • Refresh your concepts on tables, forms, queries, and reports
  • IT Professionals
  • If you wish to obtain the Microsoft Office Specialist Certification (MOS), you should take this course
  • If you need to gain additional skills in Access 2013, this course is for you
  • This course is not for individuals who have not worked within the Access 2013 environment.

Section 1-1 - Creating Databases

  • Creating New Databases
  • Create Databases Using Templates
  • Create Databases In Older Formats

Section 1-2 - Creating Tables

  • Create New Tables
  • Import External Data Into Tables
  • Create Linked Tables From External Sources
  • Import Tables From Other Database
  • Create Tables From Templates And Application Parts

Section 1-3 - Format A Table

  • Hide Fields In Tables
  • Change Data Formats
  • Add Total Rows
  • Add Table Descriptions
  • Rename Tables

Section 1-4 - Manage Records

  • Update Records
  • Add New Records
  • Delete Records
  • Append Records From External Data
  • Find And Replace Data
  • Sort Records
  • Filter Records

Section 1-5 - Create And Modify Fields

  • Add Fields To Tables
  • Add A Validation Rules To Fields
  • Change Field Captions
  • Change Field Sizes
  • Change Field Data Types
  • Configure Fields To Auto-Increment
  • Set Default Values
  • Use Input Masks
  • Delete Fields

Section 2-1 - Create A Query

  • Run Queries
  • Create Crosstab Queries
  • Create Parameter Queries
  • Create Action Queries
  • Create Multi Table Queries
  • Save Queries And Delete Queries

Section 2-2 - Modify A Query

  • Rename Queries
  • Add New Fields
  • Remove Fields
  • Hide Fields
  • Sort Data Within Queries
  • Format Fields Within Queries

Section 2-3 - Utilize Calculated Fields And Grouping Within A Query

  • Add Calculated Fields
  • Add Conditional Logic
  • Group And Summarize Data
  • Use Comparison Operators
  • Use Basic Operators

Section 3-1 - Create A Form

  • Create New Forms
  • Create Forms With Application Parts
  • Save And Delete Forms

Section 3-2 - Set Form Controls

  • Move Form Controls
  • Add Form Controls
  • Modify Data Sources
  • Remove Form Controls
  • Set Form Control Properties
  • Manage Labels

Section 3-3 - Format A Form

  • Modify Tab Order In Forms And Auto-Order Forms
  • Format Print Layouts
  • Sort Records
  • Apply Themes
  • Change Margins
  • Insert Backgrounds
  • Insert Headers And Footers
  • Insert Images
  • Modify Existing Forms

Section 4-1 - Create A Report

  • Create New Reports
  • Create Reports With Application Parts
  • Delete Reports

Section 4-2 - Set Report Controls

  • Group Data By Fields
  • Sort Data
  • Add Sub-Forms
  • Modify Data Sources
  • Add Report Controls
  • Manage Labels

Section 4-3 - Format A Report

  • Format Reports Into Multiple Columns
  • Add Calculated Fields
  • Set Margins
  • Add Backgrounds
  • Change Report Orientation
  • Change Sort Order
  • Insert Headers And Footers
  • Insert Images & Insert Page Numbers
  • Apply Themes
  • Modify Existing Reports

Section 5-1 - Manage Relationships And Keys

  • Create And Modify Relationships & View Relationships
  • Set Primary Key Fields
  • Set Foreign Keys
  • Enforce Referential Integrity

Section 5-2 - Navigate Through A Database

  • Navigate To Specific Records
  • Set A Form As The Startup Option
  • Use Navigation Forms
  • Set Navigation Options
  • Change Views

Section 5-3 - Protect And Maintain A Database

  • Compact Databases & Repair Databases
  • Back Up Databases
  • Split Databases
  • Encrypt Databases With A Password
  • Merge Databases
  • Recover Data From Backups

Section 5-4 - Print And Export A Database

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