001433286 000__ 05415cam\a2200577\i\4500 001433286 001__ 1433286 001433286 003__ OCoLC 001433286 005__ 20230309003558.0 001433286 006__ m\\\\\o\\d\\\\\\\\ 001433286 007__ cr\cn\nnnunnun 001433286 008__ 210105s2021\\\\cau\\\\\o\\\\\001\0\eng\d 001433286 019__ $$a1232282563$$a1235837869$$a1237483929$$a1238201964$$a1238202112$$a1238204020$$a1240524096 001433286 020__ $$a9781484265550$$q(electronic bk.) 001433286 020__ $$a1484265556$$q(electronic bk.) 001433286 020__ $$a9781484265567$$q(print) 001433286 020__ $$a1484265564 001433286 020__ $$z1484265548 001433286 020__ $$z9781484265543$$q(print) 001433286 0247_ $$a10.1007/978-1-4842-6555-0$$2doi 001433286 035__ $$aSP(OCoLC)1228887638 001433286 040__ $$aYDX$$beng$$erda$$epn$$cYDX$$dEBLCP$$dVT2$$dYDXIT$$dOCLCO$$dGW5XE$$dDCT$$dERF$$dLDP$$dOCLCF$$dN$T$$dK6U$$dOCLCO$$dOCLCQ$$dOCLCO$$dOCLCQ 001433286 049__ $$aISEA 001433286 050_4 $$aQA76.9.D3$$bM67 2021 001433286 08204 $$a005.7565$$223 001433286 1001_ $$aMorgado, Flavio,$$eauthor. 001433286 24510 $$aIntroducing Microsoft Access using macro programming techniques :$$ban introduction to desktop database development by example /$$cFlavio Morgado. 001433286 264_1 $$a[Berkeley, CA] :$$bApress,$$c[2021] 001433286 300__ $$a1 online resource 001433286 336__ $$atext$$btxt$$2rdacontent 001433286 337__ $$acomputer$$bc$$2rdamedia 001433286 338__ $$aonline resource$$bcr$$2rdacarrier 001433286 347__ $$atext file 001433286 347__ $$bPDF 001433286 500__ $$aIncludes index. 001433286 5050_ $$aChapter 1: A Primer on Databases -- Chapter 2: Creating and Using Database Tables -- Chapter 3: Creating Queries -- Chapter 4: Using Forms -- Chapter 5: Using Macros -- Chapter 6: Using Reports. 001433286 506__ $$aAccess limited to authorized users. 001433286 520__ $$aLearn 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 Learn Discover the relational database and how it is different from other databases Create database tables and establish relationships between them to create a solid relational database system Understand the concept and importance of referential integrity (RI) in data and databases Use different types of Access queries to extract the information you need from the database Show database information in individual, customized windows using Access Forms Present insightful information about the database using Access Reports Automate your database solutions with macros This 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. Flavio Morgado 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 Programming Excel with VBA (Apress) and Microsoft Word Secrets (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. 001433286 588__ $$aOnline resource; title from digital title page (viewed on February 04, 2021). 001433286 63000 $$aMicrosoft Access. 001433286 650_0 $$aDatabase management. 001433286 650_0 $$aMacro instructions (Electronic computers) 001433286 650_6 $$aBases de données$$xGestion. 001433286 650_6 $$aMacro-instructions (Informatique) 001433286 655_0 $$aElectronic books. 001433286 77608 $$iPrint version:$$z1484265548$$z9781484265543$$w(OCoLC)1195471767 001433286 852__ $$bebk 001433286 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-6555-0$$zOnline Access$$91397441.1 001433286 909CO $$ooai:library.usi.edu:1433286$$pGLOBAL_SET 001433286 980__ $$aBIB 001433286 980__ $$aEBOOK 001433286 982__ $$aEbook 001433286 983__ $$aOnline 001433286 994__ $$a92$$bISE