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

SITE RELAUNCH 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
$ 18.99
$ 18.99
5
$ 90.20
$ 18.04
10
$ 174.70
$ 17.47
50
$ 854.50
$ 17.09
100
$ 1,614.00
$ 16.14

Options for your Shopping Cart

Microsoft Access 365 (2019) Advanced
&
Microsoft Access 365 (2019) Beginners

SITE RELAUNCH Offer pricing

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


Order Qty
Total cost
Unit cost
 
1
$ 37.99
$ 37.99
5
$ 179.95
$ 35.99
10
$ 349.90
$ 34.99
50
$ 1,699.50
$ 33.99
100
$ 3,199.00
$ 31.99

Options for your Shopping Cart

Interactive course with workbook

SITE RELAUNCH 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
$ 18.99
$ 18.99
5
$ 90.20
$ 18.04
10
$ 174.70
$ 17.47
50
$ 854.50
$ 17.09
100
$ 1,614.00
$ 16.14
Home   >  Microsoft   >  Microsoft Access   > 
Microsoft Access 365 (2019) Advanced

Microsoft Access 365 (2019) Advanced

A Premier Microsoft Access training course from ZandaX

Modules covered: what you will learn

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
SITE RELAUNCH Offer ...

$ 18.99
  $ 48.99
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 lessons
»
Course Overview and Content
»
Course Exercise Files

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

03
Using Datasheet View
5 lessons
»
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 lesson
»
Linking Two Tables to Other Access Databases

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

06
Splitting an Access Database
4 lessons
»
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 lessons
»
Basics of Macros
»
Macros on Events; AutoExec
»
More About AutoExec; Bypassing AutoExec
»
Macro Security Settings
»
Exercise 04

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

09
Visual Basic for Applications (VBA)
5 lessons
»
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 lessons
»
Adding Events to Assets Database
»
Exercise 05
»
Common Events; Form and Report Events
»
Switchboard and Navigation Form; Error Handling
»
Exercise 06

11
Forms
5 lessons
»
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 lessons
»
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 lessons
»
Steps in Packaging Access Application
»
Exercise 09

14
Course Close
1 lesson
»
Course Close

People also bought

See our SITE RELAUNCH Offer prices!
Microsoft Access 365 (2019) Beginners
Microsoft Access 365 (2019) Beginners
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 2013/2016 Introduction
Microsoft Access 2013/2016 Introduction
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
Normal price: $48.99
$8.99
Course description
Summary
Includes Advanced File Tasks, Database Management, Working With Tables, Forms, Reports & Queries
[ close ]
Microsoft Access 2013/2016 Advanced
Microsoft Access 2013/2016 Advanced
Normal price: $48.99
$8.99
Course description
Summary
Includes Advanced Data Management, Form Tasks, Automating Reports, SQL & Microsoft Access, Macros & VBA, Finishing the Application
[ close ]

What learners say about ZandaX

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

review score of 5.0
"Loved the upgrade: my friend bought the original course which was great and this is better still!"
Aisha Asghar
5.0
review score of 5.0
"I don't know how you people make things so easy to understand. SO useful. Looking at more courses."
Rodi Davani
5.0
review score of 4.5
Setting Up Your Sales Team
"If I'd only had this course years ago my job would have been so much easier!"
Laurie Sanders
4.5
review score of 5.0
Effective Communication Skills Master Class
"Such a useful course."
Steff Harris
5.0
review score of 5.0
Sales Management Explained (Master Class)
"Thank yo so much: I have learned so much and it's all explained so simply."
Kirsty Wallis
5.0
review score of 5.0
"So much in here, and I already have plans to improve my team!"
Nicki Scott
5.0
review score of 5.0
Effective Communication in the Workplace
"Lots of useful tips for a business environment. Thankyou."
Fatima Osmani
5.0
review score of 4.5
Microsoft Visio 2013 Advanced
"I like is very good and very helpful"
John Ashour
4.5
review score of 5.0
Anger Management and Control
"Thanks, very informative and insightful!"
Stephen Cooper
5.0
review score of 5.0
Microsoft Excel 2013/2016 Professional
"Really useful course. Would have liked to have practice files matching with videos too."
Meena Ridge
5.0
review score of 5.0
Building & Managing Trust
"This course has helped me to deal with issues in my team. Thank you."
Will Suliman
5.0
review score of 5.0
Effective Communication Skills Master Class
"Course covers so much in a short time: highly recommended."
Kamari Musa
5.0
review score of 4.5
Microsoft Excel 2013/2016 Intermediate
"Well done. learning more"
Martin OCallaghan
4.5
review score of 5.0
Effective Communication Skills
"A really good start for self assessment on personal communication skills."
Sergiu Ungureanu
5.0
review score of 5.0
Managing Difficult Employees
"This course is amazing. It has simplified something that has plagued me for a long time."
Reza Ahura
5.0
review score of 5.0
Microsoft Outlook 2013/2016 Essentials
"Excellent course. Everything was very usefull and with excellent timing. It was real pleasure."
Nebojša Vukov
5.0
review score of 5.0
"Learned a lot and has made the hardest part of my job much easier!"
Sammy Roberts
5.0
review score of 5.0
Microsoft Project 2013 Advanced
"The video is good, good to know how to move data back and forth from Excel to Project."
Nathan Krell
5.0
review score of 5.0
Effective Communication Skills
"Awesome! It is an easy to understand informational course. Thank you!"
JOSHUA LAU LEE THAI
5.0
review score of 5.0
Effective Communication Skills
"clear outline"
Malak
5.0
review score of 5.0
Microsoft Word 2013/2016 Advanced
"good experience"
Eyob GEBRU
5.0
review score of 5.0
Effective Communication Skills
"amazing"
Muhammad Luqman
5.0
review score of 5.0
Sales Management: Creating A Solid Foundation
"Was a great course and my expectations was met."
Hennie Hayman
5.0
review score of 5.0
Effective Communication Skills
"Very understandable"
Adeboye Mayor
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 365 (2019) Advanced
Microsoft Access 365 (2019) Advanced
Normal price: $48.99
{This course}
Click for a quick summary...
Summary
Includes Primary Keys, Linking, ODBC & SQL Server, Macros, VBA, Forms, Advanced Queries, Packaging
[ close ]
Microsoft Access 365 (2019) Beginners
Microsoft Access 365 (2019) Beginners
Normal price: $48.99
{Related course}
Click for a quick summary...
Summary
Includes Primary Keys, Linking, ODBC & SQL Server, Macros, VBA, Forms, Advanced Queries, Packaging
[ close ]
See pricing options
Both courses

RRP: $97.99
You pay: $37.99
DISCOUNT: 61%

Grab Our
SITE RELAUNCH Offer ...

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