Microsoft programming Books

Book SynopsisNow in its 7th edition, Visual Basic in easy steps shows how to create Windows applications using the latest Visual Studio Community programming environment. Using examples with free downloadable code, this renowned guide covers:Form controls, application properties, the programming language, live code analysis, problem-solving and debugging techniques.Creating macros for Word and Excel in Microsoft Office, using VBA. Manipulating files and data using VBScript. Incorporating external data into your applications from text files, Excel spreadsheets, XML documents, live RSS web feeds, and SQL databases. Ideal for anyone wanting to quickly understand Visual Basic fundamentals and master the key techniques. By the end of the book, you'll be creating your own interactive applications!Visual Basic in easy steps, 7th edition has an easy-to-follow style that will appeal to anyone who wants to begin Windows programming, including: Programmers who want to quickly learn the latest Visual Basic techniques.Students who are studying computing at school or college. Those seeking a career in Information Technology who need a thorough understanding of Visual Basic programming. Updated for Visual Basic 2022 edition (Visual Basic 17.0).

Read more less

Book Synopsis

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

Book SynopsisThis portable reference to PowerShell summarizes the command shell and scripting language, and provides a concise reference to the many tasks that make PowerShell so useful. If you're a busy administrator and don't have time to plow through huge books or search online, this is the ideal on-the-job tool.

Read more less

Book SynopsisTable of ContentsIntroduction xv Chapter 1: Introducing Visual Studio Code 1 Getting Started 1 Installing Visual Studio Code 2 Windows 2 Linux 6 macOS 10 How Cross-Platform Works 11 Summary 12 Chapter 2: Exploring the User Interface 13 Editors 14 Activity Bar 15 Editing Settings Manually 17 Status Bar 18 Other Windows 23 Command Palette 23 Terminal Window 24 Output Window 25 Debug Console 26 Problems Window 27 Summary 29 Chapter 3: Files and Folders and Projects (Oh My) 31 Explorer 31 Project View 32 Decorations 36 Workspaces 37 Saving the Workspace 37 Adding Folders 38 Settings 38 Search 38 Advanced Searches 39 Regular Expression Matching 39 Specifying Files 40 Replacing Text 41 Settings 41 Summary 42 Chapter 4: Editing Code in Your Language of Choice 43 Editor Area 43 Editor Groups and Layouts 45 Open Editors 48 Outline View 51 Editing Functionality 52 Keyboard Shortcuts 53 Choosing Your Language 57 Formatting 58 Code Writing Assistance 59 IntelliSense 61 Method Info 61 Completions 62 Settings 62 Find and Replace 63 Minimap 64 Code Snippets 65 Multiple Cursors 67 Auto Save 67 Hot Exit 68 Editor Settings 68 Summary 71 Chapter 5: Integrating with Source Control 73 Source Control Management 73 Using Git 75 Cloning a Repository 76 Staging and Committing 76 Branches 77 Working with the Tracking Branch 78 Merge Conflicts 80 Miscellaneous Support 82 Git Output 82 Default Git Editor 83 Git Diff Tool 83 Other SCMs 83 Installing the Extension 84 Configuring the Extension 85 Summary 86 Chapter 6: Debugging Code 87 Debugging Node.js 87 Launching the Session 88 Launch Configurations 89 Launch vs. Attach Execution 91 Adding a Configuration 92 Simultaneous Configurations 94 Debug Actions 95 Breakpoints 95 Stepping through Code 97 Data Inspection 97 Advanced Launch Configuration 98 Variable Substitution 98 Launching a Browser on Debug 99 Summary 100 Chapter 7: External Tools and Task Automation 101 Tasks Defined 101 Creating Custom Tasks 104 Compound Tasks 106 Problem Matchers 107 Multiline Matchers 108 Background Patterns 109 Advanced Task Configuration 110 Platform-Specific Properties 110 Variable Substitution 110 Summary 112 Chapter 8: Unit Testing 113 Testing a Unit 113 Python Unit Testing 114 Unittest Framework 115 PyTest Framework 116 JavaScript Unit Testing 118 Jest Extension 118 Refactoring 121 Code Actions 122 Summary 124 Chapter 9: Working with Extensions 125 Extension Marketplace 126 Searching for Extensions 127 Installing Extensions 129 Extension Configuration 133 Updating Extensions 136 Workspace Extensions 137 Command-Line Interface 138 Useful Extensions 138 Linters 139 Keyboard Mappings 139 Snippets and Coding Assistance 140 Miscellaneous Tools 140 Summary 142 Chapter 10: Creating Your Own Extensions 143 Getting Started 143 An Extension Project 147 Activation Event 148 Contribution Points 148 Visual Studio Code API 149 Extension Project Structure 149 Activation Events 151 onCommand 151 onDebug 152 onFileSystem 152 onLanguage 153 onUri 153 onView 154 onWebviewPanel 154 workspaceContains 155 Start Up 155 Contribution Points 155 breakpoints 156 colors 156 configuration 157 configurationDefaults 157 commands 158 debuggers 158 grammars 158 jsonValidation 159 keybindings 159 when Clause 159 languages 160 menus 160 problemMatchers 162 snippets 162 taskDefinitions 163 themes 163 viewsContainers 163 views 164 Visual Studio Code API 165 Common Patterns 165 Promises 165 Cancellation Tokens 165 Events 165 Commands 166 Debug 166 Env 166 Extensions 167 Languages 167 Scm 168 Tasks 168 Window 168 Workspace 169 Summary 169 Index 171

Read more less

Book Synopsis Prepare for Microsoft Certification Exam 70-483: Programming in C#. The What, Why, and How of each concept is presented along with quick summaries, code challenges, and exam questions to review and practice key concepts. You will learn how to use: Lambda expressions to write LINQ query expressions Asynchronous programming with the Async and Await keywords to maximize performance of slow applications Regular expressions to validate user input Reflection to create and handle types at runtime  and much more The source code in the book will be available in the form of iCanCSharp notebooks and scripts that allow you to try out examples and extend them in interesting ways. What You Will Learn   Understand the necessary knowledge and skill set to prepare for Microsoft Exam 70-483  Study Table of ContentsChapter 1:Fundamentals of C#.- Chapter 2: Types in C#.- Chapter 3: Getting Started with Object Oriented Programming.- Chapter 4: Advanced C#.- Chapter 5: Implementing Delegates and Events.- Chapter 6: Taking a Deep Dive into LINQ.- Chapter 7: Managing the Object Life Cycle.- Chapter 8: Multi-Threaded, Async, and Parallel Programming.- Chapter 9: Exception Handling and Validating Application Input - Chapter 10: File I/O Operations.- Chapter 11: Serialization ad Deserialization.- Chapter 12: Consuming Data.- Chapter 13: Working with Cryptography.- Chapter 14: Assembly and Reflection.- Chapter 15: Debugging and Diagnostics.- Chapter 16: MCQs.

Read more less

Book SynopsisModel, map, and access data effectively with Entity Framework Core 2, the latest evolution of Microsoft''s object-relational mapping framework. You will access data utilizing .NET objects via the most common data access layer used in ASP.NET Core MVC 2 projects.  Best-selling author Adam Freeman explains how to get the most from Entity Framework Core 2 in MVC projects. He begins by describing the different ways that Entity Framework Core 2 can model data and the different types of databases that can be used. He then shows you how to use Entity Framework Core 2 in your own MVC projects, starting from the nuts and bolts and building up to the most advanced and sophisticated features, going in-depth to give you the knowledge you need. Chapters include common problems and how to avoid them. What You''ll Learn Gain a solid architectural understanding of Entity Framework Core 2 CrTable of ContentsPart 1------1 - Entity Framework Core in Context2 - Your First Entity Framework Core Application3 - Working with Databases4 - SportsStore - A Real (Data) Application5 - SportsStore - Storing Data6 - SportsStore - Modifying Data7 - SportsStore - Expanding the Data Model8 - SportsStore - Scaling Up9 - SportsStore - Customer Features10 - SportsStore - Creating An APIPart 2-----11 - Working with Entity Framework Core12 - Performing Data Operations13 - Understanding Migrations14 - Creating Data Relationships15 - Working with Relationships, Part 116 - Working with Relationships, Part 217 - Scaffolding an Existing Database18 - Manually Modelling a DatabasePart 3-----19 - Keys20 - Querying Data21 - Storing Data22 - Deleting Data23 - Using Database Server Features24 - Using Transactions

Read more less

