Microsoft Office Access 2016: Part 2 (Intermediate)
4.5 (5 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.
345 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Office Access 2016: Part 2 (Intermediate) to your Wishlist.

Add to Wishlist

Microsoft Office Access 2016: Part 2 (Intermediate)

Expand your knowledge of relational database design, write advanced queries, validate data and customize reports.
4.5 (5 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.
345 students enrolled
Last updated 7/2017
English
English
Current price: $12 Original price: $25 Discount: 52% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Customize reports to organize the displayed information and produce specific print layouts.
View Curriculum
Requirements
  • To ensure your success, it is recommended you have completed Microsoft Office Access 2016: Part 1 or possess equivalent knowledge. It is also suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
Description

Your training and experience using Microsoft Access 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

Who is the target audience?
  • If you are wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports, this course is for you.
Compare to Other Microsoft Access Courses
Curriculum For This Course
40 Lectures
02:35:24
+
Designing a Relational Database
5 Lectures 22:12

It is important to take time offline to design a database that accurately and effectively meets your needs. (Relational Databases, The Relational Database Design Process, Primary Keys, Foreign Keys, Composite Keys)

Preview 02:35

In a relational database, the key fields play an important role. Lets take a closer look at Primary Keys, Foreign Keys and Composite Keys. (Primary Keys, Foreign Keys, Composite Keys)

Preview 02:28

Now that you have analyzed the relational database design process, let's review an existing database that has the table relationships already configured. (Table Relationships, One-to-One Relationships, One-to-Many Relationships, Guidelines for Designing Databases)

Explore Table Relationships
05:20

To store data in a database, you need to create tables. (Table Views, Data Types, Calendar for Picking Dates, Lookup Fields, Lookup Lists, Lookup Wizard)

Create a Table
08:15

After you have tables for each subject in your database, define table relationships to connect the data in the tables. By setting table relationships correctly from the start, you will ensure that data stays synchronized across all related tables. (Referential Integrity, Join Lines, Relationship Reports, Guidelines for Enforcing Referential Integrity)

Create a Table Relationship
03:34

Microsoft Access 2016 Part 2 Quiz 1
3 questions
+
Joining Tables
7 Lectures 17:58

You know how to create a table relationship in the Relationships window. In this topic, you will see how to create several different types of temporary relationships. The ability to join two or more tables and extract the data from them is one of the most powerful features of any relational database. (Lesson Introduction)

Preview 01:25

In this topic, you will see how to create several different types of temporary relationships. The ability to join two or more tables and extract the data from them is one of the most powerful features of any relational database.

Preview 02:07

In this topic, you will see how to create several different types of temporary relationships. The ability to join two or more tables and extract the data from them is one of the most powerful features of any relational database.
(Query Joins, Inner Joins, Outer Joins,)

Preview 04:43

An unrelated table join is a join between two tables that have no common fields. You can create a join between unrelated fields by including a table in the middle, known as a junction table. (Unrelated Table Joins, Junction Tables)

Join Unrelated Tables
02:32

You have worked with several join types. In some cases, however, the related data is all within a single table. (Self Joins, The Alias Property)

Relate Data Within a Table
03:05

Sometimes you may need to view data in related tables simultaneously. In this topic, you will work with subdatasheets. (Subdatasheets)

Work with Subdatasheets - Introduction
00:32

In this topic, you will work with subdatasheets. In addition to viewing related data from another table, you can also modify it. (Subdatasheets)

Work with Subdatasheets
03:34

Microsoft Access 2016 Part 2 Quiz 2
3 questions
+
Using Data Validation
5 Lectures 23:54

Data inconsistency can lead to wasted time and wasted money for you if you have to find and correct data entries on a regular basis. The answer to the problem is to implement a data validation plan. (Lesson Introduction)

Preview 02:10

Field validation will help users to enter correct data the first time around. In this topic, you'll employ some methods to enforce field validation. (Field Properties, Validation Rules, Validation Messagaes)

Field Validation
04:09

An input mask is a format for data entry. Its use dictates how data can be entered into a table. (Input Masks, The Input Mask Wizard, Input Mask Characters, Expression Builder)

Input Mask
08:05

Form validation is similar to field validation in that you can manually enter expressions or build them with the Expression Builder. The difference is that you can further restrict data entry with form validation. (Control Wizards, The Combo Box Control, The List Box Control)

Form Validation
04:27

Record validation is similar to field validation in that you're using expressions to check data before it's saved to the database to ensure its consistency with corresponding data and to maintain reasonable conditions. (Property Sheet, Validation Rule, Expression Builder)

Record Validation
05:03

Microsoft Access 2016 Part 2 Quiz 3
2 questions
+
Creating Advanced Queries
13 Lectures 48:26

Learn how to you create queries that perform an action, such as deleting or modifying matching records. Such action queries can be a powerful tool for making mass updates to a database. (Lesson Introduction)

Preview 01:50

You may often find it necessary to make data retrieval interactive so that data is retrieved to meet the specific needs of users. In this topic, you will retrieve records based on input criteria. (Parameter Queries, Prompt Message Box)

Create Parameter Queries
03:35

A wildcard is a special character that is a substitute for a single character or string of text, so partial string matches will be included in the query result. (Wildcards, The Ampersand Operator)

Use Wildcards in a Parameter Query
05:57

Learn how to modify the query to prompt for the date range at the moment the query is run. This means you will need to create a parameter query with two prompts: the start date and the end date.

Create Queries with Multiple Parameters
02:09

A crosstab query displays data grouped by category to summarize results or reveal patterns in categories of data. The Crosstab queries can also automatically group date fields into intervals such as months or quarters. (Crosstab Queries)

Create Crosstab Queries
06:33

You may need to make a mass update to multiple records based on a pattern. For example, you might choose to increase prices for all products within a certain product line. An action query can automate such tasks for you.

Create Action Queries
02:44

Update queries changes field values in a table.

Update Queries
06:18

An Append Query adds records to a table.

Append Queries
03:28

A Delete Query deletes records that match criteria. (Delete Queries)

Delete Queries
05:40

A Make Table Query creates a new table to contain the query result.

Make Table Queries
02:13

Not cleaning up unmatched records or duplicate records can result in wrong data and possible loss of money and trust in your database. Imagine that a user uses one record to book orders and the record doesn't show up in queries for invoicing?

Unmatched and Duplicated Queries - Introduction
01:13

Part of the process of managing a database is simply keeping the database clean and efficient. The Find Unmatched Query Wizard finds records in a table or query that have no related records in another table or query. This can help you find unused records that can be deleted or archived. (The Find Unmatched Query Wizard)

Create Unmatched Queries
03:35

The Find Duplicates Query Wizard enables you to find records that have duplicate field values within a table or query. This can help you find records that have been inadvertently duplicated. (Find Duplicates Query Wizard)

Create Duplicate Queries
03:11

Microsoft Access 2016 Part 2 Quiz 4
5 questions
+
Organizing a Database for Efficiency
5 Lectures 24:01

Data normalization is the process of determining what data should be stored in each database table. Let's go over the rules for normalization. Tables that follow these rules allow for consistent storage and efficient access of data.

Preview 05:29

The Table Analyzer Wizard is an analysis tool that scans a table's structure for duplicate data. If it detects redundant data, the wizard provides a mechanism to split the table into smaller, related tables according to normalization rules. (The Table Analyzer Wizard)

The Table Analyser Wizard
05:40

One of the ways you can eliminate redundancy in some of your tables is by using an intermediary table to form a junction. (Many-to-Many Relationships, Junction Tables)

Junction Tables - Introduction
00:55

Working with Junction Tables eliminates inefficient design that could lead to inaccurate data. (Many-to-Many Relationships, Junction Tables)

Junction Tables
03:42

In this topic, you will improve table structure to meet a target design. Following these steps will save time and make it easy to manage changes, because over time, business needs change. You may want to expand your database or revamp it to fix or improve it. (Table Structure Improvement, Paste Table As, Structure Only)

Improve Table Structures
08:15

Microsoft Access 2016 Part 2 Quiz 5
3 questions
+
Using Advanced Reporting Techniques
5 Lectures 18:53

In this lesson, you will customize reports to organize the displayed information and produce specific print layouts. (Lesson Introduction)

Preview 01:24

Using control formatting and depicting data graphically can be easier to understand. In this topic, you will add data bars to a report. This will help you tell the story of your data with a quick glance. (Control Formatting, Data Bars)

Conditional Formatting - Data Bars
04:48

You may want to display information that summarizes data by sections, pages, or an entire report. (Calculated Fields, Expression Builder, Property Sheet)

Add a Calculated Field to a Report
04:11

In this topic, you will add a subreport to an existing report to display the linked information in a logical, readable way. (Subreports, Subforms on a Report, SubReport Wizard, Print Preview)

Add a Subreport to an Existing Report
07:21

Microsoft Access 2016 Part 2 Quiz 6
2 questions

In this course, you expanded your solid foundation of basic skills to an intermediate level by creating and working with various Access objects, relationships, tables, queries, and reports. You discovered how to maintain consistent data, customize database components, and add validation for data entry.

Course Follow-Up
01:09
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.3 Average rating
388 Reviews
6,414 Students
51 Courses
Training Company

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.