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.