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

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
$ 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

SUMMER 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

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
$ 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

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
SUMMER 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 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

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 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 ]
Microsoft Access 2013/2016 Advanced
Microsoft Access 2013/2016 Advanced
[Video course]
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 ]

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
SUMMER 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