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) Beginners

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) Beginners
&
Microsoft Access 365 (2019) Advanced

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) Beginners

Microsoft Access 365 (2019) Beginners

A Premier Microsoft Access training course from ZandaX

Quick Summary: What You Get

Introduction
Getting Started with Access 2019
The Ribbon and Toolbars
Keyboard Shortcuts and Key Tips
Access Options
Tables
Importing Data
Backup, Restore and Repair
Datasheet View
Relationships
Forms
Subforms
Queries
Expressions
Reports
Printing
More Data Types
More About Forms
Exporting
Application Parts
More Access Options
Info Tab
Course Close

Who's this course for?

The course is intended for new users of Microsoft Access who want to become productive in the shortest possible time.

Course requirements

You should be proficient in using a PC with the Windows operating system. No prior experience with Access is required, though familiarity with Microsoft Excel is preferable.

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

Build Your Database Skills the Right Way!

Microsoft Access is a great tool for when your data outgrows spreadsheets: it's user-friendly and ideal for general office users.

Our Microsoft Access Beginners course has been designed for new users of MS Access who want to become productive in the shortest time.

It's also recommended for people who haven't had formal training, but aren't performing so well because they don't fully understand how to use the application properly.

In this course, we start at the beginning, assuming you know nothing about Microsoft Access, and take a project approach, which means you build your database as we go along.

By the end of the course, you'll have a functioning database that you can use as a model and reminder for future work.

Course content in detail

Click a RH arrow   (
)   to reveal the lessons

01
Introduction
4 sections
»
Introduction to Access 2019
»
Acquiring Access 2019
»
Structure of the Course
»
Course Exercise Files

02
Getting Started with Access 2019
4 sections
»
Using Database Templates
»
Creating, Saving and Opening Databases
»
The Access Workspace and Backstage
»
Online Help and Tell Me What You Want To Do

03
The Ribbon and Toolbars
4 sections
»
Working with the Ribbon
»
The Quick Access Toolbar
»
Contextual Menus
»
The Status Bar

04
Keyboard Shortcuts and Key Tips
2 sections
»
Keyboard Shortcuts
»
Key Tips

05
Access Options
1 section
»
Exploring Access Options

06
Tables
5 sections
»
Creating a Table and Fields
»
Indexed Field
»
Lookup Wizard
»
Numeric Fields
»
Practice Exercise 01

07
Importing Data
2 sections
»
Importing Data from Excel
»
Practice Exercise 02

08
Backup, Restore and Repair
2 sections
»
Backing up your Database
»
Compact and Repair

09
Datasheet View
3 sections
»
Design in the Datasheet View
»
Sorting and Filtering in Datasheet View
»
Entering and Modifying Data in Datasheet View

10
Relationships
3 sections
»
Creating a Link Table
»
Setting up Relationships
»
Practice Exercise 03

11
Forms
7 sections
»
Creating a Form
»
Modifying a Form
»
Practice Exercise 04
»
Forms in Layout View
»
Forms in Design View
»
Form Design
»
Practice Exercise 05

12
Subforms
4 sections
»
Setting Up Subforms - Part 1
»
Setting Up Subforms - Part 2
»
Setting Up Subforms - Part 3
»
Practice Exercise 06

13
Queries
4 sections
»
Creating a Query
»
Joins
»
Query Wizard
»
Practice Exercise 07

14
Expressions
2 sections
»
Setting Up Validations
»
Calculation using Expressions

15
Reports
4 sections
»
Basic Reports
»
Report Design
»
Complex Reports
»
Practice Exercise 08

16
Printing
1 section
»
Printing and Print Properties

17
More Data Types
1 section
»
Yes/No, OLE Objects and Hyperlink Data Types

18
More About Forms
3 sections
»
Form Controls
»
Form Themes
»
Navigation Forms

19
Exporting
1 section
»
Exporting an Access Database

20
Application Parts
1 section
»
Adding Application Parts to a Database

21
More Access Options
1 section
»
Additional Access 2019 Options

22
Info Tab
1 section
»
Edit Database Properties and Encrypt with Password

23
Course Close
1 section
»
Course Close

People also bought

See these SITE RELAUNCH Offer prices!
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 ]
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 ]

What learners say about ZandaX

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

review score of 5.0
Conflict Management & Resolution
"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
Creating & Leading High-Performance Teams
"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
Creating & Leading High-Performance Teams
"So much in here, and I already have plans to improve my team!"
Nicki Scott
5.0
review score of 5.0
"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
"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
Conflict Management & Resolution
"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) Beginners
Microsoft Access 365 (2019) Beginners
Normal price: $48.99
{This course}
Click for a quick summary...
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
Normal price: $48.99
{Related course}
Click for a quick summary...
Summary
Includes Getting Started, Using the Interface, Tables, Importing Data, Backing Up, Relationships, Forms, Queries, Reports, Printing, Exporting
[ 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