SELECT modules.module_duration, modules.module_minutes FROM (product INNER JOIN modules ON product.data_id = modules.data_id) INNER JOIN coursemodule ON modules.module_id = coursemodule.module_id WHERE ((product.product_id)='MSXS609')<
Microsoft Access 2013/2016 Advanced Courses Online With CPD Certificate

More information about what you get

Video course

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.

Options for your Shopping Cart

Microsoft Access 2013/2016 Advanced

Interactive course with workbook & certificate

SUMMER Offer pricing (RRP $ 48.99)

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

Order Qty
Total cost
Unit cost
 
1
$ 8.99
$ 8.99
5
$ 40.45
$ 8.09
10
$ 71.90
$ 7.19
50
$ 301.00
$ 6.02
100
$ 449.00
$ 4.49

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
$ 17.99
$ 17.99
5
$ 79.95
$ 15.99
10
$ 139.90
$ 13.99
50
$ 599.50
$ 11.99
100
$ 899.00
$ 8.99

Options for your Shopping Cart

Interactive course with workbook & certificate

SUMMER Offer pricing (RRP $ 48.99)

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

Order Qty
Total cost
Unit cost
 
1
$ 8.99
$ 8.99
5
$ 40.45
$ 8.09
10
$ 71.90
$ 7.19
50
$ 301.00
$ 6.02
100
$ 449.00
$ 4.49
Home   >  Microsoft   >  Microsoft Access   > 
Microsoft Access 2013/2016 Advanced

Microsoft Access 2013/2016 Advanced

A Premier Microsoft Access training course from ZandaX

Quick Summary: What You Get

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

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.

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.

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.

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 upon successful completion of the course, you will be able to download your own official CPD certificate.

Microsoft Access 2013/2016 Advanced

Click to see a quick overview

Grab Our
SUMMER Offer ...

$ 8.99
  $ 48.99
Quantity discounts available

Course benefits

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.

And there's a great workbook...

Get your own flexible, results-focused downloadable workbook.

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

Course content in detail

Click a RH arrow   (
)   to reveal the lessons

01
Advanced Data Management
4 sections
»
Referential Integrity
»
Table Relationships
»
An Introduction to SQL
»
Modal Dialog Boxes

02
Advanced Form Tasks
5 sections
»
Using Subforms
»
Creating a Navigation Form
»
Advanced Form Controls
»
Exporting a Form
»
Other Form Tasks

03
Automating Reports
2 sections
»
Creating the Report Form
»
Building Query Criteria

04
SQL and Microsoft Access
4 sections
»
Understanding SQL
»
Using the SELECT Statement
»
Using Subqueries
»
Using SQL Joins

05
Macros and Visual Basic for Applications (VBA)
3 sections
»
Access and VBA
»
Building Advanced Procedures
»
Using VBA in a Database

06
Finishing the Application
4 sections
»
Setting Start Up Options
»
Sharing/Splitting the Database
»
Creating an ACCDE
»
Encrypting the Database with a Password

People also bought

See these SUMMER Offer prices!
Microsoft Access 365 (2019) Beginners
Microsoft Access 365 (2019) Beginners
[Interactive course]
Normal price: $48.99
$18.99
Course description
Summary
Includes Getting Started, Using the Interface, Tables, Importing Data, Backing Up, Relationships, Forms, Queries, Reports, Printing, Exporting
[ close ]
Microsoft Access 365 (2019) Advanced
Microsoft Access 365 (2019) Advanced
[Interactive course]
Normal price: $48.99
$18.99
Course description
Summary
Includes Primary Keys, Linking, ODBC & SQL Server, Macros, VBA, Forms, Advanced Queries, Packaging
[ close ]
Microsoft Access 2013/2016 Introduction
Microsoft Access 2013/2016 Introduction
[Video course]
Normal price: $48.99
$8.99
Course description
Summary
Includes Getting Started, Using the Ribbon Interface, Simple Databases, Forms, Queries, Reports & Filters
[ close ]
Microsoft Access 2013/2016 Intermediate
Microsoft Access 2013/2016 Intermediate
[Video course]
Normal price: $48.99
$8.99
Course description
Summary
Includes Advanced File Tasks, Database Management, Working With Tables, Forms, Reports & Queries
[ close ]

What learners say about ZandaX

[Click the side arrows or the green dots below to see more]

review score of 4.5
Microsoft Access 2013/2016 Advanced
"Thanks tutoring"
Tim Koo
4.5
review score of 5.0
Microsoft Access 2013/2016 Introduction
"I found the course to be easy to follow, with simple steps and the workbook was very useful"
Sharon Taylor
5.0
review score of 4.5
Microsoft Access 2013/2016 Advanced
"Overall a good course, with good functionality and an easy to follow layout."
Miles Hand
4.5
review score of 4.0
Microsoft Access 2013/2016 Advanced
"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
Microsoft Access 2013/2016 Advanced
"Very well covered. Thanks."
Paul Quinn
5.0
review score of 4.0
Microsoft Access 2013/2016 Intermediate
"Good Intermediate Course - easy to follow and grasp. Will be useful. Also completed Basic course"
Paul Quinn
4.0
review score of 5.0
Microsoft Access 2013/2016 Intermediate
"Course going ok and clearly explained. The topics are well covered and examples easily understood."
Virginia Mandenge
5.0
review score of 4.5
Microsoft Access 2013/2016 Advanced
"Great course. Took me to a completely new level in my ability"
John McIlroy
4.5
review score of 5.0
Microsoft Access 2013/2016 Introduction
"I am learning lots of things about Access database and tutor is clear and explains satisfactorily"
Virginia Mandenge
5.0
review score of 5.0
Microsoft Access 2013/2016 Intermediate
"Very good course"
James Hayden
5.0
review score of 4.5
Microsoft Access 2013/2016 Introduction
"I found it interesting, well structured and easily understood."
Chris Twose
4.5
review score of 5.0
Microsoft Access 2013/2016 Introduction
" Very good and useful introduction"
James Hayden
5.0
review score of 4.0
Microsoft Access 2013/2016 Introduction
"Gave the overall basics of Access which is exactly what I wanted"
Andrew Haughey
4.0
review score of 5.0
Microsoft Access 2013/2016 Introduction
"The course covered the subject really well, and showed tools that make using access easier"
Jeanette Martin
5.0

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!
Microsoft Access 2013/2016 Advanced
Microsoft Access 2013/2016 Advanced
Normal price: $48.99
{This course}
Click for a quick summary...
Summary
Includes Advanced Data Management, Form Tasks, Automating Reports, SQL & Microsoft Access, Macros & VBA, Finishing the Application
[ close ]
Microsoft Excel 2013/2016 Intermediate
Microsoft Excel 2013/2016 Intermediate
Normal price: $48.99
{Related course}
Click for a quick summary...
Summary
Includes Advanced Data Management, Form Tasks, Automating Reports, SQL & Microsoft Access, Macros & VBA, Finishing the Application
[ close ]
See pricing options
Both courses

RRP: $97.99
You pay: $17.99
DISCOUNT: 82%

Grab Our
SUMMER Offer ...

$ 8.99
  $ 48.99
Quantity discounts available
zandax online courses logo
"ZandaX courses are such great value, and with the help and support they provide, there's no better option in the market"
ZandaX LinkedIn logo
ZandaX YouTube logo
ZandaX FaceBook logo
 
All content © ZandaX 2024