Access 2021 / Microsoft 365 Programming by Example. Mastering VBA for Data Management and Automation

Mercury Learning and Information, Julitta Korol

Updated for Access 2021 and based on bestselling editions, this book is a practical guide on Access programming, perfect for users proficient with the Access UI. It introduces programming concepts through illustrated hands-on exercises and custom projects. You will learn to write and test code with the Visual Basic Editor, use VBA structures like conditions, loops, arrays, collections, and dictionaries, and reprogram database characteristics.The book covers building database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO), defining database objects, and managing database security with SQL. It explores enhancing user interaction with Ribbon customizations and event programming in forms and reports. Additionally, you'll learn to use Access with XML and REST API.From getting started with Access VBA to advanced event programming and macros, this book ensures a comprehensive understanding of Access programming. It transitions readers from basic to advanced topics, equipping them with the knowledge and tools to automate Access routine tasks effectively.

Microsoft Excel 2021 Programming Pocket Primer. A Comprehensive Guide to Mastering Excel VBA

Mercury Learning and Information, Julitta Korol

This book, part of the successful Pocket Primer series, is designed for those who need to quickly master Excel programming fundamentals. It offers a concise, efficient introduction to VBA, ensuring you only learn what you need to feel comfortable with Excel VBA. The concepts learned in this book also apply to Access programming. The nine chapters progressively introduce you to programming in Microsoft Excel 2021.Starting with a quick guide to Excel macros and the VBA programming environment, the book moves on to fundamental concepts and writing function procedures. You will learn to add decision-making capabilities and looping statements to your programs, store and manage multiple values using arrays and collections, and utilize built-in tools for testing and debugging your code.By the end of the course, you will have a solid foundation in Excel VBA, enabling you to automate tasks and enhance your productivity. This structured approach makes the book an essential resource for mastering Excel VBA efficiently and effectively.

Autodesk(R) Revit(R) 2024 Architecture. Mastering Building Design with BIM

Mercury Learning and Information, Munir Hamad

This book covers all major techniques in Revit 2024 Architecture using both metric and imperial units. It details the myriad drawing and editing tools and includes over 50 mini-workshops that guide users from concept to plotting. By solving these workshops, readers will master Revit Architecture, covering all basic commands and functions. Companion files with templates and models are available for practical application.The course begins with an introduction to Revit 2024, followed by detailed chapters on drawing, modifying, project preparation, and wall construction. Subsequent chapters cover doors, windows, curtain walls, floors, roofs, components, and ceilings. Users will also learn about creating stairs, ramps, railings, views, annotations, legends, and visualization.Further, the book delves into schedules, project phasing, design options, topography, rooms, tagging, detailing, groups, file import/export, mass creation, and customizing elements. It concludes with chapters on creating and customizing families, and managing worksets and shared views, ensuring comprehensive knowledge and skills in Revit 2024 Architecture.

Dealing With Data Pocket Primer. A Comprehensive Guide to Data Handling Techniques

Mercury Learning and Information, Oswald Campesato

This book introduces the basic concepts of managing data using various computer languages and applications. It is designed as a fast-paced introduction to key features of data management, including statistical concepts, data-related techniques, Pandas, RDBMS, SQL, NLP topics, Matplotlib, and data visualization. The companion files with source code and color figures enhance the learning experience.Understanding these concepts is crucial for anyone looking to manage data effectively. The book covers the fundamentals of probability and statistics, working with data using Pandas, managing databases with SQL and MySQL, and cleaning data using NLP techniques. It also delves into data visualization, providing practical insights and numerous code samples.The journey begins with an introduction to probability and statistics, moving on to working with data and Pandas. It then covers RDBMS and SQL, focusing on practical SQL and MySQL usage. The book concludes with NLP, data cleaning, and visualization techniques, equipping readers with a comprehensive understanding of data management.

Market Research and Analysis. Mastering Market Research: Advanced Methods, Design, and Data Analysis

Mercury Learning and Information, Marcus Goncalves

