Microsoft Access 2016 Intermediate Advanced Course

The ultimate next step for anyone interested in supercharging their Microsoft Access and data analysis skills

Instructed by Simon Sez IT

Want to learn more?
Go for Premium Subscription

Choose your plan:

  • Monthly
  • Annually
$ 29
Monthly Subscription
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
Need Help?

Call +1 855 999 1795

( Toll Free )
  • Experienced database managers or those who are familiar with Access 2016 or 2013

Become a Microsoft Access database expert with this easy-to-follow course featuring 8 hours of professionally produced videos. Exercise and demo files included.

Practice what you learn with included exercise files.

A full 8 hours of professional video instruction.

48 easy-to-follow how-to videos.

Everything explained step-by-step for quick comprehension.

Complete database projects at the advanced level.

The next step after completing Microsoft Access 2016 for Beginners.

Enables you to complete projects on time and within budget.

Increase your value at work.

Starts with basic advanced features.

Discover how to effectively link to other data sources.

Learn how to split a database by splitting the frontend and backend.

Follow along as you learn to create and maintain macros.

Explore the use of Visual Basic for Applications (VBA).

Discover advanced options for the use of forms and queries.

Dive into options for packaging your application for distribution.

In today’s data-driven world, effective data management is crucial, with no room for error. If you’ve already taken our beginner Microsoft Access 2016 course, or have a beginner knowledge of Microsoft Access 2016, you’re ready for our Microsoft Access 2016 Advanced course. Get ready to become a data management expert as this 8-hour class takes your skills to the next level.

You’ll boost your knowledge significantly as you get acquainted with Microsoft Access 2016’s most sophisticated features.

Contents and Overview

Your Microsoft certified professional trainer will show you how to use macros, advanced forms and queries, and other tools to create a professional, working database. Follow along as you learn to create and maintain macros, then see how to effectively link to other data sources.

Get helpful techniques that allow you to link, report, and package your data quickly, and discover how to split a database by splitting the frontend and backend.

With this informative course, you’ll learn the skills you need to make an impact with sleek, high-performing databases that help you do your job efficiently and competently.

  • A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases.
  • Microsoft Access 2016
  • 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 2016 exercises files.
  • Follow along with the instructor with included instructor demostration 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.
View More...

Section 1 : Chapter 1:Introduction to Microsoft Access 2016 Advanced

  • Lecture 1 :
  • Lecture 2 :
  • Instructor Demostration Files
  • Lecture 3 :
  • Course Overview and Content

Section 2 : Chapter 2: Primary Keys and Indexes

  • Lecture 1 :
  • Primary Keys and Indexing Rules and Guidelines
  • Lecture 2 :
  • More About Indexes

Section 3 : Chapter 3: Using Datasheet View

  • Lecture 1 :
  • Setting Up Northwind Database
  • Lecture 2 :
  • Working in a Datasheet View
  • Lecture 3 :
  • Customizing Datasheet View and Advanced Sorting and Filtering
  • Lecture 4 :
  • Subdatasheets
  • Lecture 5 :
  • Exercise 01

Section 4 : Chapter 4: Linking to Other Access Databases

  • Lecture 1 :
  • Linking Two Tables to Other Access Databases

Section 5 : Chapter 5: Using ODBC and SQL Server

  • Lecture 1 :
  • Acquiring and Installing SQL Server Express
  • Lecture 2 :
  • Setting Up SQL Server Database
  • Lecture 3 :
  • Exercise 2

Section 6 : Chapter 6: Splitting An Access Database

  • Lecture 1 :
  • Splitting an Access Database into Front-end and Back-end Databases
  • Lecture 2 :
  • Converting Shared Table into Local Table; Moving Back-end Database
  • Lecture 3 :
  • Exercise 03
  • Lecture 4 :
  • Addressing Multi-users Issues When Sharing Data

Section 7 : Chapter 7: Macros

  • Lecture 1 :
  • Basics of Macros
  • Lecture 2 :
  • Macros on Events; AutoExec
  • Lecture 3 :
  • More About AutoExec; Bypassing AutoExec
  • Lecture 4 :
  • Macro Security Settings
  • Lecture 5 :
  • Exercise 04