Book SynopsisThe Comprehensive, Expert Guide to C# Language Programming “This book has been a classic for years, and remains one of the most venerable and trusted titles in the world of C# content, and probably far beyond! . . . Mark is super smart, insists on understanding everything to the core, and has phenomenal insight into how things affect real developers. . . . He goes right to the essence and communicates with great integrity—no sugarcoating—and has a keen eye for practical value and real-world problems.” –Mads Torgersen, C# Program Manager, Microsoft Essential C# 7.0 is a well-organized, no-fluff guide to C# 7.0 for programmers at all levels of experience. Reflecting the most important C# features from 3.0 through 7.0 and including modern programming patterns, it will help you write code that’s simple, powerful, robust, secure, and maintainable. Author Mark Michaelis is a world-class C# expert: a long-time Microsoft MVP and Regional Director who also has served on Microsoft’s C# design review team. He presents a comprehensive tutorial and reference for the entire language, including expert coverage of key C# 7.0 enhancements, C# 7.0’s use with .NET Core/.NET Standard, and cross-platform compilation. He illustrates key C# constructs with succinct examples, and presents best-practice coding guidelines. To help you maintain existing code, separate indexes provide version-specific answers for C# 5.0, 6.0, and 7.0, and visual icons show when each language innovation was introduced. Make the most of C# 7.0 enhancements, including tuples, deconstructors, pattern matching, local functions, and ref returns Work efficiently with C# data types, operators, control flow, methods, and parameters Write more robust code with C# object-oriented constructs Implement reliable, effective exception handling Reduce code complexity with generics, delegates, lambda expressions, and events Leverage advanced dynamic and declarative programming techniques Query diverse data collections using LINQ with query expressions Create custom collections that operate against business objects Access .NET collections via collection interfaces and standard query operators Master multithreading and synchronization, including the async/await paradigm Optimize performance and interoperability with P/Invoke and unsafe code Run your code on Linux or macOS with C# 7.0 cross-platform compilation Includes C# 7.1, 7.2, and 7.3 language enhancements This guide offers you a complete foundation for successful development with modern versions of the C# language in any project or environment.Table of ContentsFigures xv Tables xvii Foreword xix Preface xxi Acknowledgments xxxiii About the Author xxxv Chapter 1: Introducing C# 1 Hello, World 2 C# Syntax Fundamentals 11 Working with Variables 20 Console Input and Output 24 Managed Execution and the Common Language Infrastructure 32 Multiple .NET Frameworks 37 Chapter 2: Data Types 43 Fundamental Numeric Types 44 More Fundamental Types 53 null and void 67 Conversions between Data Types 69 Chapter 3: More with Data Types 77 Categories of Types 77 Nullable Modifier 80 Tuples 83 Arrays 90 Chapter 4: Operators and Control Flow 109 Operators 110 Introducing Flow Control 126 Code Blocks ({}) 132 Code Blocks, Scopes, and Declaration Spaces 135 Boolean Expressions 137 Bitwise Operators (<<, >>, |, &, ^, ~) 147 Control Flow Statements, Continued 153 Jump Statements 165 C# Preprocessor Directives 171 Chapter 5: Methods and Parameters 181 Calling a Method 182 Declaring a Method 189 The using Directive 195 Returns and Parameters on Main() 200 Advanced Method Parameters 203 Recursion 215 Method Overloading 217 Optional Parameters 220 Basic Error Handling with Exceptions 225 Chapter 6: Classes 241 Declaring and Instantiating a Class 245 Instance Fields 249 Instance Methods 251 Using the this Keyword 252 Access Modifiers 259 Properties 261 Constructors 278 Static Members 289 Extension Methods 299 Encapsulating the Data 301 Nested Classes 304 Partial Classes 307 Chapter 7: Inheritance 313 Derivation 314 Overriding the Base Class 326 Abstract Classes 338 All Classes Derive from System.Object 344 Verifying the Underlying Type with the is Operator 345 Pattern Matching with the is Operator 346 Pattern Matching within a switch Statement 347 Conversion Using the as Operator 349 Chapter 8: Interfaces 353 Introducing Interfaces 354 Polymorphism through Interfaces 355 Interface Implementation 360 Converting between the Implementing Class and Its Interfaces 366 Interface Inheritance 366 Multiple Interface Inheritance 369 Extension Methods on Interfaces 369 Implementing Multiple Inheritance via Interfaces 371 Versioning 374 Interfaces Compared with Classes 375 Interfaces Compared with Attributes 377 Chapter 9: Value Types 379 Structs 383 Boxing 390 Enums 398 Chapter 10: Well-Formed Types 411 Overriding object Members 411 Operator Overloading 424 Referencing Other Assemblies 432 Defining Namespaces 442 XML Comments 445 Garbage Collection 449 Resource Cleanup 452 Lazy Initialization 461 Chapter 11: Exception Handling 465 Multiple Exception Types 465 Catching Exceptions 469 General Catch Block 473 Guidelines for Exception Handling 475 Defining Custom Exceptions 479 Rethrowing a Wrapped Exception 483 Chapter 12: Generics 487 C# without Generics 488 Introducing Generic Types 493 Constraints 506 Generic Methods 519 Covariance and Contravariance 524 Generic Internals 531 Chapter 13: Delegates and Lambda Expressions 537 Introducing Delegates 538 Declaring Delegate Types 542 Lambda Expressions 550 Anonymous Methods 556 Chapter 14: Events 575 Coding the Publish-Subscribe Pattern with Multicast Delegates 576 Understanding Events 591 Chapter 15: Collection Interfaces with Standard Query Operators 603 Collection Initializers 604 What Makes a Class a Collection: IEnumerable 607 Standard Query Operators 613 Anonymous Types with LINQ 646 Chapter 16: LINQ with Query Expressions 657 Introducing Query Expressions 658 Query Expressions Are Just Method Invocations 676 Chapter 17: Building Custom Collections 679 More Collection Interfaces 680 Primary Collection Classes 683 Providing an Indexer 702 Returning Null or an Empty Collection 705 Iterators 705 Chapter 18: Reflection, Attributes, and Dynamic Programming 721 Reflection 722 nameof Operator 733 Attributes 735 Programming with Dynamic Objects 759 Chapter 19: Multithreading 771 Multithreading Basics 774 Working with System.Threading 781 Asynchronous Tasks 789 Canceling a Task 810 The Task-based Asynchronous Pattern 816 Executing Loop Iterations in Parallel 846 Running LINQ Queries in Parallel 856 Chapter 20: Thread Synchronization 863 Why Synchronization? 864 Timers 893 Chapter 21: Platform Interoperability and Unsafe Code 897 Platform Invoke 898 Pointers and Addresses 910 Executing Unsafe Code via a Delegate 920 Chapter 22: The Common Language Infrastructure 923 Defining the Common Language Infrastructure 924 CLI Implementations 925 .NET Standard 928 Base Class Library 929 C# Compilation to Machine Code 929 Runtime 932 Assemblies, Manifests, and Modules 936 Common Intermediate Language 939 Common Type System 939 Common Language Specification 940 Metadata 941 .NET Native and Ahead of Time Compilation 942 Index 945 Index of 7.0 Topics 995 Index of 6.0 Topics 998 Index of 5.0 Topics 1001

Read more less

Book SynopsisDESCRIPTION PowerShell provides a single, unified administrative command line from which to control and automate virtually every aspect of a Windows system. It accepts and executes commands immediately, and scripts can be written to manage most Windows servers like Exchange, IIS, and SharePoint. This updated book covers PowerShell features that run on Windows 7, Windows Server 2008 R2, and later. This edition is appropriate for PowerShell version 3 and later. There is coverage for new PowerShell version 5 features like PowerShellGet, however PowerShell fundamentals are unchanged. Learn Windows PowerShell in a Month of Lunches, Third Edition is an innovative tutorial designed for busy IT professionals. With just one hour a day for a month, readers will be automating Windows tasks faster than they ever thought possible. They start with the basics (What is PowerShell and what can be done with it). Then, it moves systematically through the techniques and features that facilitate efficient and effective results. KEY FEATURES• A great start with a great tutorial • Concise and easy-to-follow • Based on years of successful training techniques • Hands-on exercises and labs AUDIENCE Experience with Windows administration is helpful. No programming or scripting experience is assumed. ABOUT THE TECHNOLOGY PowerShell is an automation engine for Windows systems. It is being built into all major Microsoft products and many third party products. PowerShell allows for the automations of day to day administration tasks and is a must learn technology for administrators.

Read more less

Book SynopsisAccelerate your digital transformation and break down silos with Microsoft Dynamics 365 It's no secret that running a business involves several complex parts like managing staff, financials, marketing, and operationsjust to name a few. That's where Microsoft Dynamics 365, the most profitable business management tool, comes in. In Microsoft Dynamics 365 For Dummies, you'll learn the aspects of the program and each of its applications from Customer Service to Financial Management. With expert author Renato Bellu's clear instructions and helpful tips, you'll be managing to your fullest advantage before you know it. Let's get started! Digitally transform your business by connecting CRM and ERPUse data to make decisions across all business functionsIntegrate Dynamics 365 with Office 365 and LinkedInManage financials and operations Are you running a dynamic business? This book shows you how!Table of ContentsIntroduction 1 Who Should Buy This Book 1 About This Book 2 Part 1: Doing Great Things with Microsoft Dynamics 365 2 Part 2: Customer Engagement (formerly Dynamics CRM Online) 2 Part 3: Business Central ERP (formerly Dynamics NAV) 2 Part 4: Finance and Operations ERP (formerly Dynamics AX) 3 Part 5: The Part of Tens 3 Foolish Assumptions 3 Icons Used in This Book 3 Beyond the Book 4 Part 1: Doing Great Things with Microsoft Dynamics 365 5 Chapter 1: Floating on a Secure Cloud 7 Getting Under the Dynamics 365 Umbrella 9 Gaining a little historical perspective 10 Reading the roadmap for Microsoft ERP and CRM 12 Asking what’s in the Dynamics 365 “sausage” 13 Standardizing the tools and terminology 15 Transitioning to the Cloud 16 Understanding the difference between hosted client/server and true SaaS 17 Migrating from Dynamics GP or SL to Dynamics 365 19 Migrating from Dynamics CRM or CRM Online to Dynamics 365 21 Migrating from Dynamics AX to Dynamics 365 Enterprise edition 22 Migrating from Dynamics NAV to Dynamics 365 Business edition 23 Chapter 2: Extending Your Reach with Office 365 25 Working with the Admin Center 25 Managing users 26 Purchasing and managing subscriptions 28 Setting the password expiration 31 Integrating Dynamics 365 with Outlook Email 32 Adding the Excel Add-In for Finance and Operations 37 Organizing Documents with SharePoint and OneDrive 40 Messaging with Skype for Business 45 Chapter 3: Powering Up Your Business Intelligence 49 A Little Pre-History 50 Exploring Data through Power BI 51 Installing Power BI Desktop 54 Connecting to Dynamics 365 with Power BI Desktop 55 Connecting to a file 56 Connecting to a SQL View 56 Connecting to Dynamics 365 57 Connecting Power BI to Business Central 57 Connecting Power BI to Finance and Operations 59 Harnessing the Power of Apps and Content Packs 63 Embedding Dashboards in Dynamics 365 65 Chapter 4: Extending Dynamics 365 with PowerApps 67 Providing Power to Your People with PowerApps 68 Finding out whether PowerApps is right for you 70 Making external PowerApps connections 72 Adding an Option set 74 Adding a data connection 76 Making your app your own with App Settings 78 Connecting PowerApps to Dynamics 365 79 Chapter 5: Going with the Microsoft Flow to Enhance Dynamics 365 83 Setting Up Basic Workflows Using Microsoft Flow 84 Grasping the Relationship Between Document Management and Workflow 87 Seeing How Microsoft Does ECM 88 Understanding Workflow in the ERP and CRM Realms 89 Considering your workflow options in Dynamics 365 90 Comprehending the Microsoft Flow advantage 94 Part 2: Customer Engagement (Formerly Dynamics Crm Online) 97 Chapter 6: Turning Relationships into Revenue with Sales 99 Understanding CRM-Related Terms 99 Navigating the Navigation Bar 103 Working with Leads, Accounts, and Contacts 105 Leading the way with leads 107 Working with accounts 110 Connecting with contacts 111 Tracking Opportunities 114 Creating Quotes, Orders and Invoices 116 Chapter 7: Connecting with Customers Anytime, Anywhere with Customer Service 117 Knowing Your Way Around Dynamics 365 for Customer Service 118 Users 119 Accounts 120 Contacts 120 Cases 120 Posts and notes 121 Activities 121 Tasks 121 Queues 123 Views 123 Working with Cases 125 Finding a case 125 Adding a new case 127 Annotating an existing case 129 Taking action on an existing case 130 Adding knowledge articles (KB records) 132 Relating a case to other information 133 Gaining Control with Dynamics 365 for Customer Service Dashboards 135 Chapter 8: Profiting from Project Service Automation 137 Categorizing Project Software 139 Avoiding complicated project accounting 141 Rules of thumb for selecting project software in Dynamics 365 143 Knowing Your Way around Dynamics 365 for Project Service Automation 144 Connecting remotely with the Project Service Hub 146 Getting familiar with the components of Project Service Automation 147 Recognizing the importance of planning the setup of Project Service 148 Chapter 9: Creating and Nurturing Leads with Marketing 153 Connecting Marketing to Sales 154 Escaping the Doldrums of Drab Emails and Boring Web Pages 156 Using templates to get up to speed quickly 157 Segmenting your contacts for marketing and subscription lists 158 Adding a static marketing segment 159 Listening to the Voice of the Customer 161 Dashing Off to Marketing Dashboards 164 Configuring Advanced Settings in Dynamics 365 for Marketing 164 Chapter 10: Going Mobile with Field Service 167 Assessing Microsoft’s FSM Competitors 169 Taking the Back-office ERP into Consideration 170 Getting Acquainted with the Key Components of Dynamics 365 for Field Service 171 Living the Dream of Efficient Field Service: The Work Order Lifecycle 174 Configuring Administrative Settings for Dynamics 365 for Field Service 175 Working with Work Orders 177 Adding a Customer Asset 179 Transferring Inventory 180 Part 3: Business Central Erp (Formerly Dynamics Nav) 183 Chapter 11: Accounting for Your Business with Business Central 185 Getting to Know the Interface 188 Making Your Way Around the Home Screen 189 Setting Up the Books 191 Adding accounts to the chart of accounts 192 Defining G/L account categories 194 Specifying bank accounts 196 Entering Sales Quotes 198 Creating Sales Orders and Invoices 200 Creating Sales Credit Memos 202 Maintaining Customers 204 Maintaining Vendors 207 Chapter 12: Setting Up Business Central for Optimal Results 211 Migrating from Dynamics NAV to Business Central 213 Navigating in Business Central 215 Searching for screens and reports 215 Navigating by menu 218 Feeling at home in your Role Center 220 Setting Up Business Central 223 Working with manual setup 225 Setting up number series (sequence numbers) 227 Defining number series relationships 229 Managing users and permissions 230 Setting up inventory 233 Part 4: Finance and Operations Erp (Formerly Dynamics Ax) 237 Chapter 13: Going Beyond Crunching Numbers with Financial Management 239 Getting a Bird’s-Eye View of D365O Capabilities 242 Raising the Flag on Microsoft’s Flagship ERP 243 Learning How to Get Around in D365O 246 Navigating with tiles 249 Setting user preferences 250 Harnessing the Power of Financial Dimensions 252 Chapter 14: Becoming a Smooth Operator with Operations 259 Changing Companies 260 Navigating by Module 261 Taking Advantage of Keyboard Shortcuts 263 Taking a Deeper Dive into D365O Capabilities by Module 264 Mastering Master Data in D365O 268 Surveying the vendor record 268 Surveying the customer record 271 Surveying the inventory item (released product) record 273 Using the More Options button 276 Working with List Pages 278 Exporting List Pages to Excel Spreadsheets 281 Chapter 15: Looking Under the Hood (Understanding the D365O Technology) 283 Upgrading from Dynamics AX to Dynamics 365 for Finance and Operations 284 Migrating customizations from over-layering to extensions 285 Rewriting integrations created with AIF 286 Tapping into technology for integrations and data conversions 287 Using a comprehensive design document and a right-sized project plan 289 Personalizing the User Interface 290 Configuring the Global Address Book 297 Creating additional address books 299 Setting global address book default values 299 Creating new party records 300 Transforming Your HR Department with Talent 304 Filing Expense Reports with Expense Management 306 Part 5: The Part of Tens 309 Chapter 16: The Ten Most Exciting Capabilities of Dynamics 365 311 Supercomprehensive Coverage 311 Scalability with Azure 314 Mobile Computing 315 Localization Features 316 Employee Self-Service 318 Common Data Model 321 Team Member License 323 General Data Protection Regulation 323 Unified Interface 324 Categorized and Relevance Search 325 Chapter 17: Ten Dynamic 365 Myths to Dispel 327 Myth 1: Investing in ERP Doesn’t Pay 327 Myth 2: Our ERP Is Too Entrenched 330 Myth 3: ERP Is Too Complex for the Cloud 332 Myth 4: Integrations Are Not Worth It — Just Rekey the Data 333 Myth 5: Software as a Service Is More Expensive than On-Premise 334 Myth 6: The Cloud Is Not Secure Enough for ERP 335 Myth 7: What If the Internet Goes Down 337 Myth 8: I’ll Lose My Data in the Cloud 337 Myth 9: You Won’t Have Control of Your Data 338 Myth 10: Cloud Apps Are Not Customizable 339 Index 341

