Microsoft Access 2016 Intermediate/Advanced Course
4.8 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,792 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access 2016 Intermediate/Advanced Course to your Wishlist.

Add to Wishlist

Microsoft Access 2016 Intermediate/Advanced Course

The ultimate next step for anyone interested in supercharging their Microsoft Access and data analysis skills
4.8 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,792 students enrolled
Created by Simon Sez IT
Last updated 8/2017
English
Price: Free
Includes:
  • 9 hours on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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 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 Curriculum
Requirements
  • A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases.
  • Microsoft Access 2016
Description

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.
  • Practice with bonus Access 2016 exercises.

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.

Plus, when you sign up for this course, you’ll also get these extras:

  1. Exercise files – to help you become proficient with the material.
  2. Instructor demo files – use the same database files used by your instructor.
  3. An optional online quiz (45 questions) - to test what you've learned.
  4. A certificate of completion - to tell everyone you've aced the course.

If you’re ready to master Microsoft Access 2016 and sign up for the course, go ahead and hit that Enroll button, or try some of the free videos by using the Free Preview feature. We look forward to seeing you in the course!

Who is the target audience?
  • Experienced database managers or those who are familiar with Access 2016 or 2013
Students Who Viewed This Course Also Viewed
Curriculum For This Course
51 Lectures
09:05:54
+
Introduction to Microsoft Access 2016 Advanced
4 Lectures 11:31
Course Overview and Content
09:04

Essential Information for a Successful Training Experience
01:36

Course Exercise Files
00:25

Course Demo Files
00:25

Section 1
1 question
+
Primary Keys and Indexes
2 Lectures 21:21
Primary Keys and Indexing Rules and Guidelines
12:15

More About Indexes
09:06

Section 2
2 questions
+
Using Datasheet View
5 Lectures 46:10
Setting-up Northwind Database
04:44

Working in a Datasheet View
13:06

Customizing Datasheet View and Advanced Sorting and Filtering
16:10

Subdatasheets
11:04

Exercise 01
01:06

Section 3
5 questions
+
Linking to Other Access Databases
1 Lecture 15:38
Linking Two Tables to Other Access Databases
15:38

Section 4
1 question
+
Using ODBC and SQL Server
3 Lectures 30:43
Acquiring and Installing SQL Server Express
14:31

Setting up SQL Server Database
14:56

Exercise 2
01:16

Section 5
3 questions
+
Splitting An Access Database
4 Lectures 44:00
Splitting an Access Database into Front-end and Back-end Databases
12:04

Converting Shared Table into Local Table; Moving Back-end Database
13:55

Exercise 3
01:57

Addressing Multi-users Issues When Sharing Data
16:04

Section 6
4 questions
+
Macros
5 Lectures 58:48
Basics of Macros
13:35

Macros on Events; AutoExec
14:34

More About AutoExec; Bypassing AutoExec
16:20

Macro Security Settings
08:36

Exercise 4
05:43

Section 7
5 questions
+
The Ribbon
1 Lecture 13:56
Customizing the Ribbon and Quick Access Tool
13:56

Section 8
1 question
+
Visual Basic for Applications in Access 2016
5 Lectures 01:16:43
Convert Macros to VBA; VBA Editor and Property Windows
14:26

VBA Modules; Running Code and Error Handling
16:32

Creating Modules; Subs, Functions, Intellisense and Variables
14:47

Scope, Variable Naming and Strings
15:17

Standard Functions; Logical, Case and Loop Statements
15:41

Section 9
6 questions
+
Access Events Model
5 Lectures 59:21
Adding Events to Assets Database
14:34

Exercise 05
02:19

Common Events; Form and Report Events
15:45

Switchboard and Navigation Form; Error Handling
16:28

Exercise 06
10:15

Section 10
5 questions
4 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
11,582 Reviews
304,137 Students
117 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.