Informatyka
Microsoft Access. Przewodnik dla użytkowników Excela
Michael Alexander
Rozszerz swój wachlarz narzędzi do analizy o Accessa! Kiedy wybrać Excela, a kiedy Accessa? Jak wykonać raport i wizualizować dane w Accessie? Jak zintegrować Excel z Accessem? Excel to obok Worda najpopularniejsze narzędzie znajdujące się w pakiecie Microsoft Office. Narzędzie, bez którego nie wyobrażają sobie pracy analitycy, księgowi i prezesi firm. Dzięki ogromnym możliwościom oraz łatwości użycia znajduje on zastosowanie wszędzie tam, gdzie trzeba dokonać obliczeń na dużych ilościach danych. Czy Excel jest jednak lekarstwem na wszystko? Otóż nie! Pakiet Microsoft Office posiada w swych szeregach jeszcze jednego asa - program Access. Jeżeli zależy Ci na bezproblemowej współpracy kilku osób nad jednym zbiorem danych, jeżeli chcesz oddzielić wygląd raportu od danych, a w dodatku wymagasz skalowalności, Access może okazać się lepszym wyborem. Nie obawiaj się nowego! Dzięki tej książce błyskawicznie zapoznasz się ze środowiskiem, filozofią pracy oraz możliwościami Accessa. Książka odpowiada na wiele pytań, w tym na jedno kluczowe - kiedy lepszy jest Excel, a kiedy Access. Ponadto znajdziesz tu odpowiedzi na pytania dotyczące danych, ich struktur oraz metod analizy. Dowiesz się, jak korzystać z kwerend agregujących, funkcjonalnych oraz krzyżowych. Z pewnością zainteresują Cię również rozdziały poświęcone analizom warunkowym oraz tworzeniu raportów i wizualizacji danych w programie Access. Ostatni rozdział pozwoli Ci połączyć świat, który znasz - świat Excela, z tym, który poznałeś w trakcie lektury - światem Accessa. Integracja tych dwóch narzędzi zdejmie z Ciebie wszelkie ograniczenia w codziennej pracy z danymi o dowolnej wielkości i złożoności. Przekonaj się o tym sam! Trudny wybór - Access czy Excel Podstawy Accessa - tabele, teoria relacyjnych baz danych, kwerendy Kwerendy wybierające, funkcjonalne, usuwające, aktualizujące Wykorzystanie kwerend krzyżowych Transformacja danych za pomocą programu Access Wykonywanie obliczeń oraz przetwarzanie dat Analizy warunkowe Zastosowanie podkwerend i domenowych funkcji agregacji Statystyki opisowe w Accessie Planowanie zadań Wykorzystanie VBA do usprawnienia procesu analizy Tworzenie raportów w Accessie Wykorzystanie tabel i wykresów przestawnych Przenoszenie danych z Accessa do Excela Integracja Accessa z Excelem Tworzenie zapytań SQL Znasz Excel? Poznaj też Access - szybko i przyjemnie!
Bogdan Brinzarea, Cristian Darie
Microsoft AJAX Library Essentials is a practical reference for the client-side library of the ASP.NET AJAX Framework 1.0, and a tutorial for the underlying technologies and techniques required to use the library at its full potential. The main goal of this book is to get you comfortable with the Microsoft AJAX Library, a huge set of functions that can be used for developing powerful client-side functionality.Beginning with a hands-on tour of the basic technologies associated with AJAX, JavaScript, XMLHttpRequest, JSON, and the DOM, you'll move on to a crash course in the Microsoft AJAX tools. You will learn, through numerous step-by-step exercises, how to create basic AJAX applications, how the object-based programming model of JavaScript works, and how Microsoft AJAX Library extends this model. You'll understand the architecture of the Microsoft AJAX components, how they all fit together, and exactly what they can do for you. Then you will learn how to use the Microsoft AJAX Library in your web projects, and a detailed case study will walk you through creating your own customized client components. At every stage of your journey, you'll be able to try out examples to illuminate the theory, and consolidate your understanding. In addition to learning about the client and server controls, you'll also see how to handle errors and debug your AJAX applications.To complement your new found skills, the book ends with a visual reference of the Microsoft AJAX Library namespaces and classes, including diagrams and quick explanations for all the classes mentioned in the book, providing an invaluable reference you will turn to again and again.
Aaron Guilmette, Steve Miles, Peter De Tender
The AI-900 exam helps you take your first step into an AI-shaped future. Regardless of your technical background, this book will help you test your understanding of the key AI-related topics and tools used to develop AI solutions in Azure cloud.This exam guide focuses on AI workloads, including natural language processing (NLP) and large language models (LLMs). You’ll explore Microsoft’s responsible AI principles like safety and accountability. Then, you’ll cover the basics of machine learning (ML), including classification and deep learning, and learn how to use training and validation datasets with Azure ML. Using Azure AI Vision, face detection, and Video Indexer services, you’ll get up to speed with computer vision-related topics like image classification, object detection, and facial detection. Later chapters cover NLP features such as key phrase extraction, sentiment analysis, and speech processing using Azure AI Language, speech, and translator services. The book also guides you through identifying GenAI models and leveraging Azure OpenAI Service for content generation. At the end of each chapter, you’ll find chapter review questions with answers, provided as an online resource.By the end of this exam guide, you’ll be able to work with AI solutions in Azure and pass the AI-900 exam using the online exam prep resources.
Richard J. Dudley, Nathan A. Duchene, Richard...
Microsoft's Azure platform has proved itself to be a highly scalable and highly available platform for enterprise applications. Despite a familiar development model, there is a difference between developing for Azure and moving applications and data into the cloud. You need to be aware of how to technically implement large-scale elastic applications. In this book, the authors develop an Azure application and discuss architectural considerations and important decision points for hosting an application on Azure.This book is a fast-paced introduction to all the major features of Azure, with considerations for enterprise developers. It starts with an overview of cloud computing in general, followed by an overview of Microsoft's Azure platform, and covers Windows Azure, SQL Azure, and AppFabric, discussing them with the help of a case-study.The book guides you through setting up the tools needed for Azure development, and outlines the sample application that will be built in the later chapters. Each subsequent chapter focuses on one aspect of the Azure platform—web roles, queue storage, SQL Azure, and so on—discussing the feature in greater detail and then providing a programming example by building parts of the sample application. Important architectural and security considerations are discussed with each Azure feature.The authors cover topics that are important to enterprise development, such as transferring data from an on-premises database to SQL Azure using SSIS, securing an application using AppFabric access control, blob and table storage, and asynchronous messaging using Queue Storage. Readers will learn to leverage the use of queues and worker roles for the separation of responsibilities between web and worker roles, enabling linear scale out of an Azure application through the use of additional instances. A truly elastic application is one that can be scaled up or down quickly to match resources to demand as well as control costs; with the practices in this book you will achieve application elasticity.
Steve Miles, Peter De Tender
Microsoft Azure Fundamentals Certification and Beyond, Third Edition, is a complete and up-to-date guide aligned with the January 2026 AZ-900 skills-measured update. It combines clear explanations of Azure fundamentals with practical, real-world insights that help you understand not only what Azure services are, but how and why they are used.This book covers cloud concepts, Azure architecture, core services, security, governance, cost management, deployment, and monitoring making it ideal for beginners and career switchers. Beyond exam preparation, it introduces real-world Azure scenarios and multi-cloud awareness, helping you see how Azure fits into modern IT environments.To reinforce learning, the book includes access to Packt’s interactive online platform with mock exams, practice tests, flashcards, exam timers, and hands-on labs. By the end, you’ll have a strong foundation in Azure fundamentals, confidence in tackling the AZ-900 exam, and practical knowledge to take your first steps into cloud-focused roles.
Microsoft Azure SQL Database Krok po kroku
Leonard Lobel, Eric D. Boyd
Praktyczny przewodnik po podstawach SQL Database Rozszerz swoje umiejętności i samodzielnie poznaj podstawy platformy Microsoft Azure SQL Database. Jeśli jesteś doświadczonym projektantem oprogramowania lub specjalistą od baz danych, ale nowicjuszem w dziedzinie chmury Microsoft Azure lub SQL Database, znajdziesz tu wskazówki, ćwiczenia i przykłady kodu potrzebne do opanowania podstawowych zagadnień i technik. Dowiedz się, jak: - Szybko uruchomić serwer i bazę danych w chmurze - Zaprojektować, wypełnić danymi i odpytywać bazę danych - Tworzyć i zarządzać serwerami, regułami zapory i bazami danych - Opanować narzędzia i techniki potrzebne do migrowania danych - Sprawdzać i konfigurować ustawienia zabezpieczeń, kopii zapasowych i przywracania po awariach - Skonfigurować SSRS i raportowanie na maszynie wirtualnej w chmurze Microsoft - Zautomatyzować replikację danych i zadania zarządzania - Budować wielowarstwowe rozwiązania w chmurze - Monitorować i dostrajać wydajność O autorach Leonard G. Lobel, Microsoft MVP w dziedzinie SQL Server, jest głównym konsultantem w firmie Tallan, Inc., Microsoft National Systems Integrator and Gold Competency Partner, i jednym z wiodących ekspertów branżowych w zakresie .NET i SQL Server. Eric D. Boyd, MVP w dziedzinie Microsoft Azure, jest założycielem i dyrektorem generalnym responsiveX, firmy konsultingowej skupiającej się na aplikacjach i usługach w chmurze. Jest częstym wykładowcą na konferencjach branżowych, regionalnych i w lokalnych grupach użytkowników. Pliki ćwiczeń i przykłady dostępne pod adresem https://aka.ms/AzureSQLDB_SBS
Kent Weare, Richard Seroter
Microsoft BizTalk is an integration and connectivity server solution that allows businesses to connect disparate systems easily. In today’s business climate of mergers and acquisitions, more and more enterprises are forced to exchange data across disparate Line of Business systems using integration brokers like BizTalk Server 2010. What is often overlooked when integrating these systems is the pre-requisite knowledge that ERP and CRM systems demand in order to effectively integrate them. No longer is this knowledge locked up in the heads of expensive consultants. Gain an edge within your organization by developing valuable skills in the area of Line of Business integration from this book.This book will show you how to integrate BizTalk with Line of Business systems using practical scenarios. Each chapter will take a Line of Business system, introduce some pre-requisite knowledge and demonstrate how you can integrate BizTalk with that Line of Business system, and then provide guidance based upon real world experience, taking your BizTalk knowledge further.This book will enable you to master how to integrate BizTalk with Line of Business systems effectively. The book starts by highlighting the technical foundation of WCF-LOB adapters and the common steps and important properties pertaining to popular WCF-LOB adapters. You will then move on to an overview of how to integrate with Microsoft SQL Server using the WCF based SQL Server adapter. The book then dives into topics such as integrating BizTalk Server with Microsoft Dynamics CRM, building BizTalk/SAP integrated solutions using IDocs, the differences between IDocs and RFCs/BAPIs, and integrating BizTalk with Windows Azure AppFabric Service Bus amongst others.
Andres Del R-o Benito, Howard Edidin
An Enterprise Service Bus (ESB) is an architectural pattern and a key enabler in implementing the infrastructure for a service-oriented architecture (SOA). The BizTalk ESB Toolkit is a collection of tools and libraries that extend the BizTalk Server capabilities of supporting a loosely coupled and dynamic messaging architecture. It functions as middleware that provides tools for rapid mediation between services and their consumers. Enabling maximum flexibility at runtime, the BizTalk ESB Toolkit simplifies loosely coupled composition of service endpoints and management of service interactions. The thing about the technology that gets most readers excited is how easy it is to quickly implement flexible and well-architected ESB solutions.Microsoft BizTalk Server 2010 ESB Toolkit 2.1 provides you with an easy-to-follow view of the tools and services that make up the toolkit. The content is packed with practical examples on how to utilize the technology, which will be appealing to the readers. This book provides you with all the information you need in one publication. The content is based on practical examples on how to use the technology to make it easier for readers to follow.This book starts off with a quick, high level introduction to ESB architectural principles, how these principles map into the ESB toolkit features, and an introduction to the different components that provide those features. The book then reveals the ins and outs of Itineraries. Next, you'll get engaged in the different ways errors can be handled and monitored by means of the ESB Toolkit features. There will be a hands-on sample on building a custom Repair and Resubmit solution to reprocess failed messages. Get to know the different web services that expose the ESB Toolkit features to external applications and how to use them with quick samples. The book ends with a preview to the new version of the toolkit.
Dan Rosanova
Patterns and practices make or break any middleware or integration solution and are especially important with BizTalk Server 2010. Learning the best patterns to use in the appropriate context greatly increases the chances of success for any solution.Microsoft Biztalk server 2010 patterns will provide a thorough introduction to BizTalk Server 2010 as a platform and guide the reader through real world lessons and examples building an advanced unified solution that can be used as a reference architecture.This book will guide you beyond the basics of BizTalk Server 2010 development and give you the relevant background, theory, and techniques necessary to create successful solutions. You will learn how the BizTalk Server 2010 platform works internally and how to plan for the necessary infrastructure for an installation. You will learn how to build messaging-based solutions including content-based routing that are easy to manage and change. You will learn how to solve common integration and middleware challenges by leveraging the strengths of BizTalk Server 2010. This book addresses using Microsoft BizTalk Server 2010 and associated tools to create middleware and integration solutions with established patterns and practices that increase the effectiveness and impact of your solutions.
Steve Miles
Microsoft's Azure Data Fundamentals (DP-900) certification exam validates your expertise in core data concepts and Azure’s powerful data services capabilities. This comprehensive guide written by Steve Miles—a Microsoft Azure MVP and certified trainer with over 25 years of experience in cloud data services and 30+ certifications across major platforms—serves as your gateway to a future shaped by data and AI, regardless of your technical background.With the help of examples, you'll learn fundamental data concepts, including data representation, data storage options, and common workloads and gain clarity on the roles and responsibilities of key data professionals such as data administrators, engineers, and analysts. This guide covers all crucial exam domains, from data services capabilities of the Azure cloud platform to considerations for relational, non-relational, and analytics workloads, encompassing both Microsoft and open-source technologies.To supplement your exam prep, this book gives you access to a suite of online resources designed to boost your confidence, including mock tests, interactive flashcards, and invaluable exam tipsBy the end of this book, you’ll be fully prepared not only to pass the DP-900 exam but also to confidently tackle data solutions in Azure, setting a strong foundation for your data-driven career
Marcelo Leite
Passing the DP-900 Microsoft Azure Data Fundamentals exam opens the door to a myriad of opportunities for working with data services in the cloud. But it is not an easy exam and you'll need a guide to set you up for success and prepare you for a career in Microsoft Azure.Absolutely everything you need to pass the DP-900 exam is covered in this concise handbook. After an introductory chapter covering the core terms and concepts, you'll go through the various roles related to working with data in the cloud and learn the similarities and differences between relational and non-relational databases. This foundational knowledge is crucial, as you'll learn how to provision and deploy Azure's relational and non-relational services in detail later in the book. You'll also gain an understanding of how to glean insights with data analytics at both small and large scales, and how to visualize your insights with Power BI. Once you reach the end of the book, you'll be able to test your knowledge with practice tests with detailed explanations of the correct answers.By the end of this book, you will be armed with the knowledge and confidence to not only pass the DP-900 exam but also have a solid foundation from which to embark on a career in Azure data services.
Dmitry Shargorodsky
If there is one hot topic being discussed in every boardroom meeting today, it’s AI. With Microsoft Dynamics 365 AI proving to be a game-changer, it’s essential for business professionals to master this tool. Microsoft Dynamics 365 AI for Business Insights will help you harness AI across key business functions to streamline processes and enhance customer experiences.Written by a seasoned professional with 15+ years of experience, this book guides you through Dynamics 365 AI’s practical applications across sales, customer service, marketing, and finance departments. You'll learn how to enhance customer experiences, streamline sales processes, optimize marketing strategies, and improve financial forecasting. This book also explores the integration of generative AI tools such as OpenAI Service, Azure Open AI, language models, and Microsoft Copilot within the Dynamics 365 ecosystem. With real-world examples, case studies, and expert insights, you’ll discover the transformative potential of this powerful toolkit. As well as driving sales insights and implementing fraud protection, you’ll explore emerging AI trends, Microsoft's roadmap for Dynamics 365 AI, and the upcoming features.By the end, you’ll be all set to unlock new growth opportunities using Dynamics 365 AI.
Rami Mounla
Microsoft Dynamics 365 is a powerful tool. It has many unique features that empower organisations to bridge common business challenges and technology pitfalls that would usually hinder the adoption of a CRM solution. This book sets out to enable you to harness the power of Dynamics 365 and cater to your unique circumstances.We start this book with a no-code configuration chapter and explain the schema, fields, and forms modeling techniques. We then move on to server-side and client-side custom code extensions. Next, you will see how best to integrate Dynamics 365 in a DevOps pipeline to package and deploy your extensions to the various SDLC environments. This book also covers modern libraries and integration patterns that can be used with Dynamics 365 (Angular, 3 tiers, and many others). Finally, we end by highlighting some of the powerful extensions available.Throughout we explain a range of design patterns and techniques that can be used to enhance your code quality; the aim is that you will learn to write enterprise-scale quality code.
Marco Carvalho
Microsoft Dynamics AX 2009 is an advanced Enterprise Resource Planning system, essentially a comprehensive business management solution, designed for midsize and large organizations. Dynamics AX provides a centralized source for business data and enables you to consolidate and standardize your business processes, helping to improve productivity and provide visibility across your organization, for a variety of business needs.This book will enable you to successfully set up and configure Dynamics AX 2009 in your business with clear, practical, step-by-step demonstrations. You will learn how to plan and implement Dynamics AX 2009 efficiently, how to manage the Enterprise Portal, Role Centers, Kerberos Authentication, Workflow, Application Integration Framework (AIF), and much more!Each chapter of the book explores the different aspects of administring and configuring Dynamics AX 2009 to fit any company's needs.The book begins by introducing you to the important process of planning and implementing Dynamics AX 2009, providing the basic components to get you started with your Dynamics AX environment. It then dives deep into the installation of the multi component server of Dynamics AX and how to get it up and running efficiently, specifically the Base Server Components, Enterprise Portal, Role Centers, Kerberos Authentication, Workflow, and the Application Integration Framework (AIF).Other content includes the process of importing data into your Dynamics AX 2009 instance, common user administration functions, and Alerts and Notifications.Finally, the book considers how to enhance your Dynamics AX environment after it has been installed and it is being utilized, from tuning your system to work more efficiently to backing up and maintaining Dynamics AX to make sure you are prepared for worst-case scenarios, enabling you to keep Dynamics AX 2009 functioning at its best.By following the clear and practical steps found in the book, you will successfully master how to administer and configure Dynamics AX 2009 into your company.
Mindaugas Pocius
Microsoft Dynamics AX provides a comprehensive Enterprise Resource Planning (ERP) solution for mid-size and larger organizations. Dynamics AX implementations are used worldwide by thousands of customers. With the new version - Dynamics AX 2009 - the system is due to expand even more rapidly.Every new implementation requires some level of customization, and all organizations want this to be done to the highest standards using proven approaches. This step-by-step guide will help you manage your company's ERP information and operations efficiently, and solve your business process problems in an effective and quick way. This book focuses on commonly used custom modifications in major Dynamics AX modules. This book contains commonly used bits of code which were real-world tested in at least one successful Dynamics AX implementation. Many of the recipes were deployed in many implementations and even across several versions of Dynamics AX. The examples in this book cover various areas of Dynamics AX to help developers not only learn about programming, but also about the functional side of Dynamics AX. The book should help developers who already know the basics of Dynamics AX programming to step up to the next level.The recipes allow you to look at the development from the perspective of business processes. You will learn to enhance your user interface using various Dynamics AX UI elements. Managing your data and functions will become easier. You will also get numerous development tips and tricks from a Dynamics AX development expert.