Read more less

Book SynopsisCustomize and ramp-up Office 365 applications NOTE:Please click Downloads (located in the menu on the left) to download Full Code Download.The revised 2019 edition of Mastering VBA Microsoft Office 365 offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. To enhance understanding, the content is explored in real-world projects in Word, Excel, Outlook, and PowerPoint. Since the technical programming methods in the Office applications continue to evolve, the updated 2019 edition reviews the changes to the program. Code libraries, the API, and the object model for each Office program have bTable of ContentsIntroduction xxix Part 1 Recording Macros and Getting Started with VBA 1 Chapter 1 Recording and Running Macros in the Office Applications 3 What Is VBA and What Can You Do with It? 3 The Difference between Visual Basic and Visual Basic for Applications 4 What Are Visual Basic NET and Visual Basic Express? 5 Understanding Macro Basics 5 Recording a Macro 6 Displaying the Developer Tab on the Ribbon 7 Planning the Macro 8 Starting the Macro Recorder 10 Naming a Macro 13 Running a Macro 24 Recording a Sample Word Macro 25 Recording a Sample Excel Macro 27 Create a Personal Macro Workbook If You Don’t Have One Yet 28 Record the Macro 29 Specifying How to Trigger an Existing Macro 30 Assigning a Macro to a Quick Access Toolbar Button in Word 30 Assigning a Macro to a Shortcut Key Combination 31 Deleting a Macro 31 The Bottom Line 33 Chapter 2 Getting Started with the Visual Basic Editor 35 Opening the Visual Basic Editor 35 Opening the Visual Basic Editor with a Macro Selected 36 Opening the Visual Basic Editor Directly 37 Navigating to a Macro 37 Using the Visual Basic Editor’s Main Windows 38 The Project Explorer 39 The Object Browser 42 The Code Window 43 The Properties Window 48 The Immediate Window 50 Setting Properties for a Project 51 Customizing the Visual Basic Editor 53 Choosing Editor and View Preferences 54 Choosing and Laying Out the Editor Windows 61 Customizing the Toolbar and Menu Bar 61 Customizing the Toolbox 62 The Bottom Line 66 Chapter 3 Editing Recorded Macros 69 Testing a Macro in the Visual Basic Editor 70 Stepping Through a Macro 71 Setting Breakpoints 73 Commenting Out Lines 74 Stepping Out of a Macro 75 Editing a Word Macro 75 Stepping Through the Transpose_Word_Right Macro 77 Running the Transpose_Word_Right Macro 77 Creating a Transpose_Word_Left Macro 77 Saving Your Work 79 Editing an Excel Macro 79 Unhiding the Personal Macro Workbook 79 Opening a Macro for Editing 81 Editing a Macro 82 Editing a PowerPoint Macro 84 Reducing the Size of Your Macro 88 Saving Your Work 89 The Bottom Line 90 Chapter 4 Creating Code from Scratch in the Visual Basic Editor 93 Setting Up the Visual Basic Editor to Create Macros 93 Creating a Procedure for Word 95 Creating a Macro for Excel 101 Creating a Procedure for PowerPoint 106 Creating a Procedure for Access 112 The Bottom Line 113 Part 2 Learning How to Work with VBA 115 Chapter 5 Understanding the Essentials of VBA Syntax 117 Getting Ready 117 Procedures 118 Functions 119 Subprocedures 119 Statements 119 Keywords 123 Expressions 124 Operators 124 Variables 124 Constants 126 Arguments 126 Specifying Argument Names vs Omitting Argument Names 127 When to Include the Parentheses around an Argument List 128 Objects 129 Collections 129 Properties 130 Methods 130 Events 130 The Bottom Line 132 Chapter 6 Working with Variables, Constants, and Enumerations 135 Working with Variables 136 Choosing Names for Variables 136 Declaring a Variable 138 Choosing the Scope and Lifetime of a Variable 141 Specifying the Data Type for a Variable 148 Working with Constants 155 Declaring Your Own Constants 155 Choosing the Scope or Lifetime for Constants 156 Working with Enumerations 156 The Bottom Line 157 Chapter 7 Using Array Variables 159 What Is an Array? 159 Declaring an Array 161 Storing Values in an Array 163 Multidimensional Arrays 164 Declaring a Dynamic Array 165 Redimensioning an Array 165 Returning Information from an Array 166 Erasing an Array 166 Determining Whether a Variable Is an Array 166 Finding the Bounds of an Array 167 Sorting an Array 167 Searching an Array 171 Performing a Linear Search Through an Array 172 Binary Searching an Array 177 The Bottom Line 182 Chapter 8 Finding the Objects, Methods, and Properties You Need 185 What Is an Object? 185 The Benefits of OOP 185 Understanding Creatable Objects 187 Properties 187 Methods 188 Working with Collections 190 Working with an Object in a Collection 191 Adding an Object to a Collection 192 Finding the Objects You Need 192 Using the Macro Recorder to Add Code for the Objects You Need 192 Using the Object Browser 195 Using Help to Find the Object You Need 201 Using the Auto List Members Feature 205 Using Object Variables to Represent Objects 206 Team Programming and OOP 209 The Bottom Line 211 Part 3 Making Decisions and Using Loops and Functions 213 Chapter 9 Using Built-In Functions 215 What Is a Function? 215 Using Functions 217 Passing Arguments to a Function 219 Using Functions to Convert Data 220 Using the Asc Function to Return a Character Code 221 Using the Val Function to Extract a Number from the Start of a String 221 Using the Str Function to Convert a Number into a String 223 Using the Format Function to Format an Expression 224 Using Predefined Numeric Formats 225 Creating a Numeric Format 226 Creating a Date or Time Format 227 Creating a String Format 228 Using the Chr Function and Constants to Enter Special Characters in a String 229 Using Functions to Manipulate Strings 230 Using the Left, Right, and Mid Functions to Return Part of a String 230 Using the Left Function 232 Using the Right Function 232 Using the Mid Function 233 Using InStr and InStrRev to Find a String Within Another String 235 Using LTrim, RTrim, and Trim to Remove Spaces from a String 237 Using Len to Check the Length of a String 238 Using StrConv, LCase, and UCase to Change the Case of a String 240 Using the StrComp Function to Compare Apples to Apples 241 Using VBA’s Mathematical Functions 242 Using VBA’s Date and Time Functions 244 Using the DatePart t Function to Parse Dates 244 Calculating Time Intervals Using the DateDiff f Function 245 Using the DateAdd d Function to Add or Subtract Time from a Date 246 Using File-Management Functions 246 Checking Whether a File Exists Using the Dir Function 246 Returning the Current Path 248 The Bottom Line 248 Chapter 10 Creating Your Own Functions 251 Components of a Function 252 Creating a Function 254 Starting a Function Manually 254 Starting a Function by Using the Add Procedure Dialog Box 254 Passing Arguments to a Function 256 Declaring the Data Types of Arguments 257 Specifying an Optional Argument 257 Controlling the Scope of a Function 258 Examples of Functions for All VBA-Enabled Office Applications 258 How Functions Return Information 260 Returning Text Data from a Function 260 Creating a Function for Word 263 Creating a Function for Excel 265 Creating a Function for PowerPoint 267 Creating a Function for Access 269 The Bottom Line 271 Chapter 11 Making Decisions in Your Code 273 How Do You Compare Things in VBA? 274 Testing Multiple Conditions by Using Logical Operators 275 If Blocks 278 If Then 278 If Then Else Statements 280 If Then ElseIf Else Statements 282 Creating Loops with If and GoTo 287 Nesting If Blocks 289 Select Case Blocks 291 Syntax 291 Example 292 When Order Matters 294 The Bottom Line 294 Chapter 12 Using Loops to Repeat Actions 297 When Should You Use a Loop? 297 Understanding the Basics of Loops 298 Using For Loops for Fixed Repetitions 299 For Next Loops 299 For Each Next Loops 308 Using an Exit For Statement 308 Using Do Loops for Variable Numbers of Repetitions 309 Do While Loop Loops 310 Do Loop While Loops 314 Do Until Loop Loops 316 Do Loop Until Loops 318 Using an Exit Do Statement 319 Is the Exit Do Statement Bad Practice? 320 While Wend Loops 321 Nesting Loops 322 Avoiding Infinite Loops 325 The Bottom Line 326 Part 4 Using Message Boxes, Input Boxes, and Dialog Boxes 327 Chapter 13 Getting User Input with Message Boxes and Input Boxes 329 Opening a Macro 330 Displaying Status-Bar Messages in Word and Excel 331 Message Boxes 333 The Pros and Cons of Message Boxes 333 Message-Box Syntax 334 Displaying a Simple Message Box 335 Displaying a Multiline Message Box 336 Choosing Buttons for a Message Box 337 Choosing an Icon for a Message Box 338 Setting a Default Button for a Message Box 339 Controlling the Modality of a Message Box 340 Specifying a Title for a Message Box 341 Title Bars Can Provide Useful Information 342 Adding a Help Button to a Message Box 342 Specifying a Help File for a Message Box 343 Using Some Arguments Without Others 344 Retrieving a Value from a Message Box 344 Input Boxes 345 Input-Box Syntax 346 Retrieving Input from an Input Box 348 Forms: When Message Boxes and Input Boxes Won’t Suffice 348 The Bottom Line 349 Chapter 14 Creating Simple Custom Dialog Boxes 351 When Should You Use a Custom Dialog Box? 351 Creating a Custom Dialog Box 352 Designing a Dialog Box 354 Inserting a User Form 354 Choosing User-Form Grid Settings 355 Renaming a User Form 358 Adding Controls to the User Form 360 Grouping Controls 363 Renaming Controls 364 Moving a Control 365 Changing the Caption on a Control 367 Key Properties of the Toolbox Controls 368 Working with Groups of Controls 386 How to Group Controls 386 Ungrouping Controls 386 Sizing Grouped Controls 387 Deleting Grouped Controls 387 Working with One Control in a Group 387 Aligning Controls 388 Placing Controls 389 Adjusting the Tab Order of a Form 389 Linking a Form to a Procedure 391 Loading and Unloading a Form 392 Displaying and Hiding a Form 392 Setting a Default Command Button 393 Retrieving the User’s Choices from a Dialog Box 393 Returning a String from a Text Box 393 Returning a Value from an Option Button 394 Returning a Value from a Check Box 395 Returning a Value from a List Box 395 Returning a Value from a Combo Box 396 Examples Showing How to Connect Forms to Procedures 397 Word Example: The Move-Paragraph Procedure 397 General Example: Opening a File from a List Box 409 Building the User Form 409 Creating the Code for the User Form 411 Using an Application’s Built-In Dialog Boxes 415 Displaying a Built-In Dialog Box 415 Setting and Restoring Options in a Built-In Dialog Box 419 Which Button Did the User Choose in a Dialog Box? 419 Specifying a Time-Out for a Dialog Box 420 The Bottom Line 421 Chapter 15 Creating Complex Forms 423 Creating and Working with Complex Dialog Boxes 424 Updating a Dialog Box to Reflect the User’s Choices 424 Revealing a Hidden Part of a Form 424 Tracking a Procedure in a Form 429 Using Multipage Dialog Boxes and TabStrip Controls 432 Creating a Modeless Dialog Box 443 Specifying a Form’s Location Onscreen 444 Using Events to Control Forms 445 Events Unique to the UserForm Object 448 Events That Apply to Both UserForms and Container Controls 453 Events That Apply to Many or Most Controls 458 Events That Apply Only to a Few Controls 471 The Bottom Line 472 Part 5 Creating Effective Code 473 Chapter 16 Building Modular Code and Using Classes 475 Creating Modular Code 475 What Is Modular Code? 476 Advantages of Using Modular Code 476 The Bottom Line 503 Chapter 17 Debugging Your Code and Handling Errors 505 Principles of Debugging 505 The Different Types of Errors 507 Language Errors 507 Compile Errors 507 The Bottom Line 551 Chapter 18 Building Well-Behaved Code 537 What Is a Well-Behaved Macro? 537 Retaining or Restoring the User Environment 539 Chapter 19 Exploring VBA’s Security Features 553 Understanding How VBA Implements Security 553 Signing Your Macro Projects with Digital Signatures 557 What Is a Digital Certificate? 557 The Bottom Line 574 Part 6 Programming the Office Applications 575 Chapter 20 Understanding the Word Object Model and Key Objects 577 Examining the Word Object Model 577 Working with the Documents Collection and the Document Object 581 Creating a Document 581 The Bottom Line 609 Chapter 21 Working with Widely Used Objects in Word 611 Using Find and Replace via VBA 611 Understanding the Syntax of the Execute Method 613 Putting Find and Replace to Work 616 Working with Headers, Footers, and Page Numbers 617 The Bottom Line 642 Chapter 22 Understanding the Excel Object Model and Key Objects 645 Getting an Overview of the Excel Object Model 645 Understanding Excel’s Creatable Objects 646 Managing Workbooks 647 Creating a Workbook 647 The Bottom Line 670 Chapter 23 Working with Widely Used Objects in Excel 671 Working with Charts 671 Creating a Chart 671 Specifying the Source Data for the Chart 673 The Bottom Line 685 Chapter 24 Understanding the PowerPoint Object Model and Key Objects 687 Getting an Overview of the PowerPoint Object Model 687 Understanding PowerPoint’s Creatable Objects 688 Working with Presentations 689 The Bottom Line 707 Chapter 25 Working with Shapes and Running Slide Shows 709 Working with Shapes 709 Adding Shapes to Slides 709 Deleting a Shape 715 The Bottom Line 729 Chapter 26 Understanding the Outlook Object Model and Key Objects 731 Getting an Overview of the Outlook Object Model 731 The Outlook Object Model 732 Understanding Where Outlook Stores VBA Macros 733 Understanding Outlook’s Most Common Creatable Objects 734 The Bottom Line 752 Chapter 27 Working with Events in Outlook 755 How Event-Handler Procedures Differ from Ordinary Macros 755 Working with Application-Level Events 756 Using the Startup Event 758 The Bottom Line 773 Chapter 28 Understanding the Access Object Model and Key Objects 775 Getting Started with VBA in Access 775 Creating a Module in the VBA Editor 778 Creating a Function 778 The Bottom Line 800 Chapter 29 Accessing One Application from Another Application 801 Understanding the Tools Used to Communicate Between Applications 801 Using Automation to Transfer Information 802 Understanding Early and Late Binding 803 The Bottom Line 830 Appendix A The Bottom Line 833 Chapter 1: Recording and Running Macros in the Office Applications 833 Chapter 2: Getting Started with the Visual Basic Editor 835 Chapter 3: Editing Recorded Macros 836 Chapter 4: Creating Code from Scratch in the Visual Basic Editor 836 Chapter 5: Understanding the Essentials of VBA Syntax 839 Chapter 6: Working with Variables, Constants, and Enumerations 840 Chapter 7: Using Array Variables 842 Chapter 8: Finding the Objects, Methods, and Properties You Need 843 Chapter 9: Using Built-in Functions 844 Chapter 10: Creating Your Own Functions 846 Chapter 11: Making Decisions in Your Code 847 Chapter 12: Using Loops to Repeat Actions 849 Chapter 13: Getting User Input with Message Boxes and Input Boxes 850 Chapter 14: Creating Simple Custom Dialog Boxes 851 Chapter 15: Creating Complex Forms 855 Chapter 16: Building Modular Code and Using Classes 856 Chapter 17: Debugging Your Code and Handling Errors 858 Chapter 18: Building Well-Behaved Code 859 Chapter 19: Exploring VBA’s Security Features 860 Chapter 20: Understanding the Word Object Model and Key Objects 862 Chapter 21: Working with Widely Used Objects in Word 863 Chapter 22: Understanding the Excel Object Model and Key Objects 864 Chapter 23: Working with Widely Used Objects in Excel 865 Chapter 24: Understanding the PowerPoint Object Model and Key Objects 866 Chapter 25: Working with Shapes and Running Slide Shows 867 Chapter 26: Understanding the Outlook Object Model and Key Objects 868 Chapter 27: Working with Events in Outlook 869 Chapter 28: Understanding the Access Object Model and Key Objects 870 Chapter 29: Accessing One Application from Another Application 871 Index 873

