Microsoft Access 2016 for Beginners: Master the Essentials
4.4 (87 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.
1,228 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access 2016 for Beginners: Master the Essentials to your Wishlist.

Add to Wishlist

Microsoft Access 2016 for Beginners: Master the Essentials

Fast, easy way to learn this important database application inside and out
4.4 (87 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.
1,228 students enrolled
Created by Simon Sez IT
Last updated 8/2017
English
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 11.5 hours on-demand video
  • 4 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Practice what you learned with included exercise files
  • Sorting information and running queries
  • Creating tables and relationships
  • Navigating the Access 2016 interface
  • Design forms and generate reports
  • Learn valuable new skills for complex data projects at work
  • Supercharge your database projects
  • Discover how to into import data from Excel
  • Learn Queries, use validations, how to create and print reports
  • How to compact, repair and backup your database
  • How to create a linked table
  • Discover how to use the Query Wizard
  • Learn to use Model Dialog and Macros
View Curriculum
Requirements
  • Microsoft Access 2016
Description

Everyone will rely on you as a superstar user of Access 2016 with this comprehensive 10-hour course comprising more than 70 video tutorials.

  • No Microsoft Access experience needed as it starts from the very beginning
  • 70 expertly produced videos with a full 10 hours of instruction
  • Work at your own pace in your spare time
  • Makes all aspects of Access easy to master while covering exciting features new in 2016
  • Benefit from learning to use the full program, not just the basics
  • Get up and running quickly and immediately learn things you can use at work
  • Supercharge your personal projects
  • Practice what you learned with helpful exercise files
  • Become the MS Access expert everyone appreciates

Microsoft Access 2016 for Beginners: Master the Essentials is the ultimate video instruction course for those who have no previous experience with this powerful software. Now you can get the full picture of how Microsoft Access works with clear, easy to understand instruction in this impressive 10-hour course spread across 70 professionally produced videos.

Microsoft Access is the leading database application that has become a standard in businesses and organizations around the world. These days, having the ability to work with a database is key to running an efficient and capable operation. Bosses everywhere appreciate any employee who is well trained in MS Access. Now that person can be you!

Increase your value in the workplace by mastering one of the most important but little understood options in MS Office. You'll see how it gives you major advantages with your personal and social projects. Also great for people who are already familiar with MS Access, our courses are designed to allow you to skip ahead to more advanced processes and explore all that's new in version 2016.

 Contents and Overview

Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016.

You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases.

After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency.

You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture.

Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects.

This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016.

** Updated July 2017. Course transcripts now available.

Who is the target audience?
  • Anyone new to Microsoft Access
  • Users new to Microsoft Access 2016 and those upgrading from previous software versions
  • Anyone new to the data management role
  • Anyone who wants to learn data management and Microsoft Access
Students Who Viewed This Course Also Viewed
Curriculum For This Course
75 Lectures
11:29:14
+
Introduction
8 Lectures 22:56

Essential Information for a Successful Training Experience
01:54

Course Exercise Files
00:24

Course Demo Files
00:25

Downloadable Course Transcripts
00:20


Structure of the Course
02:17

What's New in Access 2016
02:32

Section 1 - Quiz
1 question
+
Using Touch
1 Lecture 07:05
Using Access in a Touch Device
07:05

Section 2 - Quiz
1 question
+
Getting Started
3 Lectures 37:15
Using Database Templates
14:46

Creating, Saving, and Opening Databases
08:45

The Access Workspace and Backstage
13:44

Section 3 - Quiz
1 question
+
Help
1 Lecture 09:17
Online Help and Tell Me
09:17

Section 4 - Quiz
1 question
+
The Ribbon and Toolbars
4 Lectures 23:20
The Ribbon
09:53

The Quick Access Toolbar
05:31

Contextual Menus
03:51

The Status Bar
04:05

Section 5 - Quiz
4 questions
+
Keyboard Shortcuts and Key Tips
2 Lectures 06:44
Keyboard Shortcuts
03:34

Key Tips
03:10

Section 6 - Quiz
1 question
+
Access Options
1 Lecture 12:03
General, Current Databases, and Language Options
12:03

Section 7 - Quiz
2 questions
+
Tables
5 Lectures 55:58
Creating a Table and Fields
14:45

Indexed Field
11:37

Lookup Wizard
14:31

Numeric Fields
10:43

Exercise 01
04:22

Section 8 - Quiz
6 questions
+
Importing Data
2 Lectures 20:18
Importing Data from Excel
14:59

Exercise 02
05:19

Section 9 - Quiz
2 questions
+
Backup, Restore, and Repair
2 Lectures 14:04
Backing up your Database
06:45

Compact and Repair
07:19

Section 10 - Quiz
1 question
18 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
11,481 Reviews
303,048 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.