This book offers an in-depth exploration of market research and analysis, guiding readers through the entire process from defining research objectives to communicating results. Begin by understanding the purpose and ethics of market research, laying a strong groundwork for your studies. Progress to defining precise research objectives and exploring secondary research methods to gather existing information.Next, engage with primary research methods, focusing on both quantitative and qualitative approaches. Learn how to develop and distribute surveys, choose the right sampling techniques, and utilize tools for data mining and web scraping. Gain insights into focus groups and observation studies, understanding how these qualitative methods can provide depth to your research.Finally, master the art of data analysis and result communication. Explore descriptive statistics, hypothesis testing, and inferential statistics to make sense of your data. Learn to effectively present your findings to stakeholders, ensuring your research translates into actionable insights. By the end of the course, you will be well-equipped to conduct thorough market research and communicate your results effectively.

Embedded Vision. Mastering Advanced Techniques for Real-Time Image Processing and Analysis

Mercury Learning and Information, S. R. Vijayalakshmi, S. Muruganand

Embedded vision integrates computer vision into machines using algorithms to interpret images or videos. This book serves as an introductory guide for designing vision-enabled embedded products, with applications in AI, machine learning, industrial, medical, automotive, and more. It covers hardware architecture, software algorithms, applications, and advancements in cameras, processors, and sensors.The course begins with an overview of embedded vision, followed by industrial and medical vision applications. It then delves into video analytics, digital image processing, and camera-image sensors. Subsequent chapters cover embedded vision processors, computer vision, and AI integration. The final chapter presents real-time vision-based examples.Understanding these concepts is vital for developing advanced vision-enabled machines. This book takes readers from the basics to advanced topics, blending theoretical knowledge with practical applications. It is an essential resource for mastering embedded vision technology across various industries.

Angular and Machine Learning Pocket Primer. A Comprehensive Guide to Angular and Integrating Machine Learning

Mercury Learning and Information, Oswald Campesato

As part of the best-selling *Pocket Primer* series, this book introduces readers to basic machine learning concepts and integrates them into Angular applications. It offers a fast-paced introduction to essential machine learning features and an overview of popular classifiers. Covering Angular functionality, basic machine learning concepts, and key classification algorithms, the book includes numerous code samples and figures. Topics such as TensorFlow and Keras are also explored.The book begins with a quick introduction to Angular, followed by UI controls, user input, and forms and services. As you progress, you will delve into machine learning, working with classifiers, and integrating TensorFlow.js with Angular. These foundational topics ensure a comprehensive grasp of both Angular and machine learning principles, equipping you with practical skills for developing sophisticated applications.Understanding these concepts is crucial for enhancing Angular projects with machine learning capabilities. This book transitions you from a novice to a proficient developer, equipped with the knowledge and tools needed to create advanced applications. Companion files with source code and color figures enhance the learning experience, making this book an invaluable resource for integrating machine learning with Angular.

Python 3 and Data Visualization. Mastering Graphics and Data Manipulation with Python

Mercury Learning and Information, Oswald Campesato

Python 3 and Data Visualization provides an in-depth exploration of Python 3 programming and data visualization techniques. The course begins with an introduction to Python, covering essential topics from basic data types and loops to advanced constructs such as dictionaries and matrices. This foundation prepares readers for the next section, which focuses on NumPy and its powerful array operations, seamlessly leading into data visualization using prominent libraries like Matplotlib.Chapter 6 delves into Seaborn's rich visualization tools, providing insights into datasets like Iris and Titanic. The appendix covers additional visualization tools and techniques, including SVG graphics and D3 for dynamic visualizations. The companion files include numerous Python code samples and figures, enhancing the learning experience.From foundational Python concepts to advanced data visualization techniques, this course serves as a comprehensive resource for both beginners and seasoned professionals, equipping them with the necessary skills to effectively visualize data.

Transformer, BERT, and GPT. Unlock the Power of Transformers, BERT, GPT-3, and GPT-4 in Natural Language Processing

