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

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

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

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
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 provide, there's no better option in the market"
ZandaX LinkedIn logo
ZandaX YouTube logo
ZandaX FaceBook logo
 
All content © ZandaX 2024