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 ­…

Read More

Uncategorized

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 ­…

Read More

Uncategorized

Microsoft Office Access 2016: Part 2

Course Overview This course will teach students how to design a relational database, join tables, use data validation, create advanced queries, organize a database for efficiency, and use advanced reporting techniques. Course Introduction 4m Course Introduction Chapter 01 – Designing a Relational Database 35m Topic A: Relational Database Design Database Relationship Relational Database Design Process…

Read More

Uncategorized

Microsoft Office Access 2016: Part 3

Course Overview This course will teach students how to implement advanced form design, share data across applications, use macros to improve user interface design, use VBA, use advanced database management, distribute and secure a database, and manage switchboards. Course Introduction 4m Course Introduction Chapter 01 – Implementing Advanced Form Design 29m Topic A: Add Controls…

Read More

Uncategorized

PMI Agile Certified Practitioner (PMI-ACP) Exam Prep®

Course Overview  This course covers the functions and features of Agile Certified Practitioner to prepare you for your certification exam. Students will learn about the application process and the exam, Agile principles, and value-driven delivery. They will also learn about stakeholder engagement, boosting team performance, adaptive planning, problem detection and resolution, and continuous improvement. Course Introduction 8m…

Read More

Uncategorized

Advanced VMware Security

Course Overview This course is far more advanced than any typical security course. Students will learn about the security protocols that administrators utilize to secure their environment and dive head first into the actual workings of the VMware environment. Students will learn about various threats and how to prevent and secure the VMware environment from…

Read More

Uncategorized