{"product_id":"introducing-microsoft-access-using-macro-programming-techniques-an-introduction-to-desktop-database-development-by-example-paperback","title":"Introducing Microsoft Access Using Macro Programming Techniques: An Introduction to Desktop Database Development by Example - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eFlavio Morgado\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003eLearn Microsoft Access by building a powerful database application from start to finish.\u003c\/p\u003e\u003cp\u003eMicrosoft 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.\u003c\/p\u003e \u003cp\u003e\u003cb\u003e\u003ci\u003eIntroducing Microsoft Access Using Macro Programming Techniques\u003c\/i\u003e\u003c\/b\u003e 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.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eWhat You Will Learn\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDiscover the relational database and how it is different from other databases\u003c\/li\u003e\n\u003cli\u003eCreate database tables and establish relationships between them to create a solid relational database system\u003c\/li\u003e\n\u003cli\u003eUnderstand the concept and importance of referential integrity (RI) in data and databases\u003c\/li\u003e\n\u003cli\u003eUse different types of Access queries to extract the information you need from the database\u003c\/li\u003e\n\u003cli\u003eShow database information in individual, customized windows using Access Forms\u003c\/li\u003e\n\u003cli\u003ePresent insightful information about the database using Access Reports\u003c\/li\u003e\n\u003cli\u003eAutomate your database solutions with macros\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003eWho This Book Is For\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAnyone 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.\u003c\/p\u003e\u003ch3\u003eBack Jacket\u003c\/h3\u003e\u003cp\u003eLearn Microsoft Access by building a powerful database application from start to finish.\u003c\/p\u003e\u003cp\u003eMicrosoft 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.\u003c\/p\u003e\u003cp\u003e\u003ci\u003eIntroducing Microsoft Access Using Macro Programming Techniques\u003cb\u003e \u003c\/b\u003e\u003c\/i\u003eapproaches 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.\u003c\/p\u003e\u003cp\u003e\u003cb\u003eWhat You Will Learn\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDiscover the relational database and how it is different from other databases\u003c\/li\u003e\n\u003cli\u003eCreate database tables and establish relationships between them to create a solid relational database system\u003c\/li\u003e\n\u003cli\u003eUnderstand the concept and importance of referential integrity (RI) in data and databases\u003c\/li\u003e\n\u003cli\u003eUse different types of Access queries to extract the information you need from the database\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eShow database information in individual, customized windows using Access Forms\u003c\/li\u003e\n\u003cli\u003ePresent insightful information about the database using Access Reports\u003c\/li\u003e\n\u003cli\u003eAutomate your database solutions with macros\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003c\/p\u003eThis book is for anyone 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. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eFlavio Morgado\u003c\/b\u003e is a food engineer with an MSc. degree in food science and technology, a VBA professional developer, and a professor of epidemiology, statistics, and medical informatics at UNIFESO, a health sciences university in Rio de Janeiro, Brazil. Flavio has written more than 30 books, including \u003ci\u003eProgramming Excel with VBA\u003c\/i\u003e (Apress) and \u003ci\u003eMicrosoft Word Secrets\u003c\/i\u003e (Apress), and has translated many technical books. He also loves animals and the exquisite nature of the surrounding rainforest, and when he is not teaching, writing, or developing, he can be found running or riding his mountain bike through the Teresopolis Mountains, followed by his eight dogs, or spending time on the stunningly beautiful beaches of Cabo Frio in Rio de Janeiro.\u003cbr\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003cb\u003eFlavio Morgado\u003c\/b\u003e is a food engineer with an MSc. degree in food science and technology, a VBA professional developer, and a professor of epidemiology, statistics, and medical informatics at UNIFESO, a health sciences university in Rio de Janeiro, Brazil. Flavio has written more than 30 books, including \u003ci\u003eProgramming Excel with VBA\u003c\/i\u003e (Apress) and \u003ci\u003eMicrosoft Word Secrets\u003c\/i\u003e (Apress), and has translated many technical books. He also loves animals and the exquisite nature of the surrounding rainforest, and when he is not teaching, writing, or developing, he can be found running or riding his mountain bike through the Teresopolis Mountains, followed by his eight dogs, or spending time on the stunningly beautiful beaches of Cabo Frio in Rio de Janeiro.\u003cbr\u003e\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 597\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1.25 x 10 x 7 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e December 27, 2020\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47212870992121,"sku":"9781484265543","price":70.18,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/QS9pVTROcmVxQU1VNEpDa0dUaXY2dz09.webp?v=1768098774","url":"https:\/\/bookscloud.io\/products\/introducing-microsoft-access-using-macro-programming-techniques-an-introduction-to-desktop-database-development-by-example-paperback","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}