Section 8 : Chapter 8: The Ribbon

  • Lecture 1 :
  • Customizing the Ribbon and Quick Access Tool

Section 9 : Chapter 9: Visual Basic for Applications in Access 2016

  • Lecture 1 :
  • Convert Macros to VBA; VBA Editor and Property Windows
  • Lecture 2 :
  • VBA Modules; Running Code and Error Handling
  • Lecture 3 :
  • Creating Modules; Subs, Functions, Intellisense and Variables
  • Lecture 4 :
  • Scope, Variable Naming and Strings
  • Lecture 5 :
  • Standard Functions; Logical, Case and Loop Statements

Section 10 : Chapter 10: Access Events ModelChapter 10: Access Events Model

  • Lecture 1 :
  • Adding Events to Assets Database
  • Lecture 2 :
  • Exercise 05
  • Lecture 3 :
  • Common Events; Form and Report Events
  • Lecture 4 :
  • Switchboard and Navigation Form; Error Handling
  • Lecture 5 :
  • Exercise 06

Section 11 : Chapter 11: Forms

  • Lecture 1 :
  • Formatting Bound and Control Form
  • Lecture 2 :
  • Split Forms; Macro Error Handling
  • Lecture 3 :
  • Creating Form with Tab
  • Lecture 4 :
  • Go To Combo Box and Its Properties
  • Lecture 5 :
  • Exercise 07

Section 12 : Chapter 12: Advanced Use of Queries

  • Lecture 1 :
  • Basic of Queries: Review
  • Lecture 2 :
  • Syntax of SQL Statements
  • Lecture 3 :
  • Use of Multiple Where Criteria & Select Statements Function
  • Lecture 4 :
  • Joins and Its Types
  • Lecture 5 :
  • Exercise 08
  • Lecture 6 :
  • Action Queries - Part 1
  • Lecture 7 :
  • Action Queries - Part 2
  • Lecture 8 :
  • Subqueries

Section 13 : Chapter 13: Packaging Your Application

  • Lecture 1 :
  • Steps in Packaging Access Application
  • Lecture 2 :
  • Exercise 09

Section 14 : Chapter 14: Conclusion

  • Lecture 1 :
  • Online Support and Conclusion

Simon Sez IT,

Simon Sez IT has been teaching online for over ten years. It all started when the owner, Chris “Simon” Calder was working as a Project Manager in IT. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel. ®️ Our approach to teaching comes from our passion to fully explain how something works. We don’t skirt around the edges. We think that if you’re going to teach something, teach it right. Take the time to explain the ins and outs, back it up with practice exercises and tests and always teach in a visually easy to follow way - video. We only hire the best authors to teach and our style is to take the time to explain things in the detail they deserve. That means our courses are perfect if you’re new to a certain technology or just technology shy in general. Simon Sez IT makes business and technical software simple to learn. We are experts in teaching people how to use the world's most popular software including Microsoft Office, Adobe Photoshop Elements and QuickBooks. We help people increase their productivity, achieve their personal and professional goals and get home from work that little bit earlier.
View More...
cisco-ccna-r-s-200-125-the-complete-course

Cisco CCNA R/S (200-125): The Compl...

By : Lazaro (Laz) Diaz

Lecture 153

ccnp-switch-300-115-the-complete-course

CCNP Switch (300-115): The Complete...

By : Lazaro (Laz) Diaz

Lecture 93

ccna-wireless-200-355-the-complete-course

CCNA Wireless (200-355): The Comple...

By : Lazaro (Laz) Diaz

Lecture 41

odoo-the-complete-master-class-beginner-to-professional

Odoo: The complete Master Class: B...

By : Abhilash Nelson

Lecture 32

convert-hex-to-decimal-in-under-30-seconds

Convert Hex to Decimal in under 30 ...

By : Lazaro (Laz) Diaz

Lecture 20

cisco-eigrp-comprehensive-labs-course

Cisco EIGRP Comprehensive Labs Cour...

By : Lazaro (Laz) Diaz

Lecture 10

Buy

$15

Enjoy Limitless Learning. Get Access to Unlimited Courses with Premium Subscrption Subscribe Now