- By Itzik Ben-GanJul 19, 2017
In Skill 1.2 from Exam Ref 70-761 Querying Data with Transact-SQL, learn how to query multiple tables by using join statements based on provided tables, data, and requirements.
- By Joan LambertJul 6, 2017
In this sample chapter from MOS 2016 Study Guide for Microsoft Excel, learn about exam objectives related to presenting data in charts and enhancing worksheets through images, business diagrams, and text boxes.
- By Andrew WarrenMay 4, 2017
Many apps and services that you install on Windows Server run in the security context of a user account, known as a service account. In Skill 2.1 from Exam Ref 70-742 Identity with Windows Server 2016, learn how account policies enable you to control fundamental security features and how these features help secure your network—and the apps and services that run within it.
- By John PierceFeb 20, 2017
Access databases are made up of database objects: tables, queries, forms, reports, and supporting objects such as macros. In Objective 1.1 from MOS 2016 Study Guide for Microsoft Access, learn how to create a database from a template, and import objects and data.
- By Andrew WarrenFeb 16, 2017
In this sample chapter from Exam Ref 70-741 Networking with Windows Server 2016, learn how to create and manage Domain Name System (DNS) zones using the Windows Server 2016 DNS server role—and how to create and manage host and service-related records within these zones.
- By Wayne WinstonFeb 4, 2017
In this chapter from Microsoft Excel Data Analysis and Business Modeling, 5th Edition, author Wayne Winston explores the most commonly used month-day-year formats in Microsoft Excel 2016.
- By Paul McFedriesFeb 1, 2017
In this sample chapter from MOS 2016 Study Guide for Microsoft Excel Expert, learn how to use worksheet protection features to prevent changes to a single cell or entire workbook in Microsoft Excel 2016.
- By Wayne WinstonJan 31, 2017
In this chapter from Microsoft Excel Data Analysis and Business Modeling, 5th Edition, author Wayne Winston discusses the syntax of lookup functions in Microsoft Excel 2016.
- By Joan LambertJan 30, 2017
In this sample chapter from MOS 2016 Study Guide for Microsoft Outlook, learn more about exam objectives related to managing calendars, calendar items, tasks, and notes.
- By Joan LambertJan 9, 2017
In this sample chapter from MOS 2016 Study Guide for Microsoft PowerPoint, author Joan Lambert explains how to configure slide transitions and animate slide content in PowerPoint 2016.
- By Ben Curry, Brian LawsJan 4, 2017
A Business Connectivity Services (BCS) hybrid solution makes it possible for organizations to securely publish internally hosted business application data for remote workers or vendors— without migrating or replicating data across network boundaries. In this sample chapter from recent release From IT Pro to Cloud Pro Microsoft Office 365 and SharePoint Online, Microsoft cloud technology experts Ben Curry and Brian Laws explain requirements for a BCS hybrid solution with step-by-step procedures on the configuration process.
- By Itzik Ben-GanOct 7, 2016
Learning the theory behind T-SQL querying and programming is an important step in developing code. In this sample chapter from T-SQL Fundamentals, 3rd Edition, Itzik Ben-Gan provides a brief theoretical background about SQL, set theory and predicate logic, the relational model, and types of database systems.
Sign up now
Microsoft Press Store newsletter and special offers