Browse Library

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

5 days left at this price!
  • Single Course access $25 $70 64% off
    Buy
    Buy
    $25
    It Includes:
    Get access to this course only.
    Access to all marketplace courses
    Lifetime Course Access
    Play & Pause Videos
    High Quality Recorded Lectures
    Learn Online from Mobile/PC/Tablet
    Download Course for Offline Viewing
    Inlcudes Real Projects
    Free Instructor Support
  • 1 Month Full Access$19/moLimited offer! (Access 3000+ courses)
    Buy
    Buy
    $19
    It Includes:
    Get Monthly Unlimited Access (1 user)
    Access to all marketplace courses
    Play & Pause Videos
    High Quality Recorded Lectures
    Learn Online from Mobile/PC/Tablet
    Download Course for Offline Viewing
    Inlcudes Real Projects
    Certificate of Completion
    Free Instructor Support
  • Monthly $15/Per user (min 5 users) ($14/user/mo)
    Buy
    Buy
    $15
    It Includes:
    All Personal plan features +
    Best for small teams or Business
    Unlimited access for team
    Admin Dashboard & Analytics
    Basic reporting
    User Management
    Custom Branding Options
  • Yearly $169/Per user (min 5 users) ($14/user/mo)
    Buy
    Buy
    $169
    It Includes:
    All Personal plan features +
    Best for small teams or Business
    Unlimited access for team
    Admin Dashboard & Analytics
    Basic reporting
    User Management
    Custom Branding Options
  • 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
  • 1. How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • 2. Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • 3. Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • 4. How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • 5. Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • 6. Do i get any certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • 7. For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • 8. Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • 9. Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • 10. What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

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

implementing-configuring-cisco-routers-part-1

Implementing & Configuring Cisco Ro...

By : Dariusz Lipski

Lecture 10

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

Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Forget Password