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

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: 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

Time Management

Time is money, the saying goes, and lots of it gets lost in disorganization and disruption. We also deal with a constant barrage of technology, people, and tasks that can contribute to that disorganization. Many people find that they flit from one task to another, trying to get everything done, but often falling short. You will learn how to make the most of your time by getting a grip on your workflow and office space, using your planner effectively, and delegating some of your work to other people.

Completion of this course will earn 0.6 CEUs.

TOTAL DAYS: 1 | TOTAL HOURS: 2

Time Management 2-Hour Class

This is a 2-hour virtual instructor-led class, and in celebration of our 30th Anniversary, it will be held for $30!

Time is money, the saying goes, and lots of it gets lost in disorganization and disruption. We also deal with a constant barrage of technology, people, and tasks that can contribute to that disorganization. Many people find that they flit from one task to another, trying to get everything done, but often falling short. You will learn how to make the most of your time by getting a grip on your workflow and office space, using your planner effectively, and delegating some of your work to other people.