Read more less

Book SynopsisBring mixed reality into your office workplace by building immersive experiences using data and content from your Office 365 platform. Imagine being able to sit at your desk and surround yourself with a 3D chart showing your work relationships as mined from your relationships with others based on how you collaborate together. This book shows you how to access your Office 365 data using the Microsoft Graph API, and then helps you present that data in a 3D modeling visualization using the Microsoft HoloLens 2 as a mixed reality device.  This book covers the growing number of tools and techniques you can use to access and visualize data on a Microsoft HoloLens 2 device. Foremost is the Graph API, giving access to the full range of data in Office 365. Also covered are Unity and Visual Studio, the development environments from which you can create mixed reality applications for Microsoft HoloLens 2. You will learn how to load data from and save data to your Office 365 platTable of Contents1. Immersive Experiences 2. Controlling Data 3. Environment and Configuration 4. Unity 5. Unity Advanced 6. HoloLens 7. HoloLens Development 8. Visualization 9. Building A Social App 10. Model Implementation 11. Interact with the Model

Read more less

Book SynopsisBecome a self-sufficient citizen developer by learning the tools within the Microsoft Power Platform and how they can be used together to drive change and multiply your productivity. Learn about PowerApps for building applications, Power Automate for automating business processes across those applications, and Power BI for analyzing results and communicating business intelligence through compelling visuals. By understanding the purpose and capabilities of these tools, you will be able to enhance your organization's visibility into key areas and make informed business decisions in a timely matter. This book is divided into four parts and begins in Part I by showing you how to build applications through PowerApps. You will learn about screens and controls, application sharing and administration, and how to make your applications accessible from mobile devices such as phones and tablets. Part II is about creating workflows using Power Automate that implement business logic across your applications. Part III brings in dashboards and data analysis, showing you how to connect to a data source, cleanse the data from that source, and drive decision making through interactive reports and storytelling. Part IV brings together all the pieces by showing the integrations that are possible when all three tools are combined into a single solution.What You Will Learn Understand the need for the citizen developer in today's business environment Organize and plan the building of line-of-business applications with PowerApps solutions  Replace wasteful paper processes with automated applications built in PowerApps Automate workflows across processes with Power Automate Communicate analytical results through visualizations and storytelling Integrate PowerApps, Power Automate, and Power BI into solutions that multiply productivity Who This Book Is ForPower users and analysts with strong Excel skills who need a more comprehensive set of tools that can better help them accomplish their vision on projects, those familiar with one of the Power Platform tools who wish to learn how all three can fit together, and those who are seen as as rogue IT problem solvers who get things done when others have tried but failed Table of ContentsIntroductionPart I. Building Line of Business Applications with PowerApps1. Introduction to PowerApps2. Building Your First PowerApp3. Exploring PowerApps Screens and Controls4. Working with PowerApps Expressions5. Leveraging Variables and Collections6. Securing and Sharing Apps7. Managing Power Apps8. Common Data Services and Model-Driven AppsPart II. Task Automation with Microsoft Flow9. Introduction to Power Automate10. Building Your First Flow11. Exploring Different Trigger Types12. Working with Flow Expressions13. Building Conditional Flows14. Designing Approval Flows15. Administering Power AutomatePart III. Dashboards, Reporting, and Analytics with Power BI16. Introduction to Power BI17. Connecting to Data18. Defining Data Cleansing Business Rules with the Power Query Editor19. Data Model Design20. Extending Your Data Model with DAX Calculations21. Report Writing Basics22. Designing Interactive Reports23. Data Storytelling with Power BI24. Sharing Power BI Solutions25. Administering Power BIPart IV. Integrating the Power Platform Tools Together26. Power Platform Integration in PowerApps27. Power Platform Integration in Microsoft Flow28. Power Platform Integration in Power BI29. Designing a Fully Integrated Power Platform Solution

