Advanced Microsoft Access Online Course: 2019/365 Edition

Created by Simon Sez IT

Table of contents

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.

Requirements

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

Description

In this course, we will begin where the novice’s course ends and will dive straight into more advanced features of Access. In this course, we will presume that already know the core of Microsoft Access, including setting up tables or database’s, building a common form and running a basic query.

In this course, we will be implementing even more Macros and VBA in MS Access as well as ODBC and SQL Server. If you’ve been using Access for a while and are searching for a way to take your wisdom to the next level then this course is meant for you.

Course content

15 sections • 50 lectures • 7h 36m total length

  • Introduction
  • Primary Keys and Indexes
  • Using Datasheet View
  • Linking to Other Access Database
  • Using ODBC and SQL Server
  • Splitting an Access Database
  • Macros
  • The Ribbon
  • Visual Basic for Applications
  • Access Events Model
  • Forms
  • Advanced Use of Queries
  • Packaging You Application
  • Extras
  • Conclusion

HOW TO DOWNLOAD

https://youtu.be/kEBqA1Xq2ak

Who this course is for:

  • People who are Experienced or experts at database managers or are native with Access 2016 or 2013

NOTICE

WE ARE USING THIRD PARTY CLOUD STORAGE IF IN CASE OF A BROKEN LINK, YOU CAN REPORT US ON TELEGRAM OR YOU CAN LEAVE A COMMENTS BELOW :- CLICK HERE

Leave a Comment