Corporate Training Group Classes, New York

You've covered many of the basic functions of Microsoft® Office Access® 2016, 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 multi-user access, and more. Knowledge of these features separate database professionals...

AM Session Section 1: Structuring Existing Data Restructure the Data in a Table Create a Junction Table Improve the Table Structure Section 2: Writing Advanced Queries Create Sub Queries Create Unmatched and Duplicate Queries Summarize Data Using a Crosstab Query Section 3: Maintaining an Access Database Link Tables to External Data Sources...

Lesson 1: Developing Macros Create a Macro with the Macro RecorderEdit a MacroDebug a MacroCustomize the Quick Access Toolbar and HotkeysSet Macro SecurityLesson 2: Formatting Worksheets Using Macros Insert TextFormat TextSort DataDuplicate DataGenerate a ReportLesson 3: Creating an Interactive Worksheet Determine the Dialog Box TypeCapture User InputLesson...

Lesson 1: Developing Macros Create a Macro with the Macro Recorder Edit a Macro Debug a Macro Customize the Quick Access Toolbar and Hotkeys Set Macro Security Lesson 2: Formatting Worksheets Using Macros Insert Text Format Text Sort Data Duplicate Data Generate a Report Lesson 3: Creating an Interactive Worksheet Determine the Dialog...

Target Audience: Practitioners who have been performing business analysis for at least three years Certification prospects who are planning to take the PMI-PBA® exam in the next 3-6 months Students who desire to learn more about the PMI-PBA® certification exam and process Any Certified Business Analyst  Professional (CBAP®) considering...

This course is designed to provide students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a Windows Server domain corporate environment. These skills include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity...

The main purpose of the course is to give students the ability plan and implement big data workflows on HDInsight. Audience profile: The primary audience for this course is data engineers, data architects, data scientists, and data developers who plan to implement big data engineering workflows on HDInsight. At course completion: After completing...

This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS. Audience Profile The primary audience for this...

All too often the software products delivered to the business do not meet their expectations, especially with regard to the quality of the product. An effective User Acceptance Testing (UAT) process addresses this issue by confirming the functionality and performance of the product prior to its release. This 2 day workshop looks at the business issues...

Target Audience: You should already have extensive experience gathering, documenting, validating and managing requirements, whether your role was as a business analyst, systems analyst, project lead, project manager or subject matter expert or something similar. Prerequisites: This course is suitable for experienced people who wish to prepare...

This course is designed to provide students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a Windows Server domain corporate environment.  These skills include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity and...

This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable...

This is a 5-day instructor-led training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to set up an Office 365 tenant, including...

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases. Audience Profile The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server...

Overview: Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being...