Bøger af Flavio Morgado

Learn Microsoft Access by building a powerful database application from start to finish.Microsoft Access ships with every version of Office, from Office 2019 to Office 365 Home and Personal editions. Most people understand the value of having a reliable contact database, but few realize that Access can be an incredibly valuable data tool and an excellent gateway for learning database development.Introducing Microsoft Access Using Macro Programming Techniques approaches database development from a practical and experiential standpoint. You will learn important data concepts as you journey through each step of creating a database using Access. The example you will build takes advantage of a massive amount of data from an external source of nutritional data (USDA). You will leverage this freely available repository of information in multiple ways, putting Access to the test in creating powerful business solutions that you can then apply to your own data sets. The tables and records in this database will be used to demonstrate key relational principles in Access, including how to use the relationship window to understand the relationships between tables and how to create different objects such as queries, forms, reports, and macros. Using this approach, you will learn how desktop database development can be a powerful solution to meet your business needs.What You Will LearnDiscover the relational database and how it is different from other databasesCreate database tables and establish relationships between them to create a solid relational database systemUnderstand the concept and importance of referential integrity (RI) in data and databasesUse different types of Access queries to extract the information you need from the databaseShow database information in individual, customized windows using Access FormsPresent insightful information about the database using Access ReportsAutomate your database solutions with macrosWho This Book Is ForAnyone who wants to learn how to build a database using Microsoft Access to create customized solutions. It is also useful for those working in IT managing large contact data sets (healthcare, retail, etc.) who need to learn the basics in order to create a professional database solution. Readers should have access to some version of Microsoft Access in order to perform the exercises in this book.

Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-by-step guidance, example applications, and screenshots in Excel 2016.In this book, you will learn:How to interact with key Excel objects, such as the application object, workbook object, and range objectMethods for working with ranges in detail using codeUsage of Excel as a database repositoryHow to exchange data between Excel applicationsHow to use the Windows API to expand the capabilities of ExcelA step-by-step method for producing your own custom Excel ribbonWho This Book Is For:Developers and intermediate-to-advanced Excel users who want to dive deeper into the capabilities of Excel 2016 using code.