Mercury Learning and Information, Oswald Campesato

This book offers an in-depth exploration of the Transformer architecture, BERT models, and the GPT series, including GPT-3 and GPT-4. Beginning with foundational concepts like the attention mechanism and tokenization techniques, it delves into the intricacies of Transformer and BERT architectures. Advanced topics cover the latest developments in the GPT series, including ChatGPT. Key chapters provide insights into the evolution and significance of attention in deep learning, the nuances of Transformer architecture, a detailed exploration of the BERT family, and hands-on guidance on working with GPT-3.The journey continues with a comprehensive overview of ChatGPT, GPT-4, and visualization using generative AI. The book also discusses influential AI organizations such as DeepMind, OpenAI, Cohere, and Hugging Face. Readers will gain a thorough understanding of the current landscape of NLP models, their underlying architectures, and practical applications.Companion files with numerous code samples and figures from the book enhance the learning experience, providing practical tools and resources. This book is an essential guide for those seeking to master the latest advancements in natural language processing and generative AI.

Cybersecurity. A Self-Teaching Introduction

Mercury Learning and Information, C. P. Gupta, K. K. Goyal

This book provides fundamental concepts of cybersecurity and cybercrime in an easy-to-understand, self-teaching format. It covers data security, threats, viruses, malicious software, firewalls, VPNs, security architecture, design, policies, cyberlaw, and cloud security.The course starts with an introduction to information systems and cybersecurity application security. It progresses to developing secure information systems and understanding information security policies, standards, and cyberlaw. The final chapters address the security of emerging technologies, including cloud security, IoT, and AES.Understanding these concepts is crucial for protecting data and systems against cyber threats. This book transitions readers from basic knowledge to advanced cybersecurity practices, combining theoretical insights with practical applications. It is an invaluable resource for mastering cybersecurity in today's digital age.

Access 365 Project Book. Hands-On Database Creation

Mercury Learning and Information, Julitta Korol

This book is a practical introduction to building and managing Access desktop databases. Instead of merely explaining Microsoft Access, it helps you complete tasks related to creating, using, and managing a database. The hands-on approach focuses on creating a traditional Access desktop database and emphasizes splitting the database for optimized multi-user access. The primary project, the Employee Training Database (ETD), offers practical, real-world experience.The book guides you through database creation and management. It starts with planning and designing a database, followed by creating and setting up Access tables. It then covers primary keys, indexes, and table relationships, and populating tables with data. The middle sections include working with queries and designing and customizing forms.The latter part focuses on designing and using reports and customizing them. It concludes with compacting, splitting, and securing the database for optimized performance and security. These concepts enable efficient database management and enhance multi-user collaboration. This book transitions you from a novice to a proficient user, equipped with practical skills and comprehensive knowledge. Companion files with hands-on examples enrich your learning.

Classic Game Design. From Pong to Pac-Man with Unity: Crafting Timeless Retro Games with Expert Techniques

Mercury Learning and Information, Franz Lanzinger

This book teaches you to design and develop classic arcade video games. Using modern, free software tools like Unity, you’ll create five retro games inspired by the classics. All source code, art, and sound files are provided in the companion files. You'll enjoy customizing graphics, adjusting scoring, coding AI, and creating sound effects, gaining a deep understanding of the roots of modern video game design from the '70s and '80s.The course begins with an introduction and essential tools, then guides you through creating various retro games. Each chapter builds on the previous one with detailed instructions, exercises, and classic game design rules. The book includes historical anecdotes from a former Atari programmer and insights on applying classic game design concepts to modern games.Understanding these design elements is crucial for developing engaging video games. This book transitions readers from beginners to proficient game developers, blending theoretical knowledge with practical skills. Companion files enhance the learning experience, making this book an invaluable resource for mastering classic game design with modern tools.

Photograph Restoration and Enhancement. Master the Art of Restoring and Enhancing Photographs Using Adobe Photoshop CC 2021 Version

Mercury Learning and Information, Vickie Ellen Wolper

