Wydawca: 16
Microsoft Access 2021 Programming Pocket Primer. A Comprehensive Guide to Mastering Access VBA
Mercury Learning and Information, Julitta Korol
This book, part of the successful Pocket Primer series, is designed for those who need to master Access programming fundamentals quickly. You only need this concise guide to get started and feel comfortable with VBA. The concepts learned here also apply to Excel programming. The book is divided into nine chapters, each progressively introducing you to programming in Microsoft Access 2021.Beginning with an introduction to Access VBA, the book covers the Visual Basic Editor, fundamental VBA programming concepts, and how to create both built-in and custom functions. You will learn to add decision-making capabilities and repeating actions to your programs, manage multiple values using arrays and collections, and utilize built-in tools for testing and debugging your code.This structured approach ensures that by the end of the course, you will have a solid foundation in Access programming. The companion files provide all the hands-on resources needed to complete chapter projects, making this an essential resource for mastering Access VBA efficiently and effectively.
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!
Cristian Darie, Bogdan Brinzarea
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.
Augusto Alvarez
Microsoft's Application Virtualization technology has been emerging as one of the main platforms in application virtualization. This is mainly because more and more organizations are thinking about application virtualization as a valid implementation; also because App-V represents probably the most attractive solution. App-V introduces a new and efficient way to improve operating systems and application life cycles in organizations. However, if we want to maximize our investment we must learn that every scenario and application differs from another, as does complexity.With Microsoft Application Virtualization Advanced Guide administrators will find detailed topics for understanding App-V components, architecture and implementation models; as well as step-by-step guidance to master App-V processes. There is also guidance on integrating App-V with other robust platforms like VDI, SCCM 2012 and even virtualizing server applications. Microsoft Application Virtualization Advanced Guide will start by giving readers the means to discover unfamiliar topics in App-V, as well as understanding App-V's architecture. By doing so, it will provide the baseline needed before shifting to advanced topics in App-V, like complex scenarios for sequencing and deploying applications. The book details scripting within App-V, as well as handling the platform using the command line; there is a complete review of troubleshooting installations, sequencing and deploying applications. Integration is another key component we will cover by introducing App-V in VDI and SCCM 2012. Server applications are not forgotten with Server App-V, using this book the reader will have a detailed understanding, with how-to steps to virtualize server applications.
James Henry F Preston, James Preston
Sjoukje Zaal
Microsoft Azure Administrator – Exam Guide AZ-103 will cover all the exam objectives that will help you achieve Microsoft Azure Administrator certification. Whether you want to pass the AZ-103 exam or simply want hands-on experience in administering Azure, this study guide will help you achieve your goal. It covers the latest features and capabilities related to configuring, managing, and securing Azure resources. Following Microsoft's AZ-103 exam syllabus, this guide is divided into five modules. The first module helps you understand how to manage Azure subscriptions and resources. You will be able to configure Azure subscription policies at Azure subscription level and even learn how to use Azure policies for resource groups. Later, the book covers techniques related to implementing and managing storage in Azure. You will be able to create and configure backup policies and perform restore operations. The next module will guide you through creating, configuring, and deploying virtual machines for Windows and Linux. In the last two modules, you will learn about configuring and monitoring virtual networks and managing identities. The book concludes with effective mock tests, along with answers to them to help you confidently pass the exam.By the end of this book, you will have developed the skills you need to pass Exam AZ-103 and gain the corresponding certification.
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.
Sjoukje Zaal
From designing solutions on Azure to configuring and managing virtual networks, AZ-300 certification can help you achieve all this and more. Whether you want to get certified or gain hands-on experience in administering, developing, and architecting Azure solutions, this study guide will help you get started. The book features not only the different exam objectives, but also guides you through configuring, managing, securing, and architecting Azure resources.Divided into five modules, this book will systematically take you through the different concepts and features as you advance through the sections. The first module demonstrates how to deploy and configure infrastructure. You will cover techniques related to implementing workloads and security, before learning how to create and deploy apps in the next module. To build on your knowledge, the final two modules will get you up to speed with implementing authentication, data security, and application and platform monitoring, along with covering Azure storage, alerting, and automation strategies. Finally, you’ll work through exam-based mock tests with answers to boost your confidence in passing the exam.By the end of this book, you’ll have learned the concepts and techniques you need to know in order to prepare for the AZ-300 exam, along with the skills to design effective solutions on Microsoft Azure.