Read more less

Book SynopsisEnhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 of the most useful Excel functions are covered with numerous practical examples of their use. This book is fully updated and includes examples of the most recently released functions in 2022. It is written in a manner that you can read it cover-to-cover or pick it up and learn something new in just 5 minutes.The book begins with a primer on Excel formulas and functions. Starting from a basic level, but diving into intricate detail and building a solid understanding of the fundamentals. It may not always be sexy, but learning why, in addition to how, is important to truly understanding Excel formulas. Having strong fundamentals is the most advanced skill.The book covers all the most popular functions in Excel including VLOOKUP, SUMPRODUCT, COUNTIFS, MATCH, SORT and so much more. You will learn how to return multiple results with a single formula. Harness tTable of ContentsChapter 1: Excel Formulas – A Quick Primer Chapter Goal: Start the journey to mastering formulas in Excel No of pages: 25 This chapter is the first of many on formulas in Excel. It will start with basic mathematical operations, explain the structure of formulas inside-out, look at some basic functions and cover absolute cell addresses. Chapter 2: Logical Formulas Chapter Goal: Learn the important logical functions in Excel. No of pages: 35 This chapter will explain how and when to use logical functions including IF, IFS, AND, OR, XOR, IFERROR, IFNA and SWITCH. These functions are the initial building blocks of automated Excel models and reports. Their importance cannot be understated. Chapter 3: Defined Names Chapter Goal: Understand the use and hidden brilliance of defined names. No of pages: 25 This chapter explores defined names in-depth. This little-known feature has huge benefits in how we use and deploy ranges and formulas in Excel. Chapter 4: You Need to Start Using Tables Chapter Goal: To understand and master the use of Tables No of pages: 30 This chapter will introduce the reader to tables in Excel. It will explain the many benefits to their use and how to use them effectively. Chapter 5: Manipulating Text Chapter Goal: Learn the most useful text functions of Excel No of pages: 40 This chapter will look at the formulas to extract, combine, replace, and format text. These include but are not limited to LEN, MID, SEARCH, DOLLAR, CONCAT and VALUE. Chapter 6: Working with Dates and Times Chapter Goal: Learn the popular date and time functions of Excel No of pages: 40 This chapter will explain how dates and times are stored, and are to be used, in Excel. We will use different date and time functions to perform transformations and various calculations. Chapter 7: The Infamous VLOOKUP Function Chapter Goal: Master this vital function No of pages: 35 This chapter is dedicated to the third most used function in Excel. It fully explains how to use VLOOKUP in a way people have probably not heard before. It will also cover some insider tricks to avoid common VLOOKUP limitations and mistakes. A variety of examples will be shown. Chapter 8: Advanced Lookup Formulas Chapter Goal: Learn more advanced lookup functions. No of pages: 40 In this chapter, we explore functions such as INDEX, OFFSET, MATCH, CHOOSE and INDIRECT to build upon the concepts learnt with VLOOKUP. We will see alternative ways to complete a task dependent upon the scenario. Chapter 9: The Awesome SUMIFS, COUNTIFS and Friends Chapter Goal: Learn how to use these two exceptional functions. No of pages: 40 This chapter will explain these two functions with various examples. They are two of the best and have come to my aid so many times in the past. The chapter also shows the AVERAGEIFS, MINIFS and MAXIFS functions. Chapter 10: Next Level Aggregation Functions Chapter Goal: Learn the SUMPRODUCT and AGGREGATION functions. No of pages: 30 This chapter will look at the SUMPRODUCT and AGGREGATE functions. This chapter follows on nicely from the previous one as these functions have more power than SUMIFS and COUNTIFS. Chapter 11: Dynamic Array Formulas Chapter Goal: Understand how to efficiently use dynamic array formulas No of pages: 40 This chapter introduces the reader to dynamic array formulas. These formulas are available to 365 users only. Therefore, it is essential that it is understood how these formulas are best used, and how they may affect you if you are not a 365 user. Chapter 12: XLOOKUP – The New Kid on the Block Chapter Goal: Learn how and when to use the XLOOKUP function No of pages: 20 This chapter is all about the XLOOKUP function. What does it offer that the other lookup function could not? When is the best time to use it? All will be covered in this chapter. Chapter 13: FILTER Function – The Game Changer Chapter Goal: Learn how to effectively use the FILTER function No of pages: 20 This chapter focuses on the impressive FILTER function. Several examples are shown to demonstrate the FILTER function performing tasks that other functions cannot do. Chapter 14: Table Rankings and Top N Lists Chapter Goal: Learn to create different dynamic table rankings No of pages: 20 This chapter uses functions and skills learnt over previous chapters to create different table ranking and top N lists. These are common tasks, but difficult to perform without advanced Excel formula skills. Chapter 15: Getting Status Information Chapter Goal: Learn how to retrieve status of cells and the Excel environment No of pages: 20 This chapter will look at the CELL, TYPE, and INFO functions of Excel. They are used to return information about cells, data types and the operating environment. We can the utilise this information in other functions. Chapter 16: The LET and LAMBDA Functions Chapter Goal: Understand these two new functions No of pages: 30 This chapter will look the LET and LAMBDA functions introduced to Excel 365 in 2020/2021. They are freshly released and change how Excel users will write complex formulas. This chapter will explain how and when to use these power functions.

Read more less

Book SynopsisWelcome to the most comprehensive foundational guide available on the topic of C# coding and .NET. This book goes beyond do this, to achieve this to drill down into the core stuff that makes a good developer, great. This expanded 11th edition delivers loads of new content on Entity Framework, Razor Pages, Web APIs and more. You will find the latest C# 10 and .NET 6 features served up with plenty of behind the curtain discussion designed to expand developers' critical thinking skills when it comes to their craft. Coverage of ASP.NET Core, Entity Framework Core, and more sits alongside the latest updates to the new unified .NET platform, from performance improvements to Windows Desktop apps on .NET 6, updates in XAML tooling, and expanded coverage of data files and data handling. Going beyond the latest features in C# 10, all code samples are rewritten for this latest release.Dive in and discover why this essential classic is a favorite of C# developers worldwide. Gain a solid fouTable of ContentsPart 1: Introducing C# and .NET 61 Introducing C# and .NET (Core) 62 Building C# ApplicationsPart 2: Core C# Programming3 Core C# Programming Constructs, Part 14 Core C# Programming Constructs, Part 2Part 3: Object Oriented Programming with C#5 Understanding Encapsulation6 Understanding Inheritance and Polymorphism7 Understanding Structured Exception Handling8 Working with Interfaces9 Understanding Object LifetimePart 4: Advanced C# Programming10 Collections and Generics11 Advanced C# Language Features12 Delegates, Events, and Lambda Expressions13 LINQ To Objects14 Processes, AppDomains, and Load Contexts15 Multithreaded, Parallel, and Async ProgrammingPart 5: Programming with .NET Core Assemblies16 Building and Configuring Class Libraries17 Type Reflection, Late Binding, Attributes, and Dynamic Types18 Understanding CIL and the Role of Dynamic AssembliesPart 6: File Handling, Object Serialization, and Data Access19 File I/O and Object Serialization20 Data Access with ADO.NETPart 7: Entity Framework Core21 Introducing Entity Framework Core22 Exploring EF Core 23 Build a Data Access Layer with Entity Framework Core24 Test Driving the Autolot Data Access LayerPart 8: Windows Client Development25 Introducing Windows Presentation Foundation and XAML26 WPF Controls, Layouts, Events, and Data Binding27 WPF Graphics Rendering Services28 WPF Resources, Animations, Styles, and Templates29 WPF Notifications, Validations, Commands, and MVVMPart 9: ASP.NET Core30 Introducing ASP.NET Core31 Diving into ASP.NET Core32 RESTful Services with ASP.NET Core33 Web Applications using MVC34 Web Applications using Razor Pages

