Introduction to Microsoft Access 2016 for Absolute Beginners
4.1 (42 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,772 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to Microsoft Access 2016 for Absolute Beginners to your Wishlist.

Add to Wishlist

Introduction to Microsoft Access 2016 for Absolute Beginners

Learn the essentials of Microsoft Access 2016 in easy to follow steps
4.1 (42 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,772 students enrolled
Created by Simon Sez IT
Last updated 7/2017
English
English
Price: Free
Includes:
  • 4.5 hours on-demand video
  • 4 Articles
  • 2 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
  • Creating tables and relationships
  • Navigating the Access 2016 interface
  • Learn valuable new skills for complex data projects at work
  • Discover how to into import data from Excel into your database
  • Creating, saving and opening an Access 2016 database
  • Working with and using index fields
  • How to backup and repair your database
View Curriculum
Requirements
  • Microsoft Access 2016 desktop version for Windows installed on your computer
Description

During this introductory course on using Microsoft Access 2016, we'll teach the basics of using Microsoft Access 2016.

We'll start with navigating the Access 2016 interface, including the Ribbon, Backstage View and the Quick Access Toolbar.

Discover concepts to help you understand how to create database fields and tables, using numeric and indexed fields, and importing data from Excel into your database.

Contents and Overview

This easy to understand course starts at the very beginning, specifically designed for those with little or no Microsoft Access experience. The first task is to find the software and install it on your computer.

Then we discover the new and improved features added to the 2016 version. There are new features that could be a big help in your job, your business, or in personal projects.

We start with essential first steps. You will learn to create an Access database, save it, then open it. We show you simple ways to use Microsoft's powerful online and contextual help, so you are never left wondering when you have a question or encounter a challenge.

Along the way we keep in mind you will want to personalize Access to accomplish the things you want. We learn all about Ribbons and Toolbars that make Access extremely flexible.

Next, we move on to create tables and fields to store your data, in addition to discussing the use of indexed and numeric fields.

All along the way there are plenty of exercises and quizzes that help you fully understand all the concepts and solidify them in your memory.

This is the course you need to learn the most important ways to expertly use MS Access 2016. It assumes you are just beginning with Access and easily steps you through the process of being highly proficient with this widely used tool.

This course is for absolute beginners, thus is appropriate for those new to Access and who appreciate a methodical, patient and conversational pace.

** Updated July 2017. English close captions added

Who is the target audience?
  • Anyone new to Microsoft Access
  • No previous knowledge of MS Access required. This course is created for absolute beginners.
  • Anyone new to the data management role
  • Anyone who wants to learn data management and Microsoft Access
  • Users of earlier versions of Access looking to update their skills.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
35 Lectures
04:41:03
+
Introduction
7 Lectures 22:40
Introduction to Access 2016 Course
06:19

Essential Information for a Successful Training Experience
01:56

Course Exercise Files
00:25

Course Demo Files
00:26

Acquiring Access 2016
08:44

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
2 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
11,565 Reviews
303,927 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.