Microsoft Office Access 2016 Intermediate
3.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4 students enrolled

Microsoft Office Access 2016 Intermediate

Access 2016 Intermediate
3.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4 students enrolled
Last updated 11/2018
English
English [Auto]
Current price: $119.99 Original price: $199.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Design a relational database
  • Create a table
  • Create query joins
  • Relate data within a table
  • Work with sub-datasheets
  • Use field, form and record validation
  • Create parameter queries and sub-queries
  • Create unmatched and duplicate queries
  • Normalize and de-normalize data
  • Include control formatting in a report
  • Add a calculated field to a report
Requirements
  • The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or Microsoft Office 2010 especially Microsoft Office Access 2016.
  • In addition to that, a good knowledge of getting around with Microsoft Windows 10 is required as well.
  • The course is part of the three course series on Microsoft Office Access 2016.
  • It is recommended that the students complete the previous level before opting for this course.
Description

The Microsoft Office Access 2016: Intermediate course builds upon basic Microsoft Access skills acquired in Access Basic course to help students become power users. In this Microsoft Access course, students will delve deeper into the program by studying topics such as how to manage data and data entry, create forms and dialog boxes, split databases, and much more. The course focuses on the Access 2016 topics such as designing a relational database, joining tables, using data validation, creating advanced queries, organizing a database for efficiency and using advanced reporting techniques.

Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2016 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2016.

Who this course is for:
  • Individuals looking to update their skill-set to Microsoft Office Access 2016
  • Data entry operators
  • Writers and publishers
  • Candidates seeking to move to the latest version of Microsoft Office Access
Course content
Expand all 111 lectures 02:45:20
+ Chapter 01 - Designing a Relational Database
30 lectures 34:14
Designing a Relational Database
00:57
Topic A: Relational Database Design
00:07
Database Relationship
01:27
Relational Database Design Process
01:17
Statement of Purpose
00:34
Existing Data
00:35
Primary Keys
01:13
Primary and Foreign Keys
00:32
Composite Keys
00:39
One-to-One Relationships
01:15
One-to-Many Relationships
00:41
Relationships Window
00:30
Guidelines for Designing Databases
01:43
Demo - Exploring Table Relationships
03:39
Topic B: Create a Table
00:07
Table Views
01:21
List of Data Types
01:07
Calendar for Picking Dates
00:24
Lookup Wizard
01:22
The Table Properties Dialog Box
00:22
Demo - Creating a Table
04:28
Topic C: Create Table Relationships
00:11
Enforce Referential Integrity Options
00:54
Join Lines
00:32
Relationship Reports
00:21
Guidelines for Enforcing Referential Integrity
00:48
Demo - Creating a Table Relationship
04:01
Chapter 01 Review
00:29
Review - Question
6 questions
+ Chapter 02 - Joining Tables
17 lectures 23:40
Joining Tables
00:40
Topic A: Create Query Joins
00:12
Inner Joins
00:43
Left and Right Outer Joins
01:00
Join Properties Dialog Box
00:24
What the Join Options Return
01:12
An Unrelated Table Join
00:56
Demo - Creating Inner and Outer Joins
04:33
Demo - Joining Unrelated Tables
03:14
Topic B: Relate Data Within a Table
00:08
Demo - Creating a Self Join
02:47
Topic C: Work with Subdatasheets
00:09
Subdatasheets
00:58
Demo - Modifying Data in a Subdatashee
03:24
Chapter 02 Review
00:37
Review - Question
5 questions
+ Chapter 03 - Using Data Validation
15 lectures 30:23
Using Data Validation
01:58
Topic A: Use Field Validation
00:10
Field Properties
00:54
Input Masks
00:37
Input Mask Wizard
00:30
Demo - Validating Data by Using a Field Property
06:10
Demo - Validating Data by Using an Input Mask
04:03
Topic B: Use Form and Record Validation
00:08
The Combo Box Wizard
00:55
List Box Control
00:41
Option Group Control
01:09
Demo - Using a Record Validation Rule
04:48
Chapter 03 Review
00:31
Review - Question
5 questions
+ Chapter 04 - Creating Advanced Queries
22 lectures 36:50
Topic A: Create Parameter Queries
00:09
A Parameter Query Displays a Prompt
01:59
Demo - Creating a Parameter Query
03:05
Demo - Using Wildcards in a Parameter Query
03:18
Demo - Creating a Query with Multiple Parameters
02:05
Topic B: Summarize Data
00:06
Crosstab Query Wizard
01:50
Analyzing Customer Payments
00:56
Demo - Creating a Crosstab Query
03:07
Topic C: Create Subqueries
00:09
Subquery Example
01:22
Subquery Expression Example
00:56
Demo - Creating Subqueries
04:45
Topic D: Create Action Queries
00:08
Action Query Update Expression
01:07
Demo - Creating Action Queries
04:09
Topic E: Create Unmatched and Duplicate Queries
00:05
Find Unmatched Query Wizard
01:08
Demo - Creating Queries to Search for Unmatched and Duplicate Records
03:56
Chapter 04 Review
00:48
Review - Question
5 questions
+ Chapter 05 - Organizing a Database for Efficiency
14 lectures 19:24
Organizing a Database for Efficiency
00:36
Topic A: Data Normalization
00:09
First Normal Form
02:01
Second Normal Form
01:07
Denormalization
00:59
Table Analyzer Wizard
00:25
Demo - Running the Table Analyzer Wizard
03:18
Topic B: Create a Junction Table
00:08
Demo - Using a Junction Table to Resolve a Many-to-Many Relationship
02:56
Topic C: Improve Table Structure
00:07
Demo - Improving Table Structure
04:52
Chapter 05 Review
00:35
Review - Question
5 questions
+ Chapter 06 - Using Advanced Reporting Techniques
10 lectures 17:27
Using Advanced Reporting Techniques
00:32
Topic A: Include Control Formatting in a Report
00:06
Demo - Adding Data Bars to a Report
02:34
Topic B: Add a Calculated Field to a Report
00:08
Topic C: Add a Subreport to an Existing Report
00:09
Demo - Adding a Subreport to an Existing Report
06:48
Chapter 06 Review
00:29
Course Closure
01:19
Review - Question
5 questions