TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Access 2019/2021: Part 3

You’ve covered many of the basic functions of Microsoft® Office Access®, and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access 2019/2021.

Microsoft ® Office Access ® 2019/2021: Part 1 : Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Microsoft ® Office Access ® 2019/2021: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
Microsoft ® Office Access ® 2019/2021: Part 3 (this course): Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

This material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Project 2019/2021/365: Part 1

Welcome to Microsoft® Project® 2019/2021/365: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment.

This course covers the critical knowledge and skills a project manager needs to create a project plan with Project during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project and share it with your supervisor (and others) for review and approval.

Note: This course is for anyone who has Project on the desktop, regardless of whether they purchased an “on-premise” edition or subscribed to a “cloud-based” (online) edition. Most project managers and project team members use the desktop application, so that is the main focus of this course. The main features of the online app are presented in an appendix.

This material will benefit users of any current version of Microsoft Office, and of the Microsoft Project desktop software. The classroom environment setup uses the Project 2019 desktop software.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Project.
– Microsoft Project 2019/2021/365: Part 1 (this course)
– Microsoft Project 2019/2021/365: Part 2

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Project 2019/2021/365: Part 2

Welcome to Microsoft Project 2019/2021/365: Part 2. This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment.

In Microsoft® Project® 2019/2021/365: Part 1, you learned the basic features of Microsoft Project during the planning phase of a project. This course covers the advanced knowledge and skills a project manager needs to update a project plan in Project during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.

Note: This course is for anyone who has Project on the desktop, regardless of whether they purchased an “on-premise” edition or subscribed to a “cloud-based” (online) edition. Most project managers and project team members use the desktop application, so that is the main focus of this course. The main features of the online app are presented in an appendix. This material will benefit users of any current version of Microsoft Office, and of the Microsoft Project desktop software. The classroom environment setup uses the Project 2019 desktop software.

This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of Project.
– Microsoft Project 2019/2021/365: Part 1
– Microsoft Project 2019/2021/365: Part 2 (this course)

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Motivation Training: Motivating Your Workforce

It’s no secret that employees who feel they are valued and recognized for the work they do are more motivated, responsible, and productive. This course will help supervisors and managers create a more dynamic, loyal, and energized workplace. It is designed specifically to help busy managers and supervisors understand what employees want, and to give them a starting point for creating champions.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Problem Solving and Decision Making

Many people lack the necessary skills to effectively solve problems and make decisions. Having a process in place can help with this.

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Project Management Essentials

If you are taking this course, you probably have some exposure to managing projects, or you may be considering embarking on a career as a professional project manager. Your ability as a project manager to demonstrate best practices in project management on the job is becoming the standard to compete in today’s fast-paced and highly technical workplace. In this course, you will apply the generally recognized practices of project management to successfully manage projects.

Project managers are always under severe pressure to complete projects on time and within budget. However, most projects fail to meet these demands, and, as a result, many projects are terminated early. Successful project management requires knowledge and experience. This course is designed to provide you with the skills needed to be a successful project manager in today’s rapidly changing world. The skills and knowledge you gain in this course will help you avoid making costly mistakes and increase your competitive edge in the project management profession.

Completion of this course will earn 1.8 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Project Management Fundamentals (Third Edition)

Successfully managing a project requires effective planning and adherence to the industry’s best practices in every step of the process. By understanding the fundamentals of project management, you will be better prepared to initiate a project in your organization and position it for success. In this course, you will identify effective project management practices and their related processes.

At this point in your professional development, you are ready to take on the responsibility for managing projects. You can manage a project by developing a solid understanding of the fundamentals of project management and its underlying structure and elements, including project phases, project life cycles, stakeholders, and areas of expertise. These, coupled with the ability to identify the project management processes that are recognized industry-wide as good practice, will help you to apply effective project management techniques to improve the efficiency of your projects and ensure their success.

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Project Management Training: Understanding Project Management

Project management isn’t just for construction engineers and military logistics experts anymore. Today, in addition to the regular duties of your job, you are often expected to take on extra assignments and to get that additional job done well, done under budget, and done on time. This course is not intended to take you from a supervisory or administrative position to that of a project manager. However, this course will familiarize you with the most common terms and the most current thinking about projects.
In this course, we will walk you through the nuts and bolts of project management, from setting priorities to controlling expenses and reporting on the results. You may still have to cope with the unexpected, but you’ll be better prepared.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Public Speaking: Presentation Survival School

This course will teach you how to manage your thoughts, body language, nervousness, and speech patterns to present yourself professionally. You’ll also learn how to present at meetings, use the five-S pattern to prepare a good presentation, and punch up your presentation with visual aids.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

SQL Querying: Advanced

In the course SQL Querying: Fundamentals, you learned the basics of SQL querying. Now that you have a foundation in how to query databases, you will learn in this course how to identify and use advanced querying techniques. In addition, you might find that you need to perform tasks such as modifying the structure of a table; inserting, updating, or deleting data; and indexing tables to optimize query performance. In this course, you will learn how to complete these tasks and more.

In today’s competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization’s processes and give it a competitive edge. As the organization grows, you will need to handle large amounts of data. Under such circumstances, you might need to query multiple tables simultaneously and with increasing frequency. You must step up the speed of generating query output to cope with the increasing demands of data storage, management, and retrieval.

This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of SQL.
– SQL Querying: Fundamentals
– SQL Querying: Advanced (this course)

Completion of this course will earn 0.6 CEUs.