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.

XML Basics. A Comprehensive Guide to Understanding and Implementing XML

Mercury Learning and Information, S. Banzal

This book focuses on essential XML standards relevant to almost all developers. It investigates XML technologies applicable across a wide range of applications, rather than those limited to specific domains. While XML is a markup language, it is widely used by programmers. The book also covers supporting technologies layered on top of XML, such as XLinks, XSLT, Namespaces, Schemas, XHTML, RDDL, XPointers, XPath, SAX, and DOM.The journey begins with understanding XML and its syntax. It then explores Document Type Definitions (DTDs), Namespaces, and XHTML. Following this, the book delves into CSS Style Sheets, XML Schema Basics, XSL and XSLT, SOAP, DOM Programming Interface, SAX, XPath, XLink, XQuery, XPointer, XForms, XSL-FO, and using XML with Databases. The final chapters cover Web Services, providing a comprehensive understanding of how XML integrates into various applications.Mastering these standards and technologies is crucial for developers working with XML. This book transitions readers from basic XML syntax to advanced applications, blending theoretical concepts with practical examples. It is an essential resource for developers looking to leverage XML in their projects.

Excel Basics. Mastering Excel Foundation and Spreadsheets Efficiently through Formulas & Graphs

Mercury Learning and Information, Jeffrey Hsu, Gary Bronson

This book is designed for first-time or beginning Excel users, providing a comprehensive yet accessible introduction to mastering Microsoft Excel 2019 and previous versions. Starting with the basics, it guides readers through the foundational concepts and features of Excel, ensuring a solid understanding of this essential software. Key topics include an overview of Excel, formulas, functions, formatting, conditional features, graphs, charts, pivot tables, and using a spreadsheet as a database.The book is richly illustrated with screenshots, examples, applications, and exercises to reinforce learning. Suitable for professional reference, self-study, or instructor-led courses, it equips readers with the skills to enhance business and personal productivity. The content is structured to build from basic to advanced topics, making it a valuable resource for users at any stage of learning.With additional resources like tutorial videos, PowerPoint slides, sample syllabi, tests, and quizzes, this book ensures a thorough and engaging learning experience. By the end of the course, users will be proficient in Excel, capable of leveraging its full potential to streamline tasks and improve efficiency.

Data Literacy With Python. A Comprehensive Guide to Understanding and Analyzing Data with Python

Mercury Learning and Information, Oswald Campesato

This book ushers readers into the world of data, emphasizing its importance in modern industries and how its management leads to insightful decision-making. Using Python 3, the book introduces foundational data tasks and progresses to advanced model training concepts. Detailed, step-by-step Python examples help readers master training models, starting with the kNN algorithm and moving to other classifiers with minimal code adjustments. Tools like Sweetviz, Skimpy, Matplotlib, and Seaborn are introduced for hands-on chart and graph rendering.The course begins with working with data, detecting outliers and anomalies, and cleaning datasets. It then introduces statistics and progresses to using Matplotlib and Seaborn for data visualization. Each chapter builds on the previous one, ensuring a comprehensive understanding of data management and analysis.These concepts are crucial for making data-driven decisions. This book transitions readers from basic data handling to advanced model training, blending theoretical knowledge with practical skills. Companion files with source code and data sets enhance the learning experience, making this book an invaluable resource for mastering data science with Python.

Advanced Excel 365. Master Excel 365 with practical tips and advanced AI integrations

Mercury Learning and Information, Ritu Arora

Excel is more than a spreadsheet—it's a powerhouse for data analysis, decision-making, and business productivity. This course begins with foundational concepts, such as cell referencing, formulas, and functions, before moving into tools like data validation, pivot tables, and conditional formatting. You'll also explore advanced techniques for working across multiple worksheets and creating impactful charts.The journey continues with in-depth coverage of VBA programming, where you'll learn to automate repetitive tasks, debug errors, and create user-friendly applications. Starting with the basics of macros and variables, you'll advance to building custom add-ins and employing sophisticated VBA techniques to handle complex data processes seamlessly. Each lesson combines practical examples with actionable insights.By the end of the course, you'll possess a versatile toolkit to handle everything from daily spreadsheet tasks to creating powerful custom solutions. Whether you're preparing reports, analyzing trends, or developing VBA-driven applications, this course equips you to work smarter and achieve more.

Understanding PTSD. Exploring Trauma, Myths, Assessment, and Recovery

Mercury Learning and Information, Austin Mardon

Understanding PTSD offers a comprehensive exploration of Post-Traumatic Stress Disorder (PTSD), tracing its history, debunking common myths, and examining its complex nature. The book begins with a personal narrative to ground the reader, before delving into the origins and evolution of PTSD, particularly during wartime. It addresses widespread misconceptions, emphasizing that PTSD affects diverse populations, not just soldiers. The assessment methods and criteria are discussed, alongside the brain's response to various traumas.Key chapters explore the potential causes of PTSD, including genetic, environmental, and psychological factors. The book also covers the dangers associated with PTSD, various types of PTSD, and symptoms. It provides insights into how PTSD manifests in different age groups and reviews the most effective treatments, such as cognitive therapy and medication.Further chapters discuss comorbidities like depression and substance abuse, the gaps in current knowledge, and ongoing research. The public's perception of PTSD, its portrayal in the media, and the impact on families are also examined. The book concludes with practical advice on supporting individuals with PTSD and a detailed directory of resources available in North America, Europe, and India.

