Advanced Microsoft Access Online Course: 2019/365 Edition

Become a Microsoft Access expert with this Advanced Access course for 2019 and MS 365 Users

**This course includes practice exercises and LIFETIME access**

What you’ll learn

  • Discover how to effectively link to other data sources..
  • Learn how to split a database by splitting the frontend and backend..
  • Explore the use of Visual Basic for Applications (VBA)..
  • Discover advanced options for the use of forms..
  • Dive into options for packaging your application for distribution..
  • Practice with included Access 2019 exercises files..
  • Discover advanced options and tips for building and using queries..
  • Follow along as you learn to create and maintain macros..
  • Complete database projects at the advanced level..
  • Get helpful techniques that allow you to link, report, and package your data quickly..

Course Content

  • Introduction –> 4 lectures • 8min.
  • Primary Keys and Indexes –> 2 lectures • 19min.
  • Using Datasheet View –> 5 lectures • 42min.
  • Linking to Other Access Database –> 1 lecture • 13min.
  • Using ODBC and SQL Server –> 3 lectures • 27min.
  • Splitting an Access Database –> 4 lectures • 33min.
  • Macros –> 5 lectures • 52min.
  • The Ribbon –> 1 lecture • 13min.
  • Visual Basic for Applications –> 5 lectures • 1hr 9min.
  • Access Events Model –> 5 lectures • 47min.
  • Forms –> 5 lectures • 55min.
  • Advanced Use of Queries –> 6 lectures • 1hr 4min.
  • Packaging You Application –> 2 lectures • 14min.
  • Extras –> 1 lecture • 1min.
  • Conclusion –> 1 lecture • 1min.

Advanced Microsoft Access Online Course: 2019/365 Edition

Requirements

  • A working knowledge of Microsoft Access including how to create and manage databases..
  • Microsoft Access 2013, 2016, 2019 or 365.

**This course includes practice exercises and LIFETIME access**

 

Microsoft Access remains an amazing 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. In this course, we assume you know the basics of Microsoft Access, including how to set up a table or database, create a basic form and run a simple query.

In this advanced Access course, we look much more at using Macros and VBA in MS Access as well as ODBC and SQL Server. This course is ideal if you’ve been using Access for a while but are looking to take your knowledge to the next level.

 

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

***Exercise files included***

 

This course includes:

  1. 7 hours of video tutorials
  2. 46 individual video lectures
  3. Exercise files to practice what you learned
  4. Certificate of completion

 

Here’s what our students are saying…

“Great course so far! Starts off at a very basic level and explains all the functions of the access program which for a novice like me is very helpful. I like how the student works on the project with the instructor and I find this very effective in learning and retaining the material”

– John Fife

“Yes. Being a novice to Access, I appreciate getting all the detailed basics under my belt as we gradually progress into this powerful data base. I really enjoyed my journey through this Access course with my instructor . His presentation through all the modules was well explained and very in-depth with related examples and chances to practice what was taught.”

– James Habersham

“Fantastic course. Very well presented. Perfectly paced and thoroughly explained topics.

Really enjoyed learning access with this course.

– Daniel Bleakley

 

Did you know?

 

Simon Sez IT teaches all sorts of software, including:

– Microsoft Excel

– Microsoft PowerPoint

– Microsoft Word

– Microsoft Project

– Microsoft Outlook

– QuickBooks

– Photoshop Elements

– Web Development Languages

– And so much more!

Get Tutorial