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…

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

Course Overview This ILT Series course covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports. Course Overview Course Introduction   2m Course Introduction Unit 01 ­ Getting Started   17m Topic A: Database Concepts Database Components Relational Database Topic B: Exploring the Access Environment The Access Environment Demo ­ B­1: Starting Access and Examining the Access Window Opening Databases Demo ­ B­2: Opening a Database The Navigation Pane and Menu Demo ­ B­3: Using the Navigation Pane Open a Database Table Demo ­ B­4: Examining a Database Table Topic C: Getting Help Access Help Online Access Help Offline Demo ­ C­1: Using Help Unit 01 Review Unit 02 ­ Databases and Tables   56m Topic A: Planning and Designing Databases Planning a Database Rules for Names Using a Database Template Demo ­…

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

Course Overview This ILT Series course builds on the skills and concepts taught in Access 2010: Basic. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts. Course Overview Course Introduction   2m Course Introduction Unit 01 ­ Relational Databases   39m Topic A: Database Normalization Normalization Steps to Normalize: Rule 1 Steps to Normalize: Rule 2 Steps to Normalize: Rule 3 Demo ­ A­3: Using the Table Analyzer Demo ­ A­4: Identifying Object Dependencies Topic B: Table Relationships Establishing Relationships The Relationships Window Demo ­ B­1: Establishing a One­to­One Table Relationship One­to­Many Relationship Demo ­ B­2: Establishing a One­to­Many Table Relationship Junction Tables Many­to­Many with Junction Demo ­ B­3: Establishing a Many­to­Many Table Relationship Printing Table Relationships Demo ­ B­4: Printing Table Relationships Topic C: Referential Integrity Referential Integrity Demo ­ C­1: Planning Table Relationships Orphan Records Demo ­…