Access 2019

Loading the player ...

Description
Course Resources

DURATION: 8.7 hours
VIDEOS: 60
LEVEL: Beginner

Microsoft Access remains a fantastic tool for when your data outgrows spreadsheets. Unlike many other database tools, it’s far more user-friendly and ideal if you’re not a developer.

In this Microsoft Access 2019 beginners course, we start at the very beginning and assume you know nothing about MS Access. We take a project approach to this course, which means you build your project out as we go. By the end of this Access 2019 course, you will have built out your database with proper functionality.

If you’ve used Excel in the past, that will help, but it’s not essential. This course is for someone just starting in Access.

In this course you will learn:

Where to start in Microsoft Access and whether to use a template or not
How to modify Access to suit your needs
All about importing data and the datasheet view
How tables work in Access and how to create relationships between them
Creating forms and sub-forms that feed data into your tables
How to run queries in Access
Setting up validations and calculations using expressions in Access
Printing from Access
To start to use macros and Modal Dialog
The basics of the Access web app
Exporting and reporting in Access

Course Format

This is a video-led training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users.

This course is also suitable for Office 365 users.

Access 2019

The course exercise demo files include 2 .ZIP files. You will need to download the Access 2019 Exercise Files.zip and the Access 2019 Course Files.zip to your PC or Mac (the files are not compatible with a mobile device) and unzip the file.

Click on the below to open DropBox in a new browser tab, then click on “Download” in the top right-hand corner. Once downloaded you can unzip the folder and all of the exercise files will reside in individual folders.

What people are saying

"I enjoyed the course and it was presented in an orderly fashion with incremental information that gave an intuitive feel to the progression. Thank you"

JOHN BROWN

"I was able to learn a lot from this course and to do so at my own pace. I was able to review areas where I needed more time than someone more advanced than I. For monetary investment, this is a great course for beginners."

DAVID F. WILSON

"Great and informative. Easy to understand and the courses don't overload you with too much information at once."

BRENNAN WEBER

"Very easy to follow and understand. I enjoy the step by step explanations and all the tips. Very detailed course. Easy to follow the teacher with a voice that does not bore."

SHARON FAJARDO