Microsoft Access 2016: Intermediate & Advanced Course

Microsoft Access 2016 Intermediate Advanced Course

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

Created by : Rated :4.8 90220 views

Last Updated: 2024-11-21 07:11:55 English Course Type: Self Learning

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.

Section 1 : Chapter 1:Introduction to Microsoft Access 2016 Advanced 3 Lectures 00:09:05
Lecture 1 :
Course Exercise Files Preview
Lecture 2 :
Instructor Demostration Files
Lecture 3 :
Course Overview and Content
Section 2 : Chapter 2: Primary Keys and Indexes 2 Lectures 00:21:23
Lecture 1 :
Primary Keys and Indexing Rules and Guidelines
Lecture 2 :
More About Indexes
Section 3 : Chapter 3: Using Datasheet View 5 Lectures 00:46:15
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 1 Lectures 00:15:39
Lecture 1 :
Linking Two Tables to Other Access Databases
Section 5 : Chapter 5: Using ODBC and SQL Server 3 Lectures 00:30:46
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 4 Lectures 00:44:04
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 5 Lectures 00:58:53
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 1 Lectures 00:13:56
Lecture 1 :
Customizing the Ribbon and Quick Access Tool
Section 9 : Chapter 9: Visual Basic for Applications in Access 2016 5 Lectures 01:16:47
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 5 Lectures 00:59:25
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 5 Lectures 01:03:23
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 8 Lectures 01:23:07
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 2 Lectures 00:16:39
Lecture 1 :
Steps in Packaging Access Application
Lecture 2 :
Exercise 09
Section 14 : Chapter 14: Conclusion 1 Lectures 00:04:55
Lecture 1 :
Online Support and Conclusion

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
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.
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.
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.
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.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Simon Sez IT,

148165 Course Views

2 Courses

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.