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 365 (2019) Advanced

Interactive course with workbook

SPRING SPECIAL pricing (RRP $ 49.00)

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

Qty
Unit cost
Total
 
1
$ 18.99
$ 18.99
5
$ 18.04
$ 90.20
10
$ 17.47
$ 174.70
50
$ 17.09
$ 854.50
100
$ 16.14
$ 1,614.00

Options for your Shopping Cart

Interactive course with workbook

SPRING SPECIAL pricing (RRP $ 49.00)

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

Qty
Unit cost
Total
 
1
$ 18.99
$ 18.99
5
$ 18.04
$ 90.20
10
$ 17.47
$ 174.70
50
$ 17.09
$ 854.50
100
$ 16.14
$ 1,614.00
Home   >  Microsoft   >  Microsoft Access   > 
Microsoft Access 365 (2019) Advanced

Microsoft Access 365 (2019) Advanced

A Premier Microsoft Access training course from ZandaX

Your expert, effective online solution for learning access 365 (2019) advanced

Quick Summary: What You Get

Introduction
Primary Keys and Indexes
Using Datasheet View
Linking to Other Access Databases
Using ODBC and SQL Server
Splitting an Access Database
Macros
The Ribbon
Visual Basic for Applications (VBA)
Access Events Model
Forms
Advanced Use of Queries
Packaging Your Application
Course Close

Who's this course for?

This course has been designed for users with a good understanding of Microsoft Access who want to expand their skills further into more advanced and technical areas 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 course.

Course type

This course is a PARTNER course : Interactive video lessons, with lively and informative on-screen content.
It comes with a 6-month license, giving you unlimited 24/7 access for each user.

Grab Our
SPRING SPECIAL ...

$ 18.99
  $ 49.00
Quantity discounts available

Course benefits

Move on to Higher Database Things!

In our Microsoft Access advanced course, we take up from where the beginner's course finishes, and move straight into the more advanced features and tools available.

This course is ideal if you have a good working knowledge of Access but need to use its more advanced features.

In this course, we look at using ODBC and SQL Server, and look deeper into using Macros and VBA in Access. We show you how to split databases and create advanced forms.

When you're done, you'll know a whole host of advanced tools and concepts in Access that will increase your understanding, and your productivity.

Course content in detail

Click a RH arrow   (
)   to reveal the lessons

01
Introduction
2 sections
»
Course Overview and Content
»
Course Exercise Files

02
Primary Keys and Indexes
2 sections
»
Primary Keys and Indexing Rules and Guidelines
»
More About Indexes

03
Using Datasheet View
5 sections
»
Setting-up Northwind Database
»
Working in a Datasheet View
»
Customizing Datasheet View and Advanced Sorting and Filtering
»
Subdatasheets
»
Exercise 01

04
Linking to Other Access Databases
1 section
»
Linking Two Tables to Other Access Databases

05
Using ODBC and SQL Server
3 sections
»
Acquiring and Installing SQL Server Express
»
Setting Up SQL Server Database
»
Exercise 02

06
Splitting an Access Database
4 sections
»
Splitting an Access Database into Front-end and Back-end
»
Converting Shared Table into Local Table; Moving Back-end Database
»
Exercise 03
»
Addressing Multi-user Issues when Sharing Data

07
Macros
5 sections
»
Basics of Macros
»
Macros on Events; AutoExec
»
More About AutoExec; Bypassing AutoExec
»
Macro Security Settings
»
Exercise 04

08
The Ribbon
1 section
»
Customizing the Ribbon and Quick Access Toolbar

09
Visual Basic for Applications (VBA)
5 sections
»
Convert Macros to VBA; VBA Editor and Property Windows
»
VBA Modules; Running Code and Error Handling
»
Creating Modules; Subs, Functions, Intellisense and Variables
»
Scope, Variable Naming and Strings
»
Standard Functions; Logical, Case and Loop Statements

10
Access Events Model
5 sections
»
Adding Events to Assets Database
»
Exercise 05
»
Common Events; Form and Report Events
»
Switchboard and Navigation Form; Error Handling
»
Exercise 06

11
Forms
5 sections
»
Formatting Bound and Control Form
»
Split Forms; Macro Error Handling
»
Creating Form with Tab
»
Go To Combo Box and Its Properties
»
Exercise 07

12
Advanced Use of Queries
6 sections
»
Basics of Queries
»
Syntax of SQL Statements
»
Use of Multiple Where Criteria & Select Statements Function
»
Exercise 08
»
Action Queries - Part 1
»
Action Queries - Part 2

13
Packaging Your Application
2 sections
»
Steps in Packaging Access Application
»
Exercise 09

14
Course Close
1 section
»
Course 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
Score: 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
Score: 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
Score: 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
Score: 4.0
review score of 5.0
Microsoft Access 2013/2016 Advanced
"Very well covered. Thanks."
Paul Quinn
Score: 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
Score: 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
Score: 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
Score: 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
Score: 5.0
review score of 5.0
Microsoft Access 2013/2016 Intermediate
"Very good course"
James Hayden
Score: 5.0
review score of 4.5
Microsoft Access 2013/2016 Introduction
"I found it interesting, well structured and easily understood."
Chris Twose
Score: 4.5
review score of 5.0
Microsoft Access 2013/2016 Introduction
" Very good and useful introduction"
James Hayden
Score: 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
Score: 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
Score: 5.0

Grab Our
SPRING SPECIAL ...

$ 18.99
  $ 49.00
Quantity discounts available

More information

Click for more about Microsoft Access courses
Click for more about Microsoft courses
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 2025