Microsoft Office Access 2016: Part 2 (Intermediate)

Microsoft Office Access 2016: Part 2 (Intermediate), available at $39.99, has an average rating of 4.3, with 40 lectures, 6 quizzes, based on 36 reviews, and has 474 subscribers.

You will learn about 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. This course is ideal for individuals who are 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. It is particularly useful for 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.

Enroll now: Microsoft Office Access 2016: Part 2 (Intermediate)

Summary

Title: Microsoft Office Access 2016: Part 2 (Intermediate)

Price: $39.99

Average Rating: 4.3

Number of Lectures: 40

Number of Quizzes: 6

Number of Published Lectures: 40

Number of Published Quizzes: 6

Number of Curriculum Items: 46

Number of Published Curriculum Objects: 46

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

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 Part 2 (Intermediate) of the 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.

Table of Contents:

01 Designing a Relational Database

02 Joining Tables

03 Using Data Validation

04 Creating Advanced Queries

05 Organizing a Database for Efficiency

06 Using Advanced Reporting Techniques

Course Curriculum

Chapter 1: Designing a Relational Database

Lecture 1: Analyze the Relational Database Design Process

Lecture 2: Understand Primary Keys

Lecture 3: Explore Table Relationships

Lecture 4: Create a Table

Lecture 5: Create a Table Relationship

Chapter 2: Joining Tables

Lecture 1: Joining Tables – Introduction

Lecture 2: Inner and Outer Joins

Lecture 3: Create Inner and Outer Joins

Lecture 4: Join Unrelated Tables

Lecture 5: Relate Data Within a Table

Lecture 6: Work with Subdatasheets – Introduction

Lecture 7: Work with Subdatasheets

Chapter 3: Using Data Validation

Lecture 1: Use Data Validation – Introduction

Lecture 2: Field Validation

Lecture 3: Input Mask

Lecture 4: Form Validation

Lecture 5: Record Validation

Chapter 4: Creating Advanced Queries

Lecture 1: Create Advanced Queries – Introduction

Lecture 2: Create Parameter Queries

Lecture 3: Use Wildcards in a Parameter Query

Lecture 4: Create Queries with Multiple Parameters

Lecture 5: Create Crosstab Queries

Lecture 6: Create Action Queries

Lecture 7: Update Queries

Lecture 8: Append Queries

Lecture 9: Delete Queries

Lecture 10: Make Table Queries

Lecture 11: Unmatched and Duplicated Queries – Introduction

Lecture 12: Create Unmatched Queries

Lecture 13: Create Duplicate Queries

Chapter 5: Organizing a Database for Efficiency

Lecture 1: Data Normalization

Lecture 2: The Table Analyser Wizard

Lecture 3: Junction Tables – Introduction

Lecture 4: Junction Tables

Lecture 5: Improve Table Structures

Chapter 6: Using Advanced Reporting Techniques

Lecture 1: Use Advanced Reporting Techniques

Lecture 2: Conditional Formatting – Data Bars

Lecture 3: Add a Calculated Field to a Report

Lecture 4: Add a Subreport to an Existing Report

Lecture 5: Bonus Lecture

Instructors

SONIC Performance Support – E-Learning Experts
Training Company

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 6 votes
4 stars: 15 votes
5 stars: 14 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu