TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Access 2016: Part 1

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.
– Microsoft Office Access 2016: Part 1 (this course)
– Microsoft Office Access 2016: Part 2
– Microsoft Office Access 2016: Part 3

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Access 2016: Part 2

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.

This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access.
– Microsoft Office Access 2016: Part 1
– Microsoft Office Access 2016: Part 2 (this course)
– Microsoft Office Access 2016: Part 3

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Access 2016: Part 3

You’ve covered many of the basic functions of Microsoft® Office Access® 2016, 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 database design and development in Access.
– Microsoft Office Access 2016: Part 1
– Microsoft Office Access 2016: Part 2
– Microsoft Office Access 2016: Part 3 (this course)

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Access 2019/2021: Part 1

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Office Access® can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

Microsoft® Office Access® 2019/2021: Part 1 (this course): 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: 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 VBA, and tools and strategies to manage, distribute, and secure a database.

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 Office Access 2019/2021: Part 2

Your training and experience using Microsoft® Office Access® 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; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.

This course is the second part of a three-course series that covers the skills needed to perform 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 (this course): 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: 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 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 Office Outlook 2016: 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.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of Outlook.
– Microsoft Office Outlook 2016: Part 1 (this course)
– Microsoft Office Outlook 2016: Part 2

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Outlook 2019/2021: Part 1

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 material will benefit users of any current Office version. The classroom environment setup is based on Office 2019.

This course is the first in a series of two Microsoft® Office Outlook® 2019/2021 courses. It will provide you with the basic skills you need to start using Outlook 2019/2021 to manage your email communications, contact information, calendar events, tasks, and notes.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400 certification.

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

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office Outlook 2019/2021: Part 2

In this course, you will customize command sets, configure mail accounts, set global options, perform advanced searches, apply filters to intercept mail and control spam, create rules to automate mail management tasks, work with calendars and contacts, manage tasks, preserve data with archives and data files, as well as share and delegate access to your Outlook items. In short, you’ll work with a wide range of features and options and, in so doing, understand why Outlook is a leading personal management system.

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

This course builds upon the foundational knowledge presented in the Microsoft ® Office Outlook® 2019/2021: Part 1 course and will help you customize a communication system well-suited to your work style.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Outlook Associate (Office 365 and Office 2019): Exam MO-400 certification.

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

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft Office PowerPoint 2016: Part 1

It’s hard to imagine a day going by without people passing along large amounts of information. Messages are everywhere, and the number of messages we receive seems to be increasing each day. Whether via phone, email, mass media, or personal interaction, we are subjected to a constant stream of information. With so much communication to contend with, it can be difficult to grab people’s attention. But, we are often called upon to do just that. So, how do you grab and maintain an audience’s focus when you’re asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® Office PowerPoint® 2016 can help you do.

Gone are the days of flip charts or drawing on a white board to illustrate your point. Today’s audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 2016, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 2016 to begin creating engaging, dynamic multimedia presentations.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft PowerPoint 2016.

This course is the first part of a two-course series that covers the skills needed to gain a foundational understanding of PowerPoint.
Microsoft Office PowerPoint 2016: Part 1 (this course)
Microsoft Office PowerPoint 2016: Part 2

Completion of this course will earn 0.6 CEUs.