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

Access 2016 Essentials

EDUTAINMENT COURSE

Access 2016 Essentials

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

Microsoft Access is a relational database software that allows small teams and individuals to easily organize and report on business data.  Microsoft Access is a file-based desktop application that enables organizations to manage and leverage data.  The relational database also includes tools that allow you to quickly build database-bound forms and reports. Whether you’re new to Access or an advanced user,   Microsoft Access training from iCollege can accelerate your database management skills.  Learn the basics,  such as how to create a database,  navigate the Access application environment or organize data stored within Access tables Or graduate to more advanced skills like form customization,  querying and sharing data across applications.

Objectives
  • Create, design and encrypt Access databases
  • Build and work with Access tables,  relationships,  keys and constraints
  • Query data
  • Manage and design interfaces with Access Forms
  • Produce basic to advanced reportsAutomate tasks,  procedures, and functions with Macros and VBA
  • Customize Access configuration options

Access 2016 has all the functionality and features you're used to with some added enhancements and the best new features from Office 2016.

Prerequisites
  • Navigate through Windows files and folders
  • Work with Windows - minimise, maximise, open and close
Target Audience
  • This course is for anyone who wants to develop or improve their skills in MS Access.
  • This course is for anyone who want to become proficient in MS Access.
  • This course is for anyone who has little knowledge or just want a review because of the 3 levels included,   Basic,  Intermediate and Advanced.
Instructor: ITProTV

ITProTV delivers the IT instruction that you need to advance or launch your IT career in a fun and creative way. With attractive studios and an interactive, talk-show style format, you'll watch more and learn more. From CompTIA, Cisco, and Microsoft to Security and Cloud Fundamentals, you can learn it all. Dive deep into one or master many with the friendly faces of IT training.

  1. Introduction
1
Start
Overview
2
Start
Introduction To Access
3
Start
What Is A Database
4
Start
Database Terminology
5
Start
Database Terminology Part 2
6
Start
Getting Started In Access
7
Start
Access Interface And Navigation
8
Start
Planning And Database Design
9
Start
Planning And Database Design Part 2
  1. CREATING ACCESS TABLES
10
Start
Creating Tables: Manual Data Entry
11
Start
Creating Tables: Importing External Data
12
Start
Creating Tables: Importing External Data Part 2
13
Start
Creating Table Relationships
14
Start
Creating Table Relationships Part 2
  1. CREATING QUERIES FOR TESTING DESIGN
15
Start
Creating Queries For Testing Desgin
16
Start
Creating Queries For Testing Design Part 2
17
Start
Creating Queries For Testing Design Part 3
18
Start
Creating Queries For Testing Design Part 4
19
Start
Creating Queries For Testing Design Part 5
  1. CREATING BASIC FORMS
20
Start
Creating Basic Forms
21
Start
Creating Basic Forms Part 2
22
Start
Creating Basic Forms Part 3
23
Start
Creating Basic Forms Part 4
  1. REPORTING DATA
24
Start
Creating Basic Reports
25
Start
Creating Basic Reports Part 2
26
Start
Creating Basic Reports Part 3
27
Start
Creating Basic Reports Part 4
28
Start
Creating Basic Reports Part 5
EDUTAINMENT COURSE
?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 59 USD 19 68% OFF
  • 12:54:00
    Hours of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months Access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top