Access 2019 Advanced

Loading the player ...

Description
Course Resources

DURATION: 7.34 hours
VIDEOS: 46
LEVEL: Advanced

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 advanced course, we start where the beginner’s course finishes and dives straight into more advanced Access features. This course assumes you know the basics of Access, including how to set up your database, how tables work, how to create forms, and how to run simple queries.

In this advanced Access course, we look at using ODBC and SQL Server. We also take a deeper dive on using Macros and VBA in Access, splitting databases and advanced form creation. It’s perfect if you have a working knowledge of Access but need to utilize it’s more advanced features.

In this course you will learn:

All about Primary Keys and Indexes in Access
About customizing and filtering on the Datasheet View
How to link to other databases
All about using ODBC and SQL Server
How to split an Access database into front and back-end
All about Macros in Access including AutoExec
How to do basic VBA in Access including code and error handling
More advanced techniques around creating forms in Access
Advanced queries including “multiple where” criteria

Course Format

This is a video-led Microsoft Word 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 Advanced

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

Click on the below to open DropBox in a new browser tab, then click on “Download” in the top right-hand corner. Once downloaded all of the exercise files will be available to you.

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