70-697: Configuring Windows Devices

Course Overview This course will teach students about what’s new in Windows 10, Windows 10 deployment, deploying virtual Windows 10 desktops, configuring device settings, connecting Windows 10 to networks, sharing data and printers, managing apps, securing Windows 10 devices, monitoring and maintaining Windows 10, managing users in the enterprise, managing desktops and applications in the…

70-740: Installation, Storage, and Compute with Windows Server 2016

Course Overview This course provides students with the knowledge and skills to install Windows servers in host and computer environments, implement local and enterprise storage solutions, implement Hyper-V virtualization, implement Windows containers, implement high availability, and maintain and monitor server environments. Course Introduction 6m Course Introduction Chapter 01 – Installing Windows Servers in Host and…

70-741: Networking with Windows Server 2016

Course Overview This course provides students with the knowledge and skills to plan and implement IPv4 and IPv6 networks, install and configure DHCP, install and configure DNS, implement and manage IP address management, implement remote access, install and configure branch office networking, and implement advanced networking features. Course Introduction 6m Course Introduction Chapter 01 –…

70-742: Identity in Windows Server 2016

Course Overview This course provides students with the knowledge and skills to install and configure domain controllers, manage Active Directory objects, secure Active Directory Domain Services, work with complex AD DS infrastructures, implement Group Policy, understand Microsoft Azure AD and Directory Synchronization, monitor and recover AD DS, and implement Active Directory Certificate, Federation, and Rights…

70-744: Securing Windows Server 2016

Course Overview This course provides students with the knowledge and skills to secure Windows Server 2016. Students will be introduced to attacks, breaches, and detection, and learn about protecting users and workstations, managing administrative access, configuring anti- malware and patch management, auditing and advanced threat analytics, securing the infrastructure, configuring data protection, advanced file server…

70-247: Configuring & Deploying a Private Cloud with System Center 2012

Course Overview This course teaches students about understanding the Private Cloud, using VMM to deploy the Cloud, working with the Private Cloud infrastructure, virtual applications, components of the Private Cloud, a First Business Unit Cloud, Private Cloud infrastructure, monitoring the Private Cloud, service management for the Cloud, Private Cloud Service Catalog, security for the Cloud,…

Microsoft Access 2007 ­ Level 3 Training

· Course Number:  Access2k73 · Length:   1 Day(s) Certification Exam No Microsoft Certified Professional exams are associated with this course. Course Overview Your training in and use of Microsoft® Office Access 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. Prerequisites To ensure the successful completion of Microsoft® Office Access 2007: Level 3, the following courses or equivalent knowledge are recommended for familiarity with: basic and intermediate features of Access tables, relationships, queries, forms, and reports, as well as: Microsoft® Office Access 2007: Level 1 and Microsoft® Office Access 2007: Level 2. Audience The Level 3 course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access 2007, and it is a prerequisite to take more advanced courses in Microsoft® Office Access 2007. Course Outline · Course Introduction · Lesson 1 ­ Structuring Existing Data · Structuring Existing Data · First Normal Form · Demo ­ Table Analyzer · Second Normal Form · Functional Dependency · Third Normal Form · Transitive Dependency · Many­to­Many Relationships · Junction Tables · Demo ­ Junction Table · Demo ­ Modify Tables…

Microsoft Office Access 2010: Advanced ·   Course Length:  1 Day

Course Overview This ILT Series course builds on the skills and concepts taught in Access 2010: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password­protect and encrypt databases; and set Access options and properties. Course Overview Course Introduction   2m Course Introduction Unit 01 ­ Querying with SQL   30m Topic A: SQL and Access Sample SQL Statements A Query in SQL View Demo ­ A2: Examining a SQL Statement in Access Topic B: Writing SQL Statements Writing a SQL Statement Demo ­ B1: Writing a SQL SELECT Statement Syntax for WHERE Clause Demo ­ B2: Using the WHERE Clause Aliases Demo ­ B3: Creating Aliases Syntax to Display Matched Records Demo ­ B4: Displaying Matching Records from Related Tables Syntax to Display Unmatched Records Demo ­ B5: Finding Unmatched Records Context­Sensitive Help Demo ­ B6: Getting Context­Sensitive Help on SQL Topic C: Attaching SQL Queries to Controls SQL­Specific Queries Create a Union Query Attach a SQL Query to a Button Command Button Wizard…