Access 2016/2019/365: Part 2

COURSE OUTLINE:

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. Audience This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports. Prerequisites To ensure your success, it is recommended you have completed Microsoft® Office Access® 2016/2019/365: 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. You can obtain this level of skills and knowledge by taking either of the following Logical Operations courses, or any similar courses in general Microsoft Windows skills:

Using Microsoft® Windows® 10

Microsoft® Windows® 10: Transition from Windows® 7
Microsoft® Office Access® 2016/2019/365: Part 1

Learning Objectives In this course, you will create and manage an Access 2016 database.

You will:

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.

Course Content

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design

Topic B: Create a Table

Topic C: Create Table Relationships

Lesson 2: Joining Tables

Topic A: Create Query Joins

Topic B: Relate Data Within a Table

Topic C: Work with Subdatasheets

Lesson 3: Using Data Validation

Topic A: Use Field Validation

Topic B: Use Form and Record Validation

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries

Topic B: Summarize Data

Topic C: Create Subqueries

Topic D: Create Action Queries

Topic E: Create Unmatched and Duplicate Queries

Lesson 5: Organizing a Database for Efficiency

Topic A: Data Normalization

Topic B: Create a Junction Table

Topic C: Improve Table Structure

Lesson 6: Using Advanced Reporting Techniques

Topic A: Include Control Formatting in a Report

Topic B: Add a Calculated Field to a Report

Topic C: Add a Subreport to an Existing Report

RELATED COURSES

Microsoft Office 365
Applications

Outlook 2016/2019/365: Part 1

Email has become one of the most widely used methods of communication, whether for personal or business communications. In most organizations, large or small, email is the preferred form of communicating information amongst employees. As email grows in popularity and use, most organizations have found the need to implement a corporate mail management system such as Microsoft® Office Outlook® to handle the messages and meeting invitations sent among employees.
In this course, you will use Outlook to send, receive, and manage email messages, manage your contact information, schedule appointments and meetings, create Tasks and Notes for yourself, and customize the Outlook interface to suit your working style.
This course is the first in a series of two Microsoft® Office Outlook® 2016 courses. It will provide you with the basic skills you need to start using Outlook 2016 to manage your email communications, contact information, calendar events, tasks, and notes. You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Outlook 2016.

Microsoft Office 365
Applications

Excel 2016/2019/365: Level 2 – Advanced Functions, Charts & PivotTables

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to change, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do.

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

Microsoft Office 365
Applications

PowerPoint 2016/2019/365: Level 2

Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But, Microsoft® PowerPoint® 2016 provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don’t consume all of your available time.

Microsoft Office 365
Applications

Office 365 End User Training

This course is an introduction to the Microsoftï¿½ Office 365ï¿½ for Office 2016 in a cloud-based environment. Using Office 365, users can easily communicate with each other through Microsoftï¿½ Outlookï¿½ mail, Teams, Groups,ï¿½and Skype for Business instant messaging and online meetings.

Additionally, the Microsoftï¿½ SharePointï¿½ Team Site provides a central location for accessing and modifying shared documents if your organization does not use a secure centrally built SharePoint environment. Office Web Apps enable users to perform basic tasks such as opening, editing, printing, and saving documents without requiring an installation of the full desktop version of Microsoftï¿½ Office 2016 on the local computer.