zandax online course logo
zandax website search
zandax phone callback
Info, Blogs, Contact & Login
Courses
Tests

More information about what you get

Interactive course with workbook & certificate

You'll learn using easy-to-follow on-screen videos which you can pause, re-run and revisit as often as you like.
The course is arranged into modules, each with several lessons. Refer to the course content for more details on what's covered. You can choose which module (or lesson) to review at any time.
You also get interactive content PLUS a comprehensive workbook, with exercises and a course certificate as evidence that you have invested in your skills: you can use it as part of your professional development, or include it with your CV.

Options for your Shopping Cart

Microsoft Access 2013/2016 Advanced

Interactive course with workbook & certificate

SUMMER Offer pricing (RRP $ 79.00)

Click on your choice [ it can be removed or edited in the cart ]

Order Qty
Total cost
Unit cost
 
1
$ 10.76
$ 10.76
5
$ 48.40
$ 9.68
10
$ 86.00
$ 8.60
50
$ 360.00
$ 7.20
100
$ 538.00
$ 5.38

Options for your Shopping Cart

Microsoft Access 2013/2016 Advanced
+
Microsoft Excel 2013/2016 Intermediate

SUMMER Offer pricing

Click on your choice [ it can be removed or edited in the cart ]


Order Qty
Total cost
Unit cost
 
1
$ 22.76
$ 22.76
5
$ 103.40
$ 20.68
10
$ 186.00
$ 18.60
50
$ 810.00
$ 16.20
100
$ 1,138.00
$ 11.38

Options for your Shopping Cart

Interactive course with workbook & certificate

SUMMER Offer pricing (RRP $ 0.00)

Click on your choice [ it can be removed or edited in the cart ]

Order Qty
Total cost
Unit cost
 
1
$ 10.76
$ 10.76
5
$ 48.40
$ 9.68
10
$ 86.00
$ 8.60
50
$ 360.00
$ 7.20
100
$ 538.00
$ 5.38

Microsoft Access 2013/2016 Advanced course

A premier Microsoft Access training course from ZandaX

Modules covered in this course:
Advanced Data Management
Advanced Form Tasks
Automating Reports
SQL and Microsoft Access
Macros and Visual Basic for Applications (VBA)
Finishing the Application

Home  >  Microsoft  >  Microsoft Access  > 
Microsoft Access 2013/2016 Advanced

What you'll learn

Advanced Data Management
  ★  Understand how table relationships are created and recognise SQL code
Advanced Form Tasks
  ★  Create navigation and other specialist forms to achieve the complete user experience
Automating Reports
  ★  Use forms to launch reports without having to constantly change criteria in a query
SQL and Microsoft Access
  ★  Understand and Create useful SQL statements to manage your database with effectively
Macros and Visual Basic for Applications (VBA)
  ★  Create Macros and Procedures for bespoke functionality using the Developer tab
Finishing the Application
  ★  Use advanced Access features to secure a database and control how users access database objects

Course type

This course is a VIDEO course : Video lessons with a workbook & exercises, skills test and certificate.
It comes with a 12-month license, giving you unlimited 24/7 access for each user.

Course requirements

Some of the lessons are quite technical and you must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Who's this course for?

This course has been designed for users with a solid understanding of Microsoft Access who want to expand their capabilities further in a short space of time.

CPD accredited course

CPD accredited course
This course is CPD accredited, which means that not only has it been rigorously assessed in terms of content and quality by the CPD, but you have options to get your own official CPD certificate.

Here's a 2-minute course overview

See why you need the course, and what's covered
Click the video to take a look

Course Description

How you'll benefit from the Access 2013/2016 Advanced course

Become an Access Expert

Once you've mastered the process of managing and displaying your data, you'll want to move to a higher level.

In the Advanced course, you'll gain a solid understanding of advanced tools and concepts in Access that will increase your knowledge and productivity.

Please note that some of the lessons are quite technical and you should fully understand what's covered in the Introduction and Intermediate courses.

This Microsoft Access skills training course, like all our courses, has been developed over many years of classroom and online delivery.   Content has been thoroughly researched and is constantly updated so it's always leading edge.   It's delivered by professional presenters and is full of practical knowledge and solutions.

Still wondering whether to do the course?
Just think about this: how much would you benefit if you had better Microsoft access skills?

About the ZandaX Access 2013/2016 Advanced course

Get the Most From Your Databases

The Advanced course takes you to a level that will leave behind other office users of Access.

You'll learn about advanced data management, working with forms and automating reports at the highest level.

We'll introduce you to SQL, and take you to advanced queries, sub queries and joins, before covering macros, procedures and VBA.

If that sounds a little daunting, remember that because of the modular nature of our courses, you can choose what you want to learn, and cover them one at a time.

Watch the modules, revisit them time and again ... and have fun with improving your skills!

Show more  
Show less      

Grab Our SUMMER Offer ...

$ 10.76   $ 79.00   86% off
[Further quantity discounts available]

Recent reviews for our Microsoft Access 2013/2016 Advanced courses

review score of 4.5
Overall a good course, with good functionality and an easy to follow layout.
Miles Hand
4.5
review score of 4.0
The course went well. The test questions very helpful so you can rate your understanding of course.
Virginia Mandenge
4.0
review score of 5.0
Very well covered. Thanks.
Paul Quinn
5.0
review score of 4.5
Great course. Took me to a completely new level in my ability
John McIlroy
4.5

Student feedback scores

4.4
5
52%
4
43%
3
4%
2
<1%
1
<1%

Course content for Access 2013/2016 Advanced

NOTE: Click on [ + / - ] to expand/hide the content of each module
1
1 - Advanced Data Management
[ + / - ]
» Referential Integrity
» Table Relationships
» An Introduction to SQL
» Modal Dialog Boxes
2
2 - Advanced Form Tasks
[ + / - ]
» Using Subforms
» Creating a Navigation Form
» Advanced Form Controls
» Exporting a Form
» Other Form Tasks
3
3 - Automating Reports
[ + / - ]
» Creating the Report Form
» Building Query Criteria
4
4 - SQL and Microsoft Access
[ + / - ]
» Understanding SQL
» Using the SELECT Statement
» Using Subqueries
» Using SQL Joins
5
5 - Macros and Visual Basic for Applications (VBA)
[ + / - ]
» Access and VBA
» Building Advanced Procedures
» Using VBA in a Database
6
6 - Finishing the Application
[ + / - ]
» Setting Start Up Options
» Sharing/Splitting the Database
» Creating an ACCDE
» Encrypting the Database with a Password

And there's a great workbook...

The CPD certificate you get with the Diploma and Professional course options will be your proof of where you are.

How about fulfilling your maximum potential?

Choose the Development or Professional course options and get your own great, results-focused downloadable workbook.

[ Click for details of the course options available ]

The workbook features:

  • Demonstrations of how to do each lesson
  • Space for your own notes alongside the lessons
  • Skill Sharpeners to practice and hone your skills
  • Downloadable exercise files for you to practice on

Courses Frequently Bought Together

These courses are frequently purchased together.
Add them both to your cart now to get EVEN MORE benefit from your training!
Course for Access 2013/2016 Advanced
ACCESS 2013/2016 ADVANCED
Includes Advanced Data Management, Form Tasks, Automating Reports, SQL & Microsoft Access, Macros & VBA, Finishing the Application
... and more
(This Course)
FROM $ 10.76   $79.00
Course for Excel 2013/2016 Intermediate
EXCEL 2013/2016 INTERMEDIATE
Includes Advanced File Tasks, Functions & Formulas, Tables, Data Tools, More Charts, Sparklines
... and more
FROM $ 12.00   $69.00
Both courses
BOTH COURSES
Full price: $ 148.00
Offer price: $ 22.76
[Further quantity
discounts available]

Grab Our SUMMER Offer ...

$ 10.76   $ 79.00   86% off
[Further quantity discounts available]
Microsoft Access 365 (2019) Beginners course

Microsoft Access 365 (2019) Beginners

Learn to Build Fully Functional Access Databases

Includes Getting Started, Using the Interface, Tables, Importing Data, Backing Up, Relationships, Forms, Queries, Reports, Printing, Exporting ... and more: click the 'see the course' button for full details.
Microsoft Access 365 (2019) Advanced course

Microsoft Access 365 (2019) Advanced

Get Even More From Your Databases

Includes Primary Keys, Linking, ODBC & SQL Server, Macros, VBA, Forms, Advanced Queries, Packaging ... and more: click the 'see the course' button for full details.
Microsoft Access 2013/2016 Introduction course

Microsoft Access 2013/2016 Introduction

Start Creating Powerful Access Databases

Includes Getting Started, Using the Ribbon Interface, Simple Databases, Forms, Queries, Reports & Filters ... and more: click the 'see the course' button for full details.
Microsoft Access 2013/2016 Intermediate course

Microsoft Access 2013/2016 Intermediate

Step Up to Real Functionality

Includes Advanced File Tasks, Database Management, Working With Tables, Forms, Reports & Queries ... and more: click the 'see the course' button for full details.

More information

Click for more about Microsoft Access courses
Click for more about Microsoft courses
ZandaX online training course logo
ZandaX – Change Your Life ... Today
All content © ZandaX 2023
ZandaX LinkedIn logo
ZandaX LinkedIn logo
ZandaX LinkedIn logo
Close menu element
See how you score on a range of skills that are critical to your well-being and performance
Communication Skill test
Communication Skills
How Can You Communicate Better?
Would you like to see what kind of communicator you are? And how you can improve the effectiveness of your communications?
Likeability test
Likeability
How Much Do People Like You?
Do you sometimes wonder just how likeable you are? And wouldn't you like to see how you can (genuinely) become more likeable?


Time Management test
Time Management
How Can You Make More Use Of Your Time?
Are you frustrated by how easily time slips away? Do you get frustrated when things don't get done just because you run out of time?
Assertiveness test
Assertiveness
Are you Passive, Aggressive or Assertive?
Would you like to know where you fall on the behavior spectrum? Does your response to events sometimes surprise you?


Close menu element
Information & Resources
ZandaX information
Information
Read more about us, our Privacy Policy and our Terms of Service
See how we want to help you, and how we make everything easy for everyone
Callback request
ZandaX Blogs
Articles to increase your knowledge and understanding in key areas of your life and career.
Read our blogs on Personal Development, Business Skills and Leadership & Management


Time Management test
Log In
Log in to your online dashboard
View your courses, review what you want and download your workbooks and certificates
Assertiveness test
Contact Us
An easy online form to get in touch
With options for More Information, Customer Service and Feedback


Close menu element
Develop Your Skills, Knowledge and Understanding with ZandaX
Click any subject in the listings for more information and a full list of courses

Personal Development
Personal Development training
Your soft skills affect everything you do, at work, at home and with friends ... they are truly life changing!
NEW COURSES
Online training courses
Hot Off the Press...
We're always adding to and upgrading our courses, so here are a few of our latest releases:
For a full listing of courses, please visit our Quick Course Finder to find exactly what you want.
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we'll assume you're OK to continue.

I'm fine with this