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

Microsoft Access 2016

E-COURSE:

Microsoft Access 2016

Instructor-led video course with presentations, workbooks, games, flashcards and quizzes.
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

E-COURSE E-Learning Expert-led video course with presentations, workbooks, quizzes, games and flashcards.
USD 195 USD 95 51% OFF
  • 09:03:10
    + Hours Of learning
  • Includes video, presentations, workbooks, quizzes, flashcards & games
  • 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