In this introductory course, you will discover the capabilities of Microsoft® Access®, a relational database application that can help you and your organization manage your complex data.

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 covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification.

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 - 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 - Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.

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. Microsoft® Office Access® 2019 - 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 - 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.

In this course, students will use Access 2016 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

In this course, students add to their Access education in order to provide themselves with marketable job skills. This course builds on the foundational skills obtained by attending the Access 2016 - Part 1 course.

Students learn the Visual Basic for Applications language as well as the Access classes and objects needed to create VBA scripts to automate Access. Participants create procedures and functions using the VBA language and Access objects.

This 5-day classroom-based course provides the fundamental networking skills required to deploy and support Windows Server 2016 in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including software defined networking.

This five-day course explains how to implement and configure new Windows Server 2016 features and functionality. This course is for information technology (IT) professionals who want to upgrade their technical skills from Windows Server 2008 or Windows Server 2012 to Windows Server 2016. This course presumes a high level of knowledge about previous Windows Server technologies and skills equivalent to the Microsoft Certified Solutions Associate (MCSA): Windows Server 2008 or Windows Server 2012 credential.

In this course, students will learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

In this course, students will expand their knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports.

In many professional environments today, people work collaboratively in teams. Information technology and applications facilitate this by allowing people to easily share, access, edit, and save information. Microsoft® SharePoint® is a platform specifically designed to facilitate collaboration, allowing people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will learn about and use SharePoint to access, store, share, and collaborate with information and documents. SharePoint is a complex platform with many features and capabilities. A strong understanding of those features and capabilities will allow you to work more efficiently and effectively with SharePoint, and with the documents and data stored in SharePoint. Furthermore, effective use of the Modern UI and Office 365™ integrations will streamline tasks, and facilitate collaboration with colleagues in other Office 365 and third-party apps.

In this course, students will learn how to use Access 2010 to manage data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

Students will learn advanced Access features such as, database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

In this course, students will work with procedures and functions, understand objects, use expressions, variables and instrinsic functions, controlling program execution, work with recordsets, debug code and handle errors.

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.