LEADER 04811oam 2200481 450 001 9910483291703321 005 20220830213037.0 010 $a1-4842-6555-6 024 7 $a10.1007/978-1-4842-6555-0 035 $a(CKB)4100000011692814 035 $a(DE-He213)978-1-4842-6555-0 035 $a(MiAaPQ)EBC6447682 035 $a(CaSebORM)9781484265550 035 $a(PPN)252518594 035 $a(EXLCZ)994100000011692814 100 $a20210612d2021 uy 0 101 0 $aeng 135 $aurnn#008mamaa 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aIntroducing Microsoft Access using macro programming techniques $ean introduction to desktop database development by example /$fFlavio Morgado 205 $a1st ed. 2021. 210 1$aBerkeley, California :$cApress,$d[2021] 210 4$d©2021 215 $a1 online resource (XX, 597 p. 433 illus.) 300 $aIncludes index. 311 $a1-4842-6554-8 327 $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. 330 $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. 606 $aDatabase management 606 $aMacro instructions (Electronic computers) 615 0$aDatabase management. 615 0$aMacro instructions (Electronic computers) 676 $a005.7565 700 $aMorgado$b Flavio$0917116 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bUtOrBLW 906 $aBOOK 912 $a9910483291703321 996 $aIntroducing Microsoft Access using macro programming techniques$92847279 997 $aUNINA LEADER 05584nam 2200673 a 450 001 9910791910603321 005 20230617031347.0 010 $a1-283-54894-1 010 $a9786613861399 010 $a90-272-7294-8 035 $a(CKB)2560000000091085 035 $a(EBL)997712 035 $a(OCoLC)808670842 035 $a(SSID)ssj0000701168 035 $a(PQKBManifestationID)11399973 035 $a(PQKBTitleCode)TC0000701168 035 $a(PQKBWorkID)10670663 035 $a(PQKB)10599517 035 $a(MiAaPQ)EBC997712 035 $a(Au-PeEL)EBL997712 035 $a(CaPaEBR)ebr10593819 035 $a(EXLCZ)992560000000091085 100 $a20050602d2005 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aDublin English$b[electronic resource] $eevolution and change /$fRaymond Hickey 210 $aAmsterdam ;$aPhiladelphia $cJ. Benjamins Pub. Co.$d2005 215 $a1 online resource (280 p.) 225 1 $aVarieties of English around the world. General series,$x0172-7362 ;$vv. G35 300 $aDescription based upon print version of record. 311 $a90-272-4895-8 320 $aIncludes bibliographical references (p. [243]-260) and index. 327 $aDublin English Evolution and change; Editorial page; Title page; Copyright page; Table of contents; Preface; I Investigating Dublin English; 1 Introduction; 1.1 Matters of terminology; 1.2 The city of Dublin; 1.3 Classifying Dublin English; 2 Collecting data; The observations concerning vowel shifts in Dublin; 2.2 Initial methods used; 2.3 Conducting the interviews; 2.4 Results of the data collection; 2.5 Data and figures; 2.6 Increasing the data base; 2.7 Aim of the recordings; 2.8 Organisation of the recordings; 2.9 Obtaining recordings for Dublin English 327 $a2.10 Sample sentences with lexical sets 2.11 Free text; 2.12 Word list; II English in present-day Dublin; 1 Introduction; 1.1 How can one tell a moderate Dublin accent?; 1.2 The status of Received Pronunciation; 1.3 The local Dublin speech community; 1.4 Features of local Dublin accents; 1.5 Additional data for local Dublin English; 1.6 Markers of local Dublin English; 2 Recent changes in Dublin English; 2.1 Before and after the changes; 2.2 In the beginning was Dublin 4; 2.3 Why 'Dortspeak' failed; 2.4 Demotic developments: the 1990's vowel shift; 2.5 Details of the vowel shift 327 $a2.6 Arguments for and against the shift 2.7 Phonological interpretation; 2.8 Participants in the vowel shift; 2.9 Propagation of sound change; 2.10 More on dissociation; 2.11 The New Pronunciation; 2.12 Irish, British and American English; 2.13 Uncontentious features in Dublin English; 2.14 The spread of new Dublin English; 2.15 The gender issue; 3 Attitudes to Dublin English; 3.1 Assessment of speaker accents; 3.2 Assessment results; 3.3 Perception of dialect regions; 3.4 Results of dialect divisions; 3.5 Evaluation of dialect regions; 4 The wider context; 4.1 English in Belfast 327 $a4.2 English in Derry 4.3 Dublin and northern cities; 4.4 Dublin and London; 4.5 New towns and new suburbs; 4.6 Non-native Dublin English; 5 The grammar of Dublin English; 5.1 Morphology; 5.2 Syntax; 5.3 A Survey of Irish English Usage; 6 The vocabulary of Dublin English; 6.1 Studies of the Irish English lexicon; 6.2 Treatment of English lexis; 6.3 Productive morphology; 6.4 Vernacularity in Dublin English; 6.5 Loanwords from Irish; 6.6 Phrases and expressions; 7 Place names in Dublin; III Reaching back in time; 1 The history of English in Ireland; 1.1 The coming of the English 327 $a1.2 Spread of English 1.3 The situation in medieval Ireland; 1.4 Renewed dominance of English; 1.5 The eighteenth century; 1.6 The nineteenth century; 2 Letters as linguistic evidence; 2.1 18th century letters; 2.1.1 The Mahon letters; 2.2 19th century letters; 2.2.1 The Owens Letters; 3 Literary texts as linguistic evidence; 3.1 The plays of Dion Boucicault; 3.2 The plays of Sean O 'Casey; 4 Prescriptive comments by Dublin authors; 4.1 Thomas Sheridan; 4.1.1 Sheridan's system of pronunciation; 4.1.2 Non-standard vowel values; 4.1.3 Conditioned realisations; 4.1.4 Word stress; 4.1.5 Summary 327 $a4.2 Swift and Irish English 330 $aThe present book describes the English language in all its facets as spoken in present-day Dublin, the capital of the Republic of Ireland. It covers the entire range of its history since the first arrival of English there several hundred years ago. Apart from the evolution of English in the capital, the book also concentrates on the significant changes which have been taking place in the speech of Dublin in the past 15 years or so. The rapid change of Dublin English is seen as a correlate to the many social and economic developments which have occurred in recent years. The type of linguistic 410 0$aVarieties of English around the world.$pGeneral series ;$vv. 35. 606 $aEnglish language$zIreland$zDublin 606 $aEnglish language$xDialects$zIreland$zDublin 606 $aEnglish language$xVariation$zIreland$zDublin 607 $aDublin (Ireland)$xLanguages 615 0$aEnglish language 615 0$aEnglish language$xDialects 615 0$aEnglish language$xVariation 676 $a427/.941835 700 $aHickey$b Raymond$f1954-$0176031 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910791910603321 996 $aDublin English$91099197 997 $aUNINA