Newtonian Mechanics. Exploring the Principles of Classical Physics from Fundamentals to Advanced Applications

Mercury Learning and Information, Derek Raine

Newtonian mechanics is fundamental in physics education due to its intellectual significance, diverse applications, and its role in teaching modeling and problem-solving. This text covers both introductory and advanced topics, making it suitable for extended study. Emphasizing problem-solving, it guides readers through the process of constructing models and finding solutions, thus enhancing their analytical skills.Starting with mechanical models and forces, the course progresses through kinematics, energy, and motion, providing a solid foundation. Further chapters delve into momentum, orbital motion, and oscillations, offering insights into dynamic systems. Advanced topics like rigid bodies, stability of motion, and Lagrangian and Hamiltonian mechanics ensure a comprehensive understanding.The journey through this course equips learners with the skills to approach complex problems, construct effective models, and develop robust solutions, making it invaluable for students aiming to excel in physics and related fields.

Python 3 Data Visualization Using Google Gemini. Unlock the Power of Python and Google Gemini for Stunning Data Visualizations

Mercury Learning and Information, Oswald Campesato

This book teaches Python 3 programming and data visualization, exploring cutting-edge techniques with ChatGPT/GPT-4 for generating compelling visuals. It starts with Python essentials, covering basic data types, loops, functions, and advanced constructs like dictionaries and matrices. The journey progresses to NumPy's array operations and data visualization using libraries such as Matplotlib and Seaborn. The book also covers tools like SVG graphics and D3 for dynamic visualizations.The course begins with foundational Python concepts, moves into NumPy and data visualization with Pandas, Matplotlib, and Seaborn. Advanced chapters explore ChatGPT and GPT-4, demonstrating their use in creating data visualizations from datasets like the Titanic. Each chapter builds on the previous one, ensuring a comprehensive understanding of Python and visualization techniques.These concepts are crucial for Python practitioners, data scientists, and anyone in data analytics. This book transitions readers from basic Python programming to advanced data visualization, blending theoretical knowledge with practical skills. Companion files with code, datasets, and figures enhance learning, making this an essential resource for mastering Python and data visualization.

Data Science for IoT Engineers. Master Data Science Techniques and Machine Learning Applications for Innovative IoT Solutions

Mercury Learning and Information, P. G. Madhavan

This book introduces data science to professionals in engineering, physics, mathematics, and related fields. It serves as a workbook with MATLAB code, linking subject knowledge to data science, machine learning, and analytics, with applications in IoT. Part One integrates machine learning, systems theory, linear algebra, digital signal processing, and probability theory. Part Two develops a nonlinear, time-varying machine learning solution for modeling real-life business problems.Understanding data science is crucial for modern applications, particularly in IoT. This book presents a dynamic machine learning solution to handle these complexities. Topics include machine learning, systems theory, linear algebra, digital signal processing, probability theory, state-space formulation, Bayesian estimation, Kalman filter, causality, and digital twins.The journey begins with data science and machine learning, covering systems theory and linear algebra. Advanced concepts like the Kalman filter and Bayesian estimation lead to developing a dynamic machine learning model. The book ends with practical applications using digital twins.

Adobe InDesign. Creative Class for Beginners

Mercury Learning and Information, Lauren Saalmuller, Stephanie Torta

This book explores digital design, tailored for beginners eager to master Adobe InDesign, and serves as a valuable resource for experienced users refining their skills. It demystifies Adobe InDesign, defining essential tools through engaging projects and tutorials. Starting with navigating the interface, it lays a solid foundation by teaching how to open and create documents, understand the workspace, and tailor the program to individual needs.The book offers practical experience with projects such as web banners, social media ads, logos, flyers, posters, covers, newsletters, and booklets. Each project builds on the previous one, ensuring a comprehensive understanding of InDesign's capabilities. A complete “Save the Sharks” marketing campaign allows users to apply their skills in a real-world context, with options to customize content for personal campaigns.Understanding Adobe InDesign is crucial for creating professional-quality designs. This book transitions users from novices to confident designers, equipped with practical skills and comprehensive knowledge. It ensures a smooth learning journey, enhancing creative potential and proficiency in digital design. Companion files with video tutorials and project files enrich the learning experience, making it an essential resource for all levels.

Data Structures and Program Design Using C++. A Self-Teaching Introduction to Data Structures and C++

Mercury Learning and Information, D. Malhotra, N. Malhotra

This book introduces the fundamentals of data structures using C++ in a self-teaching format. It covers managing large amounts of information, SEO, and creating Internet/Web indexing services. Practical analogies with real-world applications help explain technical concepts. The book includes end-of-chapter exercises such as programming tasks, theoretical questions, and multiple-choice quizzes.The course starts with an introduction to data structures and the C++ language, progressing through arrays, linked lists, queues, searching and sorting, stacks, trees, multi-way search trees, hashing, files, and graphs. Each chapter builds on the previous one, ensuring a comprehensive understanding of data structures.Understanding these concepts is crucial for managing large databases and optimizing web services. This book guides readers from basic to advanced data structure techniques, blending theoretical knowledge with practical skills. Companion files with source code and data sets enhance the learning experience, making this book an essential resource for mastering data structures with C++.

