Microsoft programming Books
APress Microsoft Azure AI Fundamentals Certification
Book SynopsisPrepare for the Azure AI Fundamentals certification examination. This book covers the basics of implementing various Azure AI services in your business. The book not only helps you get ready for the AI-900 exam, but also helps you get started in the artificial intelligence (AI) world. The book starts with a short overview of the AI-900 exam and takes you through the exam prerequisites and the structure of the exam. You will then learn basic and advanced AI in Azure. Principles of responsible AI, Azure Machine Learning (ML), Azure Cognitive Services, and Bot Services are covered, followed by a practice test. You will go through ML fundamental concepts, model training, and validation along with case studies and a practice test for better preparation. The book includes the fundamentals of Azure and computer vision cognitive services. Various vision services and face services are demonstrated as well as analyzing image and text using OCR. You will unTable of ContentsChapter 1: AI-900 Overview of Exam Preparation Chapter Goal:The chapter introduces the exam to the learners. The exam object- ives are made clear to the readers. Readers gain understanding about exam modules, module weightage, and how much to expect from each module throughout the examination. Links to pertinent resources on Microsoft Learn would be provided for the readers' benefit. No of pages: 2 Subtopics 1. Exam Overview 2. Who is this exam for – Exam prerequisite 3. Modules and weightage in exam 4. Module Description Chapter 2: Fundamentals of Artificial Intelligence Chapter Goal: The chapter's objective is to introduce some foundational, high-level elements. These concepts would be explored in depth over the next chapters of the books. No of pages: 15 Sub - Topics 1. What is Artificial Intelligence? 2. Understanding Artificial Intelligence workloads 3. Principles of Responsible AI 4. Understanding Artificial Intelligence in Microsoft Azure 5. AI Services in Microsoft Azure 1. Azure Machine Learning 2. Azure Cognitive Service 3. Azure Bot Service 4. Azure Cognitive Search 6. Module Review 7. Introspective Practice 8. Solutions to the practice test 9. References: Microsoft Learn Chapter 3: Machine Learning Fundamental Concepts Chapter Goal: This chapter make reader familiar to the Machine Learning fundamentals introducing Machine Learning, Types of Machine Learning, Model training and validation. Here readers will also get to know about various tools used for Machine Learning. No of pages: 30 Sub - Topics: 1. What is Machine Learning? 2. Describing Core Machine Learning Concepts 1. Dataset, Features and Labels 2. Machine Learning Algorithms in brief 3. Machine Learning Workflow 4. Model Evaluation Metrics 3. Types of Machine Learning 1. Regression 2. Classification 3. Clustering 3. The two importance elements: Model Training and Validation 4. Introducing Azure Machine Learning 5. Tools for Azure Machine Learning 1 Azure Machine Learning Studio 2 Azure Machine Learning Designer 6 What is Automated Machine Learning? 7. Practical Labs: Using Azure Machine Learning Designer to build a regression model Using Azure Machine Learning Designer, create a classification model Using Azure Machine Learning Designer to build a clustering model 8. Module Review 9. Introspective Practice 10. Solutions to the practice test 11. References: Microsoft Learn Chapter 4: Computer Vision Chapter Goal: The chapter introduces readers to the fundamentals of Azure Cognitive Services in brief, as well as in depth knowledge of Computer Vision Cognitive Service. No of pages: 50 Sub - Topics: 1. Getting Started with Azure Cognitive Service Benefits of Cognitive Service Azure Cognitive Service: Speech Language Vision Decision Open AI Service 2. What is Computer Vision? 3. Computer Vision Core Elements: Image Classification and Object Detection 3. Computer Vision Application 4. Exploring Various Vision Service 1. Computer Vision 2. Custom Vision 3. Face 4. Form Recognizer 5. Understanding of OCR 6. Practical Labs: 1. Analysing image with Computer Vision 2. Training Models with Custom Vision 3. Using Face Service to analyse faces 4. Analysing text with Computer Vision Service using OCR 7. Introspective Practice Test 8. Solutions to the practice test 9. References: Microsoft Learn Chapter 5: Fundamentals of Natural Language Processing Chapter Goal: This chapter introduces readers with the responsibilities of Natural Language processing such as text analysis, language modelling, entity recognition, sentiment analysis, speech recognition and synthesis and how to leverage Microsoft Azure for NLP. No. of Pages: 50 1. Getting Started with Natural Language Processing 1. What is Natural Language Processing? 2. Core NLP Responsibilities 1. Text analysis and entity recognition 2. Sentiment analysis 3. Speech recognition and synthesis 4. Machine Translation 5. Semantic Language modelling 2. AI for Conversational Interactions 3. Microsoft Azure for NLP 1. Core Azure NLP workloads: Language, Speech and Translator 2. Language: 1. Language Detection 2. Key phrase extraction 3. Entity Detection 4. Sentiment Analysis 5. Question Answering 6. Conversational Language Understanding 3. Speech: 1. Text to speech 2. Speech to text 3. Speech translation 4. Translator 1. Text Translation 2. Microsoft Azure platform for Conversational AI 1. Azure Bot Service 3. Practical Labs: 1. Text analysis with text-analysis-service 2. Using the Speech service's speech-to-text capabilities to transcribe audible speech to text. 3. Using the Speech service's text-to-speech capabilities to generate audible speech from text. 4. Using translator service to convert text 5. Language Understanding Application Development 6. Developing a Q&A generator with Azure Bot Service 7. Provisioning chat bot using Microsoft Azure Bot Service 4. Introspective Test 5. Solutions to the Practice Test 6. References: Microsoft Learn
£41.24
APress Developing Solutions for Microsoft Azure
Book SynopsisImprove your odds of passing one of the most highly sought-after exams for developers working with Microsoft''s cloud platform: Exam AZ-204: Developing Solutions for Microsoft Azure. This book guides you through practical examples of each of the technologies covered by the exam while exposing you to the settings and interactions between platform solutions that you will need to be in command of to prepare for the exam and to use on your job in Azure development. Chapters in this book correspond directly to the exam skills outline and are delivered in a from-the-ground-up approach, allowing you to build your knowledge as you go. This approach serves to help even novice developers get up to speed quickly, while allowing more experienced developers to find the exact topics and scenarios they need to hone their skill sets as they both prepare for the exam and reference information for real-world solutions. As you work through each chapTable of ContentsIntroductionPart I. Develop for Azure1. Develop Solutions that Use Blob Storage2. Develop Solutions that Use Cosmos DB StoragePart II. Develop Azure Compute Solutions3. Implement IaaS Solutions4. Create Azure App Service Web Apps5. Azure Container Ecosystem6. Implement Azure FunctionsPart III. Implement Azure Security7. Implement User Authentication and Authorization8. Implement Secure Cloud SolutionsPart IV. Monitor, Troubleshoot, and Optimize Azure Solutions9. Implement Caching for Solutions10. Troubleshoot Solutions by Using Metrics and Log Data Part V. Connect to and Consume Azure Services and Third-Party Services11. Implement API Management12. Develop Event-Based Solutions13. Develop Message-Based Solutions
£41.24
APress Getting Started with SQL and Databases
Book SynopsisLearn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite. The book starts with a general introduction to writing SQL and covers the basic concepts. Author Mark Simon then covers database principles, and how database tables are designed. He teaches you how to filter data using the WHERE clause, and you will work with NULL, numbers, dates, and strings. You will also understand sorting results using the ORDER BY clause, sorting by calculated columns, and limiting the number of results. By the end of the book, you will know how to insert and update data, and summarize data with aggregate functions and groups. Three appendices cover differences between SQL dialects, working with tables, and a crash course in PDO. What You Will LearnFilter, sort, andcalculate dataSummarize data with aggregate functionsModify data with insert, uTable of ContentsThe appendix will include: Notes on using SQL with PHP “Cultural Notes” - a description of some of the sample data Major Differences between DBMSs Setting up the Sample Database
£41.24
APress Design and Deploy a Secure Azure Environment
Book SynopsisBeginning-Intermediate user levelTable of ContentsChapter 1: Getting Started with Azure Security o Introduction to Cloud Security o Best practices for securing enterprise cloud o Create an overall security design baseline o Define Security Operations Strategy o Overview of NIST Cybersecurity framework Chapter 2: Design and deploy security for infrastructure, data and apps o Design and deploy a strategy for securing server and client endpoints \ o Design and deploy a strategy for securing SaaS, PaaS, and IaaS services o Design and deploy security for data across Azure enterprise environment o Design and deploy security for application across Azure enterprise environment Chapter 3: Design and deploy Identify solution. o Introduction to Azure identify security services o Design and deploy Azure information protection o Design and deploy Azure network watcher o Design and deploy Azure Policy Chapter 4: Design and deploy Identify solution. o Design and deploy Azure Automation o Design and deploy Azure IoT Hub o Design and deploy Microsoft Intune o Design and deploy Service Map o Enable Security Center Chapter 5: Design and deploy detect solution. o Design and deploy Azure Intelligent Security Graph o Design and deploy Azure monitor o Design and deploy Azure Sentinel Chapter 6: Design and deploy protect solution o Design and deploy Azure Application gateway o Design and deploy Azure Firewall o Design and deploy Azure WAF Chapter 7: Design and deploy protect solution. o Design and deploy Azure AD and AD Identity protection o Design and deploy Azure DDoS o Design and deploy Azure NSG Chapter 8: Design and deploy protect solution. o Design and deploy Azure NSG o Design and deploy Azure Bastion o Design and deploy Azure Encryption Chapter 9: Design and deploy respond solution o Design and deploy Azure Logic Apps o Design and deploy Azure Encryption o Define your security team Chapter 10: Design and deploy recover solution o Design and deploy Azure Backup o Design and deploy Site recovery
£44.99
APress Leveling Up with SQL
Book SynopsisIntermediate-Advanced user levelTable of ContentsChapter 1: Getting Ready.- Chapter 2: Working with Table Design.- Chapter 3: Table Relationships and Working With Joins.- Chapter 4: Working with Calculated Data.- Chapter 5: Aggregating Data.- Chapter 6: Creating and Using Views and Friends.- Chapter 7: Working With Subqueries and Common Table Expressions.- Chapter 8: Working With Window Functions.-Chapter 9: More on Common Table Expressions.- Chapter 10: More Techniques with SQL: Triggers, Pivot Tables, and Variables.- Appendix A.
£33.74
APress Introducing Functional Programming Using C
Book SynopsisIntermediate-Advanced user levelTable of Contents
£33.74
Microsoft Press,U.S. Essential C# 7.0
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
£32.99
Apress Beginning C ObjectOriented Programming
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
£54.99
Apress Practical Azure Application Development
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.
£34.19
APress Beginning Power Apps
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
£44.99
Createspace Independent Publishing Platform An Introduction to Excel for Civil Engineers: From Engineering Theory to Excel Practice
£20.78
APress ADO.NET: From Novice to Pro, Visual Basic .NET Edition
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.
£29.92
APress Code Generation in Microsoft .NET
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.
£47.49
APress Practical Software Factories in .NET
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.
£49.99
Manning Publications Concurrency in .NET: Modern patterns of concurrent and parallel programming
Book SynopsisDescription Functional languages help developers support concurrency by encouraging immutable data structures that can be passed between threads without having to worry about a shared state, all while avoiding side effects. Functional Concurrency in .NET teaches readers how to build concurrent and scalable programs in .NET using the functional paradigm. This intermediate-level guide is aimed at developers, architects, and passionate computer programmers. Key Features • In-depth explanations • Hands-on examples • Step-by-step instructions Audience This book is for readers with solid knowledge of a mainstream programming language, preferably C# or F#. About the technology To maximize the utilization of the computational resources available, the Microsoft .NET platform provides parallel execution of code through multithreading. By leveraging parallelism, a program can take full advantage of the resources available. Riccardo Terrell is a .NET seasoned software engineer, senior software architect and Microsoft MVP who is passionate about functional programming. He is well known and actively involved in the functional programming community including .NET meet ups and conferences and is the organizer for the Washington DC F# User Group. MANNING
£40.79
Universal Publishers Building Mathematical Models in Excel: A Guide for Agriculturists
£34.86
Stanek & Associates Windows PowerShell Fast Start, 3rd Edition: A Quick Start Guide to Windows PowerShell
£13.62
Mercury Learning & Information Access Project Book
Book SynopsisThis is a project book that guides you through the process of building a traditional Access desktop database that uses one Access database as the front-end (queries, reports, and forms) and another Access database that contains all the tables and data. By separating the data from the rest of the database, the Access database can be easily shared by multiple users over a network. When you build a database the correctly at the outset, later this database can be migrated to another system with fewer issues and fewer objects that need to be redone. Features: Understand the concepts of normalization; Build tables and links to other data sources and understand table relationships; Connect and work with data stored in other formats (Text, Word, Excel, Outlook and PowerPoint); Retrieve data with DAO, ADO, and DLookup statements; Learn how to process text files for import and export; Create expressions, queries and SQL statements; Build bound and unbound forms and reports and write code to preview and print; Incorporate macros in your database; Work with attachments and image files; Learn how to display and query your Access data in the Internet browser; Secure your database for multi-user access; Compact your database to prevent corruption resulting in data loss.Table of Contents 1: Planning and Designing a Database 2: Creating a Desktop Database 3: Creating Access Tables 4: Setting Up Primary Keys, Indexes, and Table Relationships 5: Populating Access Tables With Data 6: Creating and Working With Select Queries 7: Performing Database Operations With Action Queries 8: Designing and Using Forms 9: Form Customization 10: Designing and Using Reports 11: Report Customization 12: Compacting, Splitting, and Securing the Database Appendix: Microsoft Access File Formats
£999.99
Packt Publishing Limited Microsoft Identity Manager 2016 Handbook
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.
£55.15
Packt Publishing Limited Web Development with Blazor: A practical guide to start building interactive UIs with C# 11 and .NET 7
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
£58.11
LIGHTNING SOURCE INC Excel 2023
£19.44
Packt Publishing Limited Mastering GitHub Copilot
£36.32
Packt Publishing Limited Blazor Web Development Cookbook
£27.99
Packt Publishing Limited Apps and Services with .NET 10
£41.99
Packt Publishing Limited ASP.NET 9 Core Web API Cookbook
£29.99
Packt Publishing Limited Azure Cloud Projects
£37.99
Packt Publishing The Definitive Guide to Power Query M
£60.79
Packt Publishing Limited Building Industrial Digital Twins: Design, develop, and deploy digital twin solutions for real-world industries using Azure Digital Twins
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
£55.15
Wiley-VCH Verlag GmbH Excel-VBA für Dummies
Book SynopsisUm noch mehr aus Excel herauszuholen, sind Kenntnisse der VBA-Programmierung von großem Vorteil: Dann können Sie Excel auf Ihre Bedürfnisse zuschneiden und langweilige Routinearbeiten automatisieren. Dieses Buch zeigt Ihnen zunächst den Umgang mit dem VBA-Editor und gibt einen Einblick in die wichtigsten Programmiertechniken, wie Sie Fehler beseitigen, Range-Objekte einsetzen und den Programmfluss steuern. Lernen Sie dann die vielfältigen Programmiermöglichkeiten kennen. Alle Beispielprogramme und Arbeitsblätter stehen zum Download zur Verfügung. Sie werden staunen: Mit VBA können Sie sich selbst Dialogboxen, Werkzeugleisten und Menüs schneidern. Und das schon nach kurzer Zeit!Table of ContentsÜber den Autor 9 Einführung 25 Über dieses Buch 25 Konventionen in diesem Buch 26 Makrosicherheit 27 Törichte Annahmen über die Leser 28 Symbole, die in diesem Buch verwendet werden 29 Wie es weitergeht 29 Teil I: Excel VBA – die ersten Schritte 31 Kapitel 1 VBA kennenlernen 33 Die VBA-Grundlagen verstehen 33 Wissen, was mit VBA möglich ist 34 Text einfügen 35 Eine häufig ausgeführte Aufgabe automatisieren 35 Automatisierung wiederholter Operationen 35 Einen benutzerdefinierten Befehl anlegen 35 Eine benutzerdefinierte Schaltfläche erstellen 36 Neue Funktionen für die Arbeitsmappe entwickeln 36 Benutzerdefinierte Add-Ins für Excel erstellen 36 Das meiste aus VBA herausholen 36 Wissen, was VBA am besten kann 36 Erkennen, welche Nachteile die Verwendung von VBA mit sich bringt 37 VBA-Konzepte verstehen 38 Sicherstellen der Excel-Kompatibilität 40 Kapitel 2 Einfache Makros erstellen 41 Die Registerkarte »Entwicklertools« anzeigen 41 Ein Makro erstellen 42 Die Umgebung vorbereiten 42 Ein Makro aufzeichnen 43 Das Makro ausführen 45 Ein Makro im Visual Basic-Editor anzeigen 46 Das Makro abändern 48 Arbeitsmappen speichern, die Makros enthalten 49 Makro-Sicherheit verstehen 50 Teil II: Die Zusammenarbeit von VBA und Excel 53 Kapitel 3 Der Visual Basic-Editor 55 Den Visual Basic-Editor kennenlernen 55 Den VBE aktivieren 55 VBE-Komponenten erforschen 56 Arbeiten im Projekt-Explorer 58 Ein neues VBA-Modul hinzufügen 59 Arbeiten im Codebereich 60 Fenster minimieren und maximieren 60 Die Bestandteile eines Moduls erkunden 61 VBA-Code in ein Modul einfügen 61 Code direkt eingeben 62 Verwendung des Makro-Rekorders 65 VBA-Code kopieren 67 Anpassung des VBE 68 Die Registerkarte »Editor« 68 Die Registerkarte »Editorformat« 70 Die Registerkarte »Allgemein« 71 Die Registerkarte »Verankern« 72 Kapitel 4 Einführung in das Excel-Objektmodell 73 Arbeiten mit dem Excel-Objektmodell 73 Die Objekthierarchie verstehen 74 Auf Objekte verweisen 75 In Objekteigenschaften und Methoden eintauchen 78 Objekteigenschaften festlegen 80 Mit Objektmethoden Aktionen unternehmen 81 Objekte reagieren auf Ereignisse 83 VBA-Ressourcen zu weiterführenden Informationen 83 Das VBA-Hilfesystem verwenden 83 Den Objektkatalog verwenden 84 Automatische Auflistung von Eigenschaften und Methoden 85 Kapitel 5 Sub-und Funktionsprozeduren in VBA 87 Sub-Prozeduren im Vergleich zu Funktionsprozeduren 87 Einen Blick auf Sub-Prozeduren werfen 88 Einen Blick auf Funktionsprozeduren werfen 88 Namen für Sub-Prozeduren und Funktionsprozeduren 89 Sub-Prozeduren ausführen 90 Die Sub-Prozedur direkt ausführen 92 Die Prozedur vom Dialogfeld Makro aus ausführen 92 Ein Makro mithilfe einer Tastenkombination ausführen 93 Die Prozedur über eine Schaltfläche oder eine Form ausführen 94 Die Prozedur von einer anderen Prozedur aus ausführen 96 Die Prozedur vom Direktfenster aus ausführen 97 Funktionsprozeduren ausführen 97 Die Funktionsprozedur aus einer Sub-Prozedur aufrufen 98 Aufruf der Funktion im Direktfenster 98 Aufruf einer Funktion von einer Formel in einer Tabelle aus 99 Kapitel 6 Mit dem Makro-Rekorder arbeiten 103 Grundlagen der Aufzeichnung 103 Vorbereitung auf die Aufzeichnung 105 Zwischen relativem und absolutem Modus wählen 105 Aufzeichnung im absoluten Modus 106 Aufzeichnung im relativen Modus 107 Dem Makro-Rekorder bei der Arbeit zusehen 109 Aufzeichnungsoptionen für Ihr Makro angeben 110 Code aufräumen, den der Makro-Rekorder aufgezeichnet hat 112 Teil III: Programmierkonzepte 115 Kapitel 7 Wichtige Elemente der Sprache VBA 117 Kommentare in Ihrem VBA-Code 117 Variablen, Konstanten und Datentypen 119 Variablen verstehen 119 Was sind die Datentypen in VBA? 121 Variablen deklarieren und ihnen einen Gültigkeitsbereich zuweisen 122 Mit Konstanten arbeiten 127 Vorgefertigte Konstanten verwenden 128 Mit Zeichenfolgen arbeiten 129 Mit Datumswerten arbeiten 130 Zuweisungsbefehle verwenden 131 Beispiele für den Zuweisungsbefehl 131 Das Gleichheitszeichen 132 Hilfreiche Operatoren 132 Arrays 133 Arrays deklarieren 134 Mehrdimensionale Arrays 134 Dynamische Arrays 135 Die Verwendung von Zeilenmarken (Labels) 136 Kapitel 8 Mit Range-Objekten arbeiten 137 Auf »Range«-Objekte verweisen 137 Auf einen Bereich mithilfe von Eigenschaften verweisen 139 Die »Cells«-Eigenschaft 139 Die »Offset«-Eigenschaft 140 Die »Resize«-Eigenschaft 141 Mit Eigenschaften des »Range«-Objekts arbeiten 141 Die »Value«-Eigenschaft 142 Die »Text«-Eigenschaft 143 Die »Count«-Eigenschaft 143 Die »Column«-und die »Row«-Eigenschaft 143 Die »Address«-Eigenschaft 144 Die »HasFormula«-Eigenschaft 144 Die »Font«-Eigenschaft 145 Die »Interior«-Eigenschaft 146 Die »Formula«-Eigenschaft 147 Die »NumberFormat«-Eigenschaft 148 Aktionen mit Methoden des »Range«-Objekts unternehmen 148 Die »Select«-Methode 149 Die Methoden »Copy« und »Paste« 149 Die »Clear«-Methode 150 Die »Delete«-Methode 150 Kapitel 9 VBA-und Arbeitsblattfunktionen 151 Funktionen verstehen 151 Eingebaute VBA-Funktionen verwenden 152 Arbeiten mit Datum und Uhrzeit 152 Arbeiten mit Zeichenfolgen 154 Objekte und Daten identifizieren 155 VBA-Funktionen, die mehr tun, als einen Wert zurückzugeben 156 VBA-Funktionen finden 156 Arbeitsblattfunktionen in VBA verwenden 159 Beispiele für Arbeitsblattfunktionen 160 Eingabe von Arbeitsblattfunktionen 162 Weitere Informationen über die Verwendung von Arbeitsblattfunktionen 163 Benutzerdefinierte Funktionen verwenden 164 Kapitel 10 Steuerung des Programmablaufs und Entscheidungen 165 Schwimmen mit dem Strom 165 Die »GoTo«-Anweisung 166 Entscheidungen, Entscheidungen! 168 Die »If-Then «-Struktur 168 Die »Select Case«-Struktur 172 Ihr Code für eine Schleife 175 »For-Next «-Schleifen 175 »Do While«-Schleifen 180 »Do Until«-Schleifen 181 »For Each-Next «-Schleifen für Collections ausführen 181 Kapitel 11 Automatische Prozeduren und Ereignisse 185 Vorbereitung auf das große Ereignis 185 Lernen, wann Sie Ereignisprozeduren einsetzen 187 Programmierung von Prozeduren zur Ereignisverarbeitung 188 Wissen, wo man den Ereigniscode einfügt 188 Eine Prozedur zur Ereignisverarbeitung schreiben 189 »Workbook«-Ereignisse auslösen 190 Das »Open«-Ereignis für eine Arbeitsmappe 191 Das »BeforeClose«-Ereignis für eine Arbeitsmappe 193 Das »BeforeSave«-Ereignis für eine Arbeitsmappe 194 Aktivierungsereignisse verwenden 195 Aktivierungs-und Deaktivierungsereignisse in einem Arbeitsblatt 195 Aktivierungs-und Deaktivierungsereignisse in einer Arbeitsmappe 196 Arbeitsmappen-Aktivierungsereignisse 197 Programmierung von Arbeitsblattereignissen 198 Das »BeforeDoubleClick«-Ereignis 198 Das »BeforeRightClick«-Ereignis 198 Das »Change«-Ereignis 199 Ereignisse verstehen, die keinen Objekten zugeordnet sind 201 Das »OnTime«-Ereignis 201 Tastenaktionen 203 Kapitel 12 Techniken zur Fehlerverarbeitung 205 Fehlertypen 205 Ein fehlerhaftes Beispielmakro 206 Nicht ganz perfekte Makros 207 Das Makro noch perfekter machen 208 Verabschieden Sie sich von der Perfektion! 209 Alternative Wege der Fehlerverarbeitung 210 Noch einmal die Prozedur »EnterSquareRoot« 210 Fehler mit der »On-Error «-Anweisung abfangen 211 Fehlerverarbeitung: die Details 212 Fortsetzung nach einem Fehler 212 Fehlerverarbeitung im Überblick 214 Ein beabsichtigter Fehler 214 Kapitel 13 Techniken, mit denen Sie Fehler loswerden 217 Verschiedene Fehlerarten 217 Programmierfehler identifizieren 219 Debugging-Techniken 220 Ihren Code überprüfen 220 Die »MsgBox«-Funktion verwenden 220 »Debug.Print«-Anweisungen einfügen 222 Verwendung des VBA-Debuggers 222 Debugging-Tools verwenden 223 Haltepunkte in Ihrem Code setzen 223 Das Überwachungsfenster verwenden 226 Das Lokal-Fenster 228 Tipps, wie Sie weniger Programmierfehler machen 229 Kapitel 14 VBA-Programmierbeispiele 231 Mit Bereichen arbeiten 231 Einen Bereich kopieren 232 Einen variablen Bereich kopieren 233 Auswahl bis zum Ende einer Zeile oder Spalte 235 Eine Zeile oder Spalte auswählen 236 Einen Bereich verschieben 236 Einen Bereich effizient durchlaufen 236 Einen Bereich effizient durchlaufen (Teil II) 238 Einen Zellwert anfordern 239 Den Auswahltyp bestimmen 240 Eine Mehrfachauswahl erkennen 240 Excel-Einstellungen abändern 241 Boolesche Einstellungen ändern 241 Nicht-boolesche Einstellungen ändern 242 Diagramme 242 »AddChart« im Vergleich zu »AddChart2« 243 Den Diagrammtyp ändern 245 Die »ChartObjects«-Collection durchlaufen 245 Diagrammeigenschaften ändern 246 Diagrammformatierungen anwenden 246 VBA-Geschwindigkeitstipps 248 Die Bildschirmaktualisierung abschalten 248 Die automatische Berechnung ausschalten 249 Lästige Warnungen deaktivieren 249 Objektreferenzen vereinfachen 251 Variablentypen deklarieren 251 Die »With-End With«-Struktur 252 Kapitel 15 Einfache Dialogfelder 253 In VBA mit dem Benutzer interagieren 253 Meldungen mit der »MsgBox«-Funktion anzeigen 254 Ein einfaches Meldungsfeld anzeigen 255 Eine Antwort aus einem Meldungsfeld erhalten 256 Meldungsfelder anpassen 257 Daten mit der Funktion »InputBox« abfragen 260 Die Syntax von »InputBox« verstehen 260 Die Funktion »InputBox« verwenden 260 Die Methode »InputBox« verwenden 262 Den Benutzer eine Datei oder einen Ordner auswählen lassen 263 Eine »GetOpenFilename«-Anweisung erstellen 264 Eine Datei mit »GetOpenFilename« auswählen 264 Pfad und Dateinamen mit »GetSaveAsFilename« ermitteln 266 Einen Ordnernamen ermitteln 267 Eingebaute Excel-Dialogfelder anzeigen 267 Teil IV: Kommunikation mit Ihren Benutzern 271 Kapitel 16 UserForm-Grundlagen 273 Erkennen, wann man ein UserForm braucht 273 UserForms erstellen: ein Überblick 275 Mit UserForms arbeiten 276 Ein neues UserForm einfügen 276 Einem UserForm Steuerelemente hinzufügen 277 Die Eigenschaften eines UserForm-Steuerelements ändern 277 Den Codebereich für ein UserForm anzeigen 279 Ein UserForm anzeigen 279 Informationen aus einem UserForm verarbeiten 280 Ein UserForm-Beispiel 280 Das UserForm erstellen 281 Die Befehlsschaltflächen hinzufügen 281 Optionsfelder einfügen 283 Prozeduren zur Ereignisverarbeitung einfügen 284 Ein Makro anlegen, das das Dialogfeld anzeigt 286 Das Makro für den Benutzer bereitstellen 286 Das Makro testen 288 Kapitel 17 UserForm-Steuerelemente verwenden 291 Steuerelemente im Dialogfeld – die ersten Schritte 291 Steuerelemente hinzufügen 292 Eigenschaften von Steuerelementen – Grundlagen 293 Details zu den Steuerelementen in einem Dialogfeld kennenlernen 295 Das »CheckBox«-Steuerelement – Kontrollkästchen 296 Das »ComboBox«-Steuerelement – Kombinationsfeld 296 Das »CommandButton«-Steuerelement – Befehlsschaltfläche 297 Das »Frame«-Steuerelement – Rahmen 298 Das »Image«-Steuerelement (Bildfeld) 298 Das »Label«-Steuerelement (Bezeichnungsfeld) 299 Das »ListBox«-Steuerelement (Listenfeld) 300 Das »MultiPage«-Steuerelement – Multiseiten 301 Das »OptionButton«-Steuerelement – Optionsfelder 302 Das »RefEdit«-Steuerelement 302 Das »ScrollBar«-Steuerelement – Bildlaufleiste 303 Das »SpinButton«-Steuerelement – Drehfeld 304 Das »TabStrip«-Steuerelement – Register 305 Das »TextBox«-Steuerelement – Textfeld 305 Das »ToggleButton«-Steuerelement – Umschaltfeld 306 Die Arbeit mit Steuerelementen in Dialogfeldern 306 Steuerelemente verschieben und ihre Größe ändern 307 Steuerelemente ausrichten und Abstände einhalten 307 Tastaturbenutzern helfen 308 Ein UserForm testen 310 Dialogfeld-Ästhetik 310 Kapitel 18 UserForms – Techniken und Tricks 311 Dialogfelder verwenden 311 Ein UserForm-Beispiel 312 Das Dialogfeld erstellen 312 Code für die Anzeige des Dialogfelds 315 Das Makro bereitstellen 315 Ihr Dialogfeld ausprobieren 316 Prozeduren zur Ereignisverarbeitung einfügen 316 Die Daten auswerten 318 Jetzt funktioniert das Dialogfeld 319 Beispiel für ein Listenfeld-Steuerelement 319 Ein Listenfeld füllen 320 Das ausgewählte Element bestimmen 321 Mehrfachauswahlen bestimmen 322 Einen Bereich auswählen 323 Mehrere Gruppen von Optionsfeldern verwenden 325 Ein Drehfeld und ein Textfeld verwenden 326 Ein UserForm als Fortschrittsanzeige verwenden 328 Ein Dialogfeld als Fortschrittsanzeige einrichten 329 Die Prozeduren 330 Wie dieses Beispiel funktioniert 331 Ein nicht modales Dialogfeld mit Registerkarten erstellen 332 Ein Diagramm in einem UserForm anzeigen 334 Eine Checkliste für Dialogfelder 335 Kapitel 19 Zugriff auf Ihre Makros über die Benutzeroberfläche 337 Das Menüband anpassen 337 Das Menüband manuell anpassen 338 Dem Menüband ein Makro hinzufügen 340 Anpassung des Menübands mit XML 340 Die Excel-Benutzeroberfläche mit VBA anpassen 345 Befehle zur Registerkarte »Add-Ins « des Menübands hinzufügen 346 Dem Kontextmenü »Cell« einen neuen Eintrag hinzufügen 347 Anpassungen automatisch hinzufügen 349 Kontextmenüs und das Single Document Interface verstehen 349 Teil V: Das große Ganze 351 Kapitel 20 Arbeitsblattfunktionen erstellen 353 Vereinfachen Sie mit benutzerdefinierten Funktionen Ihre Arbeit 353 Grundlagen der VBA-Funktionen 354 Funktionen schreiben 355 Mit Funktionsargumenten arbeiten 356 Eine Funktion ohne Argumente 356 Eine Funktion mit einem Argument 357 Eine Funktion mit zwei Argumenten 359 Eine Funktion mit einem Bereichsargument 360 Eine Funktion mit einem optionalen Argument 362 Wrapper-Funktionen 364 Die »NumberFormat«-Funktion 364 Die »ExtractElement«-Funktion 364 Die »SayIt«-Funktion 365 Die »IsLike«-Funktion 366 Funktionen, die ein Array zurückgeben 366 Ein Array mit Monatsnamen zurückgeben 366 Eine sortierte Liste zurückgeben 367 Das Dialogfeld »Funktion einfügen« verwenden 369 Die Funktionsbeschreibung anzeigen 369 Argumentbeschreibungen 371 Kapitel 21 Add-Ins in Excel erstellen 373 Was ist ein Add-In? 373 Gründe für die Erstellung von Add-Ins 374 Die Arbeit mit Add-Ins 375 Add-In-Grundlagen 376 Sehen Sie sich ein Beispiel für ein Add-In an 377 Einrichtung der Arbeitsmappe 377 Die Arbeitsmappe testen 379 Beschreibende Informationen hinzufügen 380 Den VBA-Code schützen 381 Das Add-In anlegen 381 Das Add-In öffnen 382 Das Add-In weitergeben 383 Das Add-In ändern 383 Teil VI: Der Top-Ten-Teil 385 Kapitel 22 Zehn nützliche Tipps für den Visual Basic-Editor 387 Kommentarblöcke verwenden 387 Mehrere Codezeilen kopieren 389 Zwischen Modulen und Prozeduren springen 389 Beamen Sie sich zu Ihren Funktionen 389 In der richtigen Prozedur bleiben 390 Den Code schrittweise ausführen 391 Zu einer bestimmten Codezeile springen 392 Die Codeausführung an einer bestimmten Stelle unterbrechen 392 Den Anfang und das Ende des Variablenwerts anzeigen 393 Die automatische Syntaxüberprüfung ausschalten 394 Kapitel 23 Ressourcen mit Hilfe zu VBA 397 Lassen Sie Excel die Makros für Sie schreiben 397 Nutzen Sie das Hilfesystem 398 Stibitzen Sie Code im Internet 398 Userforen optimal nutzen 399 Besuchen Sie Experten-Blogs 400 Suchen Sie auf YouTube nach Schulungsvideos 400 Nehmen Sie an Onlinekursen teil 401 Vom Office Dev Center lernen 401 Analysieren Sie andere Excel-Dateien in Ihrem Unternehmen 401 Fragen Sie die Excel-Experten vor Ort 402 Kapitel 24 Zehn Dinge, die Sie beherzigen oder vermeiden sollten 403 Deklarieren Sie alle Variablen 403 Verwechseln Sie Passwörter nicht mit Sicherheit 404 Bereinigen Sie Ihren Code 404 Schreiben Sie nicht alles in eine Prozedur 405 Denken Sie daran, dass es noch andere Software gibt 405 Gehen Sie nicht davon aus, dass alle Benutzer Makros aktivieren 405 Gewöhnen Sie sich an, zu experimentieren 405 Gehen Sie nicht davon aus, dass Ihr Code in anderen Excel-Versionen funktioniert 406 Denken Sie immer an Ihre Benutzer 406 Vergessen Sie die Datensicherung nicht! 406 Abbildungsverzeichnis 407 Stichwortverzeichnis 415
£999.99
Wiley-VCH Verlag GmbH Outlook professionell nutzen für Dummies
Book SynopsisEin überquellendes Postfach, zu viele Meetings, nie genügend Zeit? Nutzen Sie Outlook richtig - nicht nur zum Mailen, sondern auch und vor allem zur Organisation Ihrer Kontakte, Termine und Aufgaben. Christine Peyton und Andre Möller zeigen Ihnen, wie Ihnen Outlook hilft, sich zu organisieren, Prioritäten zu setzen und vieles mehr. Planen Sie Besprechungen mit mehreren Teilnehmern und nutzen Sie die Funktionen von Microsoft 365 für die Zusammenarbeit. Halten Sie Ihren Posteingang aufgeräumt, finden Sie Mails und Unterlagen schnell wieder, lassen Sie sich Terminüberschneidungen anzeigen, reservieren Sie Räume und Geräte und archivieren Sie mit System. Beherrschen Sie das Chaos!Table of ContentsÜber die Autoren 9 Einleitung 19 Teil I: Outlook kennenlernen: die Grundlagen 23 Kapitel 1: Outlook als Alleskönner – die Module im Überblick 25 Kapitel 2: Outlook als E- Mail- Programm 33 Kapitel 3: E- Mails mit und ohne Anhang verschicken 65 Kapitel 4: E- Mails mit Pfiff 83 Kapitel 5: Nachrichten empfangen 101 Teil II: Daten verwalten, archivieren und verschlüsseln 139 Kapitel 6: PST- Dateien, mehrere Konten und Mails archivieren 141 Kapitel 7: Sicherheit und Sicherheitsrisiken 161 Teil III: So organisieren Sie Ihren Arbeitsalltag mit Outlook 189 Kapitel 8: Termine in Outlook 191 Kapitel 9: Termine eingeben, bearbeiten und verwalten 213 Kapitel 10: Aufgaben erstellen 265 Kapitel 11: Kontakte managen 281 Kapitel 12: Outlook- Kontakte für den Serienbrief nutzen 305 Kapitel 13: Praktische Gedächtnisstützen – Notizen 319 Kapitel 14: Importieren, exportieren und synchronisieren 325 Kapitel 15: Kollaboration in einer Organisation 357 Teil IV: Top-Ten-Teil 373 Kapitel 16: Zehn Tipps für den geschickten Umgang mit Outlook 375 Abbildungsverzeichnis 385 Stichwortverzeichnis 399
£999.99
My Excel Online 101 Ready To Use Microsoft Excel Macros
£23.99
White Falcon Publishing Solutions Llp You Can Automate Be Among 2 percent Who Can Automate What Other 98 percent Repeat
£29.99
Amazon Digital Services LLC - Kdp Mastering Microsoft 365 Copilot
£12.07
Independently Published Beginner Lessons in .NET GitHub and Codex CLI
£8.06
Independently Published Microsoft Copilot in Azure Mastery
£14.69
Independently Published Azure SQL database mastery
£999.99
Independently Published Professional ASP.NET Core Web Development with .Net 10
£14.19
Independently Published C 14 From Scratch Handbook
£24.10
Independently Published Professional Web Development with .Net 10
£16.39
Independently Published Microsoft Fabric in Action
£16.27
Amazon Digital Services LLC - Kdp TSQL Mastery
£12.60
Amazon Digital Services LLC - Kdp Learn Angular 19 and ASP.NET Core 9
£20.83
Amazon Digital Services LLC - Kdp Angular ASP.NET Mastery
£13.35
Independently Published The Definitive .NET MAUI BIBLE
£20.13
Independently Published Mastering microcontroller serial communication
£999.99
Independently Published Senior .NET Engineering in the AI Era
£16.25
Independently Published Rock Your Code
£22.99
Independently Published Mastering Power Query M
£15.59