Overview/Description Advanced query methods in Access 2010 make it easy for an experienced end-user to retrieve the results they desire and to have those results displayed in such a way that the data is easy to interpret and analyze. This course describes the various types of join and parameter queries that can be used in Access 2010 and provides demonstrations on the use of action queries, including update, append, delete, and make table queries. It also explores the use of SQL-specific queries such as data-definition, pass-through, subquery, and union queries. Target Audience A broad range...

Overview/Description Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course outlines the tools used and tasks involved in managing and maintaining access to Reporting Services and corresponding data. It covers the authentication subsystem and role-based authorization model used by Reporting Services, as well as the configuration of system-level and item-level role-based security. SQL Server 2008 also provides the ability to deploy and...

Overview/Description Desktop operating systems sometimes develop problems over time or after configuration changes have occurred. These problems generally involve system performance issues or hardware/software-related problems. This course provides a look at key tools provided in Windows 7 to monitor and resolve system issues and to help identify what has happened to affect performance or function. Included is a discussion of the Event Forwarding capability first introduced in Windows Vista, as well as the use of Performance Monitor, Resource Monitor, and Task Manager. If CPU or memory...

Overview/Description ADO.NET connections and commands are crucial components of building data-driven applications. This course examines managing connections using connection pools and configuration files, as well as stored procedures, and using generic data-access code to establish a connection. Specific topics covered include optimizing ADO.NET connections and commands, ADO.NET transactions, and working with Multiple Active Result Sets (MARS) and asynchronous commands. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist:...