Updated for Photoshop CC 2021, this edition offers hands-on learning with a building block teaching style. Suitable for all skill levels, it teaches photo restoration and tonal correction. Learn to repair damage, improve discolored photos, colorize black and white images, digitize large photos, and adjust content for perfect shots. Tips, notes, figures, and projects help you master restorations and enhancements.The course starts with preparing an image for Photoshop and an introduction to the software. It covers selection, layers, transformations, painting, printing, and repairing photo flaws. Advanced topics include correcting lighting, enhancing photos, and mastering trade secrets. Final chapters address special challenges and applying skills to complex projects.These skills are vital for high-quality photo restorations. This book transitions readers from basic to advanced Photoshop techniques, blending theory with practice. Companion files with photos, projects, figures, and videos enhance learning, making this an essential resource for mastering photo restoration.

Enterprise Transformation to Artificial Intelligence and the Metaverse. Strategies for the Technology Revolution: Navigating Future Technologies with Agility and Innovation

Mercury Learning and Information, William Kimmerly

This book guides organizations in effectively responding to the metaverse, a rapidly converging collection of advanced technologies, methods, and models. The metaverse is poised to be as disruptive as the personal computer, Internet, and smartphone, impacting personal, social, professional, and business lives. The book covers essential metaverse technologies and concepts, helping organizational leaders plan their transformation strategies.The journey begins with an introduction and key definitions, followed by the evolution of IT governance and responses to disruptive technologies. It delves into AI, machine learning, blockchain, platforms, algorithms, edge computing, quantum computing, and immersive technologies like VR, AR, MR, and XR. Further chapters explore holographic technologies, deep tech, and other metaverse-related technologies, along with organizational structures and governance frameworks for the metaverse era.Understanding these concepts is crucial for navigating the metaverse transformation. The book concludes with a detailed hypothetical case study, illustrating how such a transformation can be achieved. This resource helps executives and professionals chart an effective course to the metaverse, blending theoretical insights with practical applications.

Industrial Automation and Robotics. A Comprehensive Guide to Automated Systems and Robotics

Mercury Learning and Information, Jean Riescher Westcott, A.K. Gupta, S.K. Arora

This course offers an introduction to automation and robotics for industrial applications. It begins with essential concepts of hydraulics and pneumatics, explaining their roles in industrial automation. Next, it delves into circuits and their applications in hydraulic, pneumatic, and fluidic design. The latter part focuses on electric and electronic controls, ending with robotics, robotic programming, and their industrial applications. Understanding these concepts is crucial for anyone looking to work in automation, as they provide the foundation for designing and maintaining automated systems. The course covers everything from basic laws and principles to advanced topics like the use of UAVs and AI in industrial automation.Throughout the course, you'll explore real-world applications and see how these principles are applied in industry. This structured approach ensures you gain a comprehensive understanding, from fundamental concepts to advanced automation and robotics techniques, preparing you for a career in this dynamic field.

AI in Digital Marketing. Harnessing AI tools to revolutionize digital marketing strategies

Mercury Learning and Information, Maria Johnsen

Artificial Intelligence is transforming the digital marketing landscape, offering innovative solutions for personalization, automation, and efficiency. This comprehensive guide explores AI's impact on digital marketing, focusing on data-driven insights, predictive analytics, and customer engagement strategies. It empowers marketers to understand and leverage AI's potential in crafting targeted campaigns and optimizing workflows.Readers will explore essential topics like machine learning, natural language processing, and sentiment analysis, all tailored for marketing applications. Practical insights on SEO, content creation, and social media listening are combined with advanced concepts such as programmatic advertising, AI-powered customer support, and marketing automation. The book ensures a balance between foundational knowledge and actionable strategies.This resource equips digital marketers, strategists, and analysts to adopt emerging trends, drive measurable results, and maintain a competitive edge in the AI-driven marketing ecosystem. It is the perfect companion for professionals seeking to enhance their skills and harness the power of AI in their digital marketing efforts.