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

courses popup callback

EDUTAINMENT COURSE:

Microsoft Access 2016

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.

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.

Access Beginner

1.1 Introduction Part 1

1.2 Introduction Part 2

1.3 Elements Part 1

1.4 Elements Part 2

1.5 Reviewing Data

1.6 Queries Part 1

1.7 Queries Part 2

1.8 Tracking Time Part 1

1.9 Tracking Time Part 2

1.10 Tracking Time Part 3

1.11 Design Work With Forms

Access Intermediate

1.1 Relationships Part 1

1.2 Relationships Part 2

1.3 Changing Information

1.4 Loading Tables

1.5 Relating Invoices Part 1

1.6 Relating Invoices Part 2

1.7 Relating Invoices Part 3

1.8 Relating Invoices Part 4

1.9 Time Entry Form

Access Advanced

1.1 Queries Part 1

1.2 Queries Part 2

1.3 Queries Part 3

1.4 Queries Part 4

1.5 Reports Based On Queries

1.6 Adding Additional Information

1.7 Update Query Part 1

1.8 Update Query Part 1

1.9 Creating A Report From Scratch Part 1

1.10 Creating A Report From Scratch Part 2

1.11 Creating A Report From Scratch Part 3

EDUTAINMENT COURSE
?Interactive and entertaining talk-show style format presented by industry leading experts.
  • 09:03:10 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