Data Wrangling Using Pandas, SQL, and Java. A Comprehensive Guide to Data Cleaning and Transformation

Mercury Learning and Information, Oswald Campesato

This book is designed for aspiring data scientists and those involved in data cleaning. It covers features of NumPy and Pandas, along with creating databases and tables in MySQL. It also addresses various data wrangling tasks using Python scripts and awk-based shell scripts. Companion files with code are available from the publisher.Understanding data cleaning and manipulation is vital for data scientists. This book provides a comprehensive introduction to essential tools and techniques. From Python basics to advanced data wrangling, it equips readers with the skills needed to manage and clean data effectively.The journey begins with an introduction to Python and progresses through working with data, Pandas, and SQL. It also covers Java, JSON, XML, and specific data cleaning tasks. The book culminates with detailed data wrangling techniques, ensuring readers gain practical, hands-on experience in data management.

CSS3 and SVG with Claude 3. Mastering CSS3 and SVG: Techniques for Advanced Data Visualization and Animation

Mercury Learning and Information, Oswald Campesato

This book is an essential guide for mastering advanced CSS3 and SVG techniques, ideal for web developers aiming to create visually striking and interactive web content. It starts with an in-depth look at CSS3, covering shadow effects, gradients, 2D and 3D transforms, and sophisticated animations. You'll learn to implement complex styling, use media queries for responsive design, and create dynamic keyframe animations. Security practices and effective use of CSS3 are also addressed.Moving to SVG, the book explores creating scalable vector graphics for advanced data visualizations and animations. You'll learn to use SVG elements like shapes, gradients, and Bezier curves, and how to seamlessly integrate them with CSS3 for dynamic, interactive graphics. Detailed tutorials on SVG filters, transforms, and animations enable you to build intricate visual effects and engaging content. Practical examples show how to combine CSS3 and SVG for responsive, high-performance web projects.By the end, you’ll have the skills to craft compelling web applications using CSS3 and SVG, whether you're a beginner or an experienced developer looking to elevate your web design expertise.

Using AI in Marketing. Harness AI technologies to transform marketing strategies and results

Mercury Learning and Information, Greg Kihlström

Artificial Intelligence is reshaping the marketing landscape. This book begins with a foundational overview of AI and its history, establishing the importance of AI in modern marketing practices. Readers will gain insights into the integration of AI with marketing fundamentals, paving the way for strategic advancements.Delving deeper, the book explores current applications of AI, from data analytics to campaign automation, and personalized customer experiences. With chapters dedicated to generative AI, prompt optimization, and team augmentation, the book provides actionable insights and case studies to guide readers through real-world usage.As the journey concludes, readers are equipped with an understanding of AI's transformative impact, ethical considerations, and strategies for adoption. This book ensures that marketers are ready to embrace AI, optimize their workflows, and make informed investment decisions for future growth.

Excel 2021 / Microsoft 365 Programming By Example. A Comprehensive Guide to Mastering Excel VBA

Mercury Learning and Information, Julitta Korol

Updated for Excel 2021, this book is a practical guide for those proficient with the Excel user interface and looking to automate routine tasks. It introduces programming concepts through numerous hands-on exercises, progressing to advanced topics via custom projects. The journey begins with recording and editing macros, writing VBA code, and extends to programming the Ribbon interface and working with XML documents. The course covers automating operations on files, folders, and other Microsoft Office applications. It also delves into event procedures, testing, and debugging. Advanced features include working with VBA classes and raising custom events in standalone class modules. By mastering these skills, users can significantly enhance their productivity and efficiency in Excel.The book's structure, with 29 chapters and over 275 examples, ensures comprehensive learning. Companion files with source code, projects, and figures further support the user. This course is essential for anyone aiming to streamline their Excel tasks and harness the full power of Excel programming.

Data Structures and Program Design Using Python. A Self-Teaching Introduction to Data Structures and Python

Mercury Learning and Information, D. Malhotra, N. Malhotra

This book, part of the Pocket Primer series, introduces the basic concepts of data science using Python 3 and other applications. It offers a fast-paced introduction to data analytics, statistics, data visualization, linear algebra, and regular expressions. The book features numerous code samples using Python, NumPy, R, SQL, NoSQL, and Pandas. Companion files with source code and color figures are available.Understanding data science is crucial in today's data-driven world. This book provides a comprehensive introduction, covering key areas such as Python 3, data visualization, and statistical concepts. The practical code samples and hands-on approach make it ideal for beginners and those looking to enhance their skills.The journey begins with working with data, followed by an introduction to probability, statistics, and linear algebra. It then delves into Python, NumPy, Pandas, R, regular expressions, and SQL/NoSQL, concluding with data visualization techniques. This structured approach ensures a solid foundation in data science.