Read more less

Book SynopsisProfessional developers will produce leaner applications for the ASP.NET Core platform using the guidance in this best-selling book, now in its 9th edition and updated for ASP.NET Core for .NET 6. It contains detailed explanations of the ASP.NET Core platform and the application frameworks it supports. This cornerstone guide puts ASP.NET Core for .NET 6 into context and dives deep into the tools and techniques required to build modern, extensible web applications. New features and capabilities such as MVC, Razor Pages, Blazor Server, and Blazor WebAssembly are covered, along with demonstrations of how they are applied.ASP.NET Core for .NET 6 is the latest evolution of Microsoft's ASP.NET web platform and provides a host-agnostic framework and a high-productivity programming model that promotes cleaner code architecture, test-driven development, and powerful extensibility.Author Adam Freeman has thoroughly revised this market-leading book and explains how to get the mosTable of ContentsPart 1 1. Putting ASP.NET Core into Context 2. Getting Started 3. Your First ASP.NET Core Application 4. Using the Development Tools 5. Essential C# Features 6. Unit Testing ASP.NET Core Applications 7. SportsStore 8. SportsStore: Navigation & Cart 9. SportsStore: Completing the Cart 10. SportsStore: Adminstration 11. SportsStore: Security & Deployment Part 2 12. Understanding the ASP.NET Core Platform 13. Using URL Routing 14. Using Dependency Injection 15. Using the Platform Features, Part 1 16. Using the Platform Features, Part 2 17. Working with Data Part 3 18. Creating the Example Project 19. Creating RESTFul Web Services 20. Advanced Web Service Features 21. Using Controllers with Views 22. Using Controllers with Views, Part 2 23. Using Razor Pages 24. Using View Components 25. Using Tag Helpers 26. Using the Built-In Tag Helpers 27. Using the Forms Tag Helpers 28. Using Model Binding 29. Using Model Validation 30. Using Filters 31. Creating Form Applications Part 4 32. Creating the Example Application 33. Using Blazor Server, Part 1 34. Using Blazor Server Part 2 35. Advanced Blazor Features 36. Blazor Forms and Data 37. Blazor Web Assembly 38. Using ASP.NET Core Identity39. Applying ASP.NET Core Identity

Read more less

Book SynopsisLearn the essential design and deployment skills to utilize Azure VMware Solution to seamlessly move your VMware-based workloads from your datacenter to Azure and to integrate your VMware environment with Azure.  This book will teach you how to manage your existing environments with the same VMware products you already know while modernizing your applications with Azure native services.Design and Deploy Azure VMware Solutions starts by reviewing Azure VMware essentials, followed by a walkthrough of the methods of preparing and expanding to Azure VMware Solution. Here, you will learn about the layers of Microsoft AVS, including the vSphere, vSAN, NSX-T, and assess and migrate on-prem VMware workloads to Azure VMware Solution using HCX. Further, you will understand how to deploy the desktop and learn Hosting Pool using Horizon on Microsoft Azure, a modern approach to managing and securing Horizon components. VMware Tanzu for moderniziTable of ContentsChapter 1: Getting Started with AVS Introduction to Azure VMware Solution Inner engineering of Azure VMware Solution Identify use case for Azure VMware SolutionChapter 2: Datacenter footprint reduction and expansion with Azure VMware Solution Prepare Azure based VMware vSphere, NSX-T, and vSAN. Design Azure based VMware vSphere, NSX-T, and vSAN. Deploy Azure based VMware vSphere, NSX-T, and vSAN. Monitor and Secure Azure based VMware vSphere, NSX-T, and vSAN. Chapter 3: Desktop virtualization with Azure VMware Solution. Prepare Azure based VMware Horizon and it’ suite. Design Azure based VMware Horizon and it’ suite. Deploy Azure based VMware Horizon and it’ suite. Monitor Azure based VMware Horizon and it’ suite. Chapter 4: Application modernization with Azure VMware Solution. Prepare Azure based VMware Tanzu Standard. Design Azure based VMware Tanzu Standard. Deploy Azure based VMware Tanzu Standard. Monitor Azure based VMware Tanzu Standard. Chapter 5: Disaster recovery with Azure VMware Solution. BC/DR Prepare for VMware workload based out of Azure. BC/DR Design for VMware workload based out of Azure. BC/DR Drill for VMware workload based out of Azure. BC/DR Orchestration for VMware workload based out of Azure. Chapter 6: VMware vRealize suite for Azure VMware Solution. Plan, optimize, and scale Azure VMware Solution using VMware vRealize Operations Manager. Build an optimized, highly available, and secure network Azure VMware Solution using VMware vRealize Network Insight. Plan and deploy Infrastructure as a Service (IaaS) for Azure VMware Solution via vRealize Automation. Chapter 7: Assess and migrate on-prem VMware workloads to Azure VMware Solution. Plan HCX deployment Configure Compute and Network profiles Migrate workloads to Azure VMware Solution.

Read more less

Book SynopsisThis book is a comprehensive guide covering modern cloud strategies and leadership approaches for building and scaling organizations to maturity on their cloud adoption journey. The book starts by examining technical topics from the perspective of the cloud leader, who is responsible for cloud teams and accountable for cloud products and platforms within their organization. Through a series of practical insights and real-world examples, you will gain a deep understanding of the key considerations for leading a cloud-driven organization. These considerations include understanding the benefits of digital transformation, managing global tech teams, and delivering excellence through platform ownership. Towards the end of the book, you will explore the latest trends and best practices for strategically innovating and scaling your organization in the cloud. With the knowledge gained from this book, you will be able to harness the poTable of Contents​ Part I: Leadership Essentials.- 1. The Art of Cloud Leadership.- 2. Influencing Change and Driving Cloud Adoption.- 3. Managing Teams in the Digital Age.- 4. Supporting Employee Health & Turnover.- Part II: Innovation Strategies.- 5. Adopting a Cloud Platform.- 6. Democratizing Data & Democratizing Analytics.- 7. Applying DevOps.- 8. New Horizons in Distributed Cloud Computing.- 9. Impacts of Modern AI and ML Trends.- Part III: Platform Ownership.- 10. Owning a Portfolio of Agile Cloud Products.- 11.Designing a Secure Data Lake.- 12. Administering and Auditing the Cloud.- 13. Collaborating with Cloud Vendors and Providers.- Part IV: Delivery Excellence.- 14. Creating a Technology Delivery Roadmap.- 15. Cloud Transformation Roles and Responsibilities.- 16. Delivering Strategic Cloud Innovation and Excellence.- 17. Managing Agile Cloud Projects.- 18. Achieving Digital Transformation Success.

Read more less

Book SynopsisAssembly x64 Programming in easy steps shows how to write code to create your own computer programs. It contains separate chapters demonstrating how to store and manipulate data in 64-bit registers, how to control program flow, and how to create reusable blocks of code in program functions. It includes demonstrations of parallel processing with 128-bit Streaming SIMD Extensions (SSE) and 256-bit Advanced Vector Extensions (AVX).Assembly x64 Programming in easy steps has an easy-to-follow style that will appeal to anyone who wants to begin programming in modern x64 Assembly language on Windows. The code in the listed steps within the book is color-coded, making it easier for beginners to grasp. There are complete step-by-step example programs that demonstrate each aspect of coding, together with screenshots that illustrate the actual output when each program is executed.Includes free, downloadable source code to get you started straightaway!

Read more less

Book SynopsisAmazon Web Services (AWS) is the leading public cloud platform. In this book you will learn to use Microsoft PowerShell to create, host, manage, and administer workloads using Amazon Web Services. You will learn how to create virtual machines, provision storage, configure networks, and more-all using your preferred Windows scripting language.CIOs everywhere are leading their organizations to the cloud, but there are few books available to help. This book focuses on moving Microsoft Windows workloads to the cloud using technologies familiar to enterprise Microsoft-based professionals.The completely revised and expanded Pro PowerShell for Amazon Web Services is written specifically for Windows professionals who already know PowerShell and want to learn to host Windows workloads on Amazon Web Services. The cloud offers information technology workers significant cost savings and agility unimaginable even just a few years ago. Tasks that traditionally took weeks of work, costing thousands of dollars, can be completed in minutes for a fraction of a penny.New chapters in this second edition cover: AWS Lambda, Amazon WorkSpaces, Amazon AppStream 2.0, AWS Directory Service, Amazon WorkDocs, and AWS System Manager.What You''ll Learn Create and manage Windows servers on Elastic Compute Cloud (EC2) Configure and secure networks with Virtual Private Cloud (VPC) Leverage autoscaling to adjust resources as load changes Deploy and manage SQL Server using the Relational Database Service (RDS) Manage virtual desktops using WorkSpaces and AppStream Leverage AWS Systems Manager to manage Windows at scale Who This Book Is ForWindows professionals who want to learn more about Amazon Web Services, with a focus on running Windows workloads and automated management at scale using PowerShell tools for AWS. The book assumes you have knowledge of Windows and PowerShell, but are new to AWS.Table of Contents

Read more less

Book Synopsis

Read more less

Book Synopsis

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

Book SynopsisUse the valuable Entity Framework Core 2.0 tool in ASP.NET and the .NET Framework to eliminate the tedium around accessing databases and the data they contain. Entity Framework Core 2.0 greatly simplifies access to relational databases such as SQL Server that are commonly deployed in corporate settings.Table of ContentsIntroduction1. Getting Started2. Working with Multiple Tables3. Stepping Beyond the Basics4. Data Validation and POCO's5. Stored Procedures, Table Design and Modifications6. ASP.NET MVC and EF Core 2.07. Finishing our ASP.NET MVC .NET Core 2.0 Project8. Wrap-up and Where to Go Next9. Appendix A: Database Script for Chapter 6

Read more less

Book Synopsis Use ASP.NET Core 2 to create durable and cross-platform web APIs through a series of applied, practical scenarios. Examples in this book help you build APIs that are fast and scalable. You''ll progress from the basics of the framework through to solving the complex problems encountered in implementing secure RESTful services. The book is packed full of examples showing how Microsoft''s ground-up rewrite of ASP.NET Core 2 enables native cross-platform applications that are fast and modular, allowing your cloud-ready server applications to scale as your business grows.  Major topics covered in the book include the fundamentals and core concepts of ASP.NET Core 2. You''ll learn about building RESTful APIs with the MVC pattern using proven best practices and following the six principles of REST. Examples in the book help in learning to develop world-class web APIs and applications that can run on any platform, including Windows, Linux, and MacOS. YouTable of Contents1. API Design Demystified2. Introduction to ASP.NET Core3. Your First API Application4. Extensibility Architecture5. MVC 6. The Configuration Model7. Logging and Error Handling8. Securing APIs9. Bells & Whistles10. Testing & Debugging11. Hosting & Deployment

Read more less

Book SynopsisLearn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server Integration Services (SSIS). Bring all the power of Transact-SQL (T-SQL) and Microsoft .NET to bear on your repetitive data, data integration, and ETL processes. Do this for no added cost over what you''ve already spent on licensing SQL Server. The tools and methods from this book may be applied to on-premises and Azure SQL Server instances. The SSIS framework from this book works in Azure Data Factory (ADF) and provides DevOps personnel the ability to execute child packages outside a project-functionality not natively available in SSIS.Frameworks not only reduce the time required to deliver enterprise functionality, but can also accelerate troubleshooting and problem resolution. You''ll learn in this book how frameworks also improve code quality by using metadata to drive processes. Much of the work performed by data professionals can be classiTable of ContentsPart I: Stored Procedure-Based Database Frameworks1. Stored Procedures 1012. Automation with Stored Procedures3. Stored Procedure Orchestrators4. A Stored Procedure-Base Metadata-Driven FrameworkPart II: SSIS Frameworks5. A Simple Custom File-Based SSIS Framework6. Framework Execution Engine7. Framework Logging8. Azure-SSIS Integration Runtime9. Deploy A Simple Custom File-Based Azure-SSIS Framework10. Framework Logging in ADF11. Fault Tolerance in the ADF Framework

Read more less

Book SynopsisUse this one-stop resource for both basic and advanced administration of Exchange Server 2019 and 2016. It will help you in running an Exchange environment, whether it be 100% on-premises or a hybrid configuration with Exchange Online (as part of Office 365). This revised version is divided into four parts, describing Exchange infrastructure, upgrading Exchange server, integration with Office 365, and security and compliance. In the first part, you will go through a short introduction of Exchange server followed by its installation and configuration. You will learn client access along with Exchange mailbox and managing Exchange recipients. In the second part, you will learn how to upgrade from Exchange 2010 to 2016 and from 2013 to Exchange 2019. The third part is dedicated to the Exchange integration with Office 365, followed by the last part that teaches you how to secure your Exchange environment and its compliance. After reading this book, you will understand best practices, doTable of ContentsSection 1 - Exchange Infrastructure 1. Introduction 1.1. History of Exchange server 1.2. Exchange 2016 or Exchange 2019? 1.3. Exchange Admin Center 1.4. PowerShell 1.5. Exchange and Active Directory 2. Installing and configuring Exchange 2.1. Designing the Exchange environment 2.2. Testing the Exchange environment 2.3. Building the Exchange environment 2.4. Exchange Edge Transport Server 2.5. Cumulative Updates 3. Exchange and Client Access 3.1. Clients 3.2. Outlook on the Web 3.3. Outlook 3.4. Autodiscover 3.5. Exchange Web Services 3.6. ActiveSync 3.7. Namespaces 3.8. Virtual Directories 3.9. Certificates 3.10. Client Access High Availability 4. Exchange Mailbox and Mailbox server 4.1. Mailbox databases 4.2. Backup and Restore 4.3. High Availability 4.4. Mailbox database High Availability 5. Managing Exchange Recipients 5.1. Managing Recipients 5.2. Mailboxes 5.3. Distribution Groups 5.4. Contacts 5.5. Public Folders 5.6. Address Lists 5.7. Global Address List 5.8. Custom Address List 5.9. Offline Address Books 5.10. Address Book Policies 6. Exchange Transport 6.1. Transport pipeline 6.2. Send and Receive Connectors 6.3. SMTP Relay 6.4. Edge Transport server 6.5. Load balancing transport Section 2 - Upgrading Exchange server 7. Upgrading from Exchange 2010 to Exchange 2016 7.1. Preparing Active Directory 7.2. Installing the Exchange servers 7.3. Change client access 7.4. Move Mailboxes 7.5. Move Public Folders 7.6. Decommission Exchange 2010 8. Upgrading from Exchange 2013 to Exchange 2019 8.1. Preparing AD en Installing Exchange is identical to 7.1 and 7.2 8.2. Client access in 2013/2019 coexistence 8.3. Move Mailboxes and Public Folders 8.4. Decommission Exchange 2013 Section 3 - integration with Office 365 9. Exchange Hybrid 9.1. Identities and source of authority 9.2. Managing Hybrid Recipients 9.3. Federation 9.4. Federation with other organizations 9.5. Organizational relationships 9.6. Sharing policies 9.7. Directory Synchronization 9.8. Exchange Hybrid Configuration Wizard 9.9. Autodiscover continued 9.10. Mailflow in coexistence 9.11. Exchange Online Protection 9.12. Modern Authentication 9.13. Bulk Email Section 4 - Security and Compliance 10. Securing your Exchange environment 10.1. Hybrid Modern Authentication 10.2. Message hygiene 10.3. Multi Factor Authentication 10.4. Role Based Access Control 11. Compliance 11.1. Archiving 11.2. Journaling 11.3. In-place hold 11.4. In-place eDiscovery 11.5. Messaging Records management 11.6. Data Loss Prevention 11.7. Auditing 11.8. Reporting

Read more less

Book SynopsisKnow the fundamentals of creating and deploying microservices using .NET 6 and gain insight from prescriptive guidance in this book on the when and why to incorporate them.The microservices architecture is a way of distributing process workloads to independent applications. This distribution allows for the independent applications to scale and evolve separately. It also enables developers to dismantle large applications into smaller, easier-to-maintain, scalable parts. While the return is valuable and the concept straightforward, applying it to an application is far more complicated. Where do you start? How do you find the optimal dividing point for your app, and strategically, how should your app be parceled out into separate services?Pro Microservices in .NET 6 will introduce you to all that and more. The authors get you started with an overview of microservices, .NET 6, event storming, and domain-driven design. You will use that foundational infTable of Contents 1. Introducing Microservices - Sean 2. ASP.NET Core Overview- Sean 3. Searching for Microservices- Sean 4. First Microservice- Sean 5. Microservice Messaging- Sean 6. Decentralizing Data - Josh 7. Testing Microservices - Sean 8. Containerization - Matthew 9. Healthy Microservices – Rob

Read more less

Book SynopsisAre you a reasonably competent Power BI user but still struggling to generate reports that truly tell the story of your data? Or do you simply want to extend your knowledge of Power BI by exploring more complex areas of visualizations, data modelling, DAX, and Power Query? If so, this book is for you. This book serves as a comprehensive resource for users to implement more challenging visuals, build better data models, use DAX with more confidence, and execute more complex queries so they can find and share important insights into their data. The contents of the chapters are in a question-and-answer format that explore everyday data analysis scenarios in Power BI. These questions have been generated from the author's own client base and from commonly sought-for information from the Power BI community.They cover a wide and diverse range of topics that many Power BI users often struggle to get to grips with or don't fully understand.Examples of suchquestions are:How can I generate dynamiTable of ContentsChapter 1: Working with Visualizations.- Chapter 2: Slicers and Filtering.- Chapter 3: The Matrix.- Chapter 4: Date Calculations.- Chapter 5: Data Modelling.- Chapter 6: DAX Conundrums.- Chapter 7: Customers and Products.- Chapter 8: Employees.- Chapter 9: Power Query.

Read more less

Book Synopsis

Read more less

Book SynopsisChapter 1: Introduction to Microsoft Project: Understanding the Platform.- Chapter 2: Getting Started with Microsoft Project.- Chapter 3: Managing tasks with Microsoft Project.- Chapter 4: Resource Management using Microsoft Project.- Chapter 5: Fine Tuning Project Schedule.- Chapter 6: Budget and Cost Management using Microsoft Project.- Chapter 7: Seamless integration of Microsoft Project with Microsoft 365 family.- Chapter 8: Agile Project Management using Microsoft Project.- Chapter 9: Microsoft Project Reports and Analytics.- Chapter 10: Advanced Features of Microsoft Project and Future Trends in Project Management.

Read more less

Book SynopsisVisual Basic in easy steps, 6th edition gives you code examples, screenshots, and step-by-step instructions that illustrate each aspect of Visual Basic so you''ll be creating your own interactive applications in no time!. You need have no previous knowledge of any programming language so it''s ideal if you''re a newcomer to Windows programming. Each chapter builds your knowledge of Visual Basic. By the end of this book you will have gained a sound understanding of Visual Basic programming and be able to create your own interactive applications. Visual Basic in easy steps, 5th edition has an easy-to-follow style that will appeal to anyone who wants to begin Windows programming. It will appeal to programmers who want to quickly learn the latest Visual Basic techniques, and to the student who is studying computing at school or college, and to those seeking a career in Information Technology who needs a thorough understanding of Visual Basic programming.

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

Book SynopsisOverview of Object-Oriented Programming.- Designing OOP Solutions: Identifying the Class Structure.- Designing OOP Solutions: Modeling the Object Interaction.- Designing OOP Solutions: A Case Study.- Introducing the .NET Framework and Visual Studio.- Creating Classes.- Creating Class Hierarchies.- Implementing Object Collaboration.- Working with Collections.- Implementing the Data Access Layer.- Developing WPF Applications.- Developing Web Applications.- Developing Windows Store Applications.- Developing and Consuming Web Services.- Developing the Office Supply Ordering Application.- Wrapping UpTable of ContentsOverview of Object-Oriented Programming.- Designing OOP Solutions: Identifying the Class Structure.- Designing OOP Solutions: Modeling the Object Interaction.- Designing OOP Solutions: A Case Study.- Introducing the .NET Framework and Visual Studio.- Creating Classes.- Creating Class Hierarchies.- Implementing Object Collaboration.- Working with Collections.- Implementing the Data Access Layer.- Developing WPF Applications.- Developing Web Applications.- Developing Windows Store Applications.- Developing and Consuming Web Services.- Developing the Office Supply Ordering Application.- Wrapping Up

Read more less

Book SynopsisChapter 1: Azure--A Solutions Development Platform.- Chapter 2: Beginning Application Development with Azure Web Apps, SQL Database, and Blob Storage.- Chapter 3: DevOps with Visual Studio Team Services and Azure.- Chapter 4: Azure Active Directory and Multi-Tenancy.- Chapter 5: Getting Started with Azure NoSQL Services.- Chapter 6: Security and Data Protection.- Chapter 7: Integrating Azure Search.- Chapter 8: Data Visualization with Power BI Embedded.Table of ContentsChapter 1: Azure--A Solutions Development Platform.- Chapter 2: Beginning Application Development with Azure Web Apps, SQL Database, and Blob Storage.- Chapter 3: DevOps with Visual Studio Team Services and Azure.- Chapter 4: Azure Active Directory and Multi-Tenancy.- Chapter 5: Getting Started with Azure NoSQL Services.- Chapter 6: Security and Data Protection.- Chapter 7: Integrating Azure Search.- Chapter 8: Data Visualization with Power BI Embedded.

Read more less

Book SynopsisBeginning user levelTable of ContentsPart I: Power App FundamentalsChapter 1: Introducing Power AppsChapter 2: Subscribing to Power AppsChapter 3: Creating Your First AppChapter 4: Sharing AppsChapter 5: Using FormulasPart II: Working with DataChapter 6: Setting Up SharePoint, SQL, and more Chapter 7: Working with Tables and RowsChapter 8: Searching and Retrieving DataPart III: Developing Canvas AppsChapter 9: Canvas App DesignChapter 10: Using Simple ControlsChapter 11: Using Table/Record Data ControlsPart IV: Developing Model Driven and Portal AppsChapter 12: Building a Dataverse DatabaseChapter 13:Developing Model-Driven AppsChapter 14: Building Portal AppsChapter 15: Retrieving Data from Portal Apps.Part V: Enhancing AppsChapter 16: Working with Images and MediaChapter 17: Storing and Retrieving FilesChapter 18: Integrating Maps and Location ServicesChapter 19: Charting DataChapter 20: Adding Artificial Intelligence to AppsPart VI: ReusabilityChapter 21: Building Reusable Canvas ComponentsChapter 22: Building Reusable Code ComponentsPart VII: Offline and IntegrationChapter 23: Working OfflineChapter 24: Creating Custom Data ConnectorsPart VIII: Administration Chapter 25: Using Power AutomateChapter 26: Transferring Apps and DataChapter 27: Administering SecurityAppendix A - Sample App Data Structure

Read more less

Book SynopsisThe author shows developers with litte or no ADO.NET background how to apply ADO.NET fast to real world scenarios by giving examples and code that really works.Table of ContentsA table of contents is not available for this title.

Read more less

Book Synopsis* Coverage of all three significant .NET code generation mechanisms: Manual code generation, XSL/XML and CodeDom. * Includes a database metadata extraction tool based on SQL-92 standards. * Real solutions to the problem of protecting handcrafted code across regeneration. * Covers code generation in the broader picture of how applications are developed. * Includes real world samples for a complete middle tier and simple User Interface. Table of ContentsA table of contents is not available for this title.

Read more less

Book SynopsisThe Software Factory methodology is based on recognition of these similarities and a drive to extend the concept of "reusability" to the point where we achieve entirely automated product lines. Based on an analysis and understanding of the common features and techniques of a set of applications, a Software Factory defines a tailored, end-to-end methodology for building these applications. At the heart of the Software factory methodology is the concept of Domain Specific Languages (DSLs), which in essence are development environments specifically tailored to the set of applications in hand. It removes a certain degree of flexibility but greatly enhances productivity by removing a lot of the coding complexity (for an analogy, consider the use of the now ubiquitous drag-and-drop controls in Winforms or Visual Basic). Further, in the SF methodology, patterns, process advice, and best practices can be harvested and applied for all applications in the set. There are some good books on the theory of SF already on the market. Up until this point, a lot of these concepts were fairly theoretical and abstract.Trade ReviewFrom the reviews: "The purpose of this work is to introduce and demystify the concept of software factories in the .NET environment. … The book covers both the theory and practice of software factories, including an acknowledgment of the genesis of the term in the late 1960s. … this book is recommended reading for people involved in the management of large software development groups, particularly ones that develop many similar products. It provides a good theoretical discussion, and practical illustration … in the creation of software solutions." (Neil D. Burgess, ACM Computing Reviews, Vol. 49 (3), March, 2008)Table of ContentsA table of contents is not available for this title.

Read more less

Book SynopsisA complete handbook on Microsoft Identity Manager 2016 – from design considerations to operational best practices About This Book • Get to grips with the basics of identity management and get acquainted with the MIM components and functionalities • Discover the newly-introduced product features and how they can help your organization • A step-by-step guide to enhance your foundational skills in using Microsoft Identity Manager from those who have taught and supported large and small enterprise customers Who This Book Is For If you are an architect or a developer who wants to deploy, manage, and operate Microsoft Identity Manager 2016, then this book is for you. This book will also help the technical decision makers who want to improve their knowledge of Microsoft Identity Manager 2016. A basic understanding of Microsoft-based infrastructure using Active Directory is expected. Identity management beginners and experts alike will be able to apply the examples and scenarios to solve real-world customer problems. What You Will Learn • Install MIM components • Find out about the MIM synchronization, its configuration settings, and advantages • Get to grips with the MIM service capabilities and develop custom activities • Use the MIM Portal to provision and manage an account • Mitigate access escalation and lateral movement risks using privileged access management • Configure client certificate management and its detailed permission model • Troubleshoot MIM components by enabling logging and reviewing logs • Back up and restore the MIM 2015 configuration • Discover more about periodic purging and the coding best practices In Detail Microsoft Identity Manager 2016 is Microsoft's solution to identity management. When fully installed, the product utilizes SQL, SharePoint, IIS, web services, the .NET Framework, and SCSM to name a few, allowing it to be customized to meet nearly every business requirement. The book is divided into 15 chapters and begins with an overview of the product, what it does, and what it does not do. To better understand the concepts in MIM, we introduce a fictitious company and their problems and goals, then build an identity solutions to fit those goals. Over the course of this book, we cover topics such as MIM installation and configuration, user and group management options, self-service solutions, role-based access control, reducing security threats, and finally operational troubleshooting and best practices. By the end of this book, you will have gained the necessary skills to deploy, manage and operate Microsoft Identity Manager 2016 to meet your business requirements and solve real-world customer problems. Style and approach The concepts in the book are explained and illustrated with the help of screenshots as much as possible. We strive for readability and provide you with step-by-step instructions on the installation, configuration, and operation of the product. Throughout the book, you will be provided on-the-field knowledge that you won't get from whitepapers and help files.

Read more less

Book SynopsisBlazor is an essential tool if you want to build interactive web apps without JavaScript, but it has a learning curve. Updated with the latest code in .NET 7 and C# 11 and written by someone who adopted Blazor early, this book will help you overcome the challenges associated with being a beginner with Blazor and teach you the best coding practices. You’ll start by learning how to leverage the power of Blazor and exploring the full capabilities of both Blazor Server and Blazor WebAssembly. Then you'll move on to the practical part, centered around a sample project – a blog engine. You'll apply all your newfound knowledge about creating Blazor projects, the inner workings of Razor syntax, validating forms, and creating your own components. This new edition also looks at source generators, dives deeper into Blazor WebAssembly with ahead-of-time, and includes a dedicated new chapter demonstrating how to move components of an existing JavaScript (Angular, React) or MVC-based website to Blazor or combine the two. You’ll also see how to use Blazor (Hybrid) together with .NET MAUI to create cross-platform desktop and mobile applications. When you reach the end of this book, you'll have the confidence you need to create and deploy production-ready Blazor applications, and you'll have a big-picture view of the Blazor landscape.Key Features Create a production-ready Blazor application from start to finish Learn Blazor fundamentals, gain actionable insights, and discover best practices Find out how, when, and why to use Blazor Server and Blazor WebAssembly, as well as Blazor Hybrid What you will learnUnderstand the different technologies that can be used with Blazor, such as Blazor Server, Blazor WebAssembly, and Blazor Hybrid Find out how to build simple and advanced Blazor components Explore the differences between Blazor Server and Blazor WebAssembly projects Discover how Minimal APIs work and build your own API Explore existing JavaScript libraries in Blazor and JavaScript interoperability Learn techniques to debug your Blazor Server and Blazor WebAssembly applications Test Blazor components using bUnit Who this book is forThis book is for .NET web developers and software developers who want to use their existing C# skills to build interactive SPA applications running either inside the web browser using Blazor WebAssembly, or on the server using Blazor Server. You’ll need intermediate-level web-development skills, basic knowledge of C#, and prior exposure to .NET web development before you get started; the book will guide you through the rest.Table of ContentsTable of Contents Hello Blazor Creating Your First Blazor App Managing State – Part 1 Understanding Basic Blazor Components Creating Advanced Blazor Components Building Forms with Validation Creating an API Authentication and Authorization Sharing Code and Resources JavaScript Interop Managing State Part 2 Debugging the Code Testing Deploy to Production Moving from, or Combining, an Existing Site Going Deeper into WebAssembly Examining Source Generators Visiting .NET MAUI Where to Go from Here

Read more less

Book SynopsisBuild your first digital twin MVP and gain first-hand experience of using the technology, the challenges it presents, and its impact on your organizationKey Features Create a digital twin prototype using Microsoft Azure Digital Twin Explore the digital twin approach to the design, operations, and maintenance of industrial assets and products Understand key characteristics and components of a digital twin through practical use cases and business scenarios Book DescriptionDigital twin technology enables organizations to create digital representations of physical entities such as assets, systems, and processes throughout their life cycle. It improves asset performance, utilization, and safe operations and reduces manufacturing, operational, and maintenance costs. The book begins by introducing you to the concept of digital twins and sets you on a path to develop a digital twin strategy to positively influence business outcomes in your organization. You'll understand how digital twins relate to physical assets, processes, and technology and learn about the prerequisite conditions for the right platform, scale, and use case of your digital twins. You'll then get hands-on with Microsoft's Azure Digital Twins platform for your digital twin development and deployment. The book equips you with the knowledge to evaluate enterprise and specialty platforms, including the cloud and industrial IoT required to set up your digital twin prototype. Once you've built your prototype, you'll be able to test and validate it relative to the intended purpose of the twin through pilot deployment, full deployment, and value tracking techniques. By the end of this book, you'll have developed the skills to build and deploy your digital twin prototype, or minimum viable twin, to demonstrate, assess, and monitor your asset at specific stages in the asset life cycle.What you will learn Identify key criteria for the applicability of digital twins in your organization Explore the RACI matrix and rapid experimentation for choosing the right tech stack for your digital twin system Evaluate public cloud, industrial IoT, and enterprise platforms to set up your prototype Develop a digital twin prototype and validate it using a unit test, integration test, and functional test Perform an RoI analysis of your digital twin to determine its economic viability for the business Discover techniques to improve your digital twin for future enhancements Who this book is forThe digital twin book is for mid-career subject experts, including engineers and operations managers, building their first prototype (MVP) using digital twin technology. The book will help professionals responsible for mechanical, process, and reliability engineering domains. You don't have to be a developer or programmer, but beginner-level programming skills will be helpful.Table of ContentsTable of Contents Introduction to Digital Twin Planning Your Digital Twin Identifying the First Digital Twin Getting Started with Our First Digital Twin Setting Up a Digital Twin Prototype Building the Digital Twin Prototype Deployment and Value Tracking Enhancing the Digital Twin

Read more less