Access 2021 / Microsoft 365 Programming by Example / / Julitta Korol.
Updated for Access 2021 and based on the bestselling editions from previous versions, Access 2021 / Microsoft 365 Programming by Example is a practical, how-to book on Access programming, suitable for readers already proficient with the Access user interface (UI). If you are looking to automate Acce...
Saved in:
VerfasserIn: | |
---|---|
Place / Publishing House: | Dulles, VA : : Mercury Learning and Information, , [2022] ©2022 |
Year of Publication: | 2022 |
Language: | English |
Online Access: | |
Physical Description: | 1 online resource (1132 p.) |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
9781683928409 |
---|---|
ctrlnum |
(DE-B1597)653876 |
collection |
bib_alma |
record_format |
marc |
spelling |
Korol, Julitta, author. aut http://id.loc.gov/vocabulary/relators/aut Access 2021 / Microsoft 365 Programming by Example / Julitta Korol. Dulles, VA : Mercury Learning and Information, [2022] ©2022 1 online resource (1132 p.) text txt rdacontent computer c rdamedia online resource cr rdacarrier text file PDF rda Frontmatter -- Contents -- Acknowledgments -- Introduction -- PART I ACCESS VBA PRIMER -- PART II ACCESS VBA PROGRAMMING WITH DAO AND ADO -- PART III ACCESS STRUCTURED QUERY LANGUAGE (SQL) -- PART IV IMPLEMENTING DATABASE SECURITY -- PART V VBA PROGRAMMING IN ACCESS FORMS AND REPORTS -- PART VI ENHANCING THE USER EXPERIENCE -- PART VII ADVANCED CONCEPTS IN ACCESS VBA -- PART VIII VBA AND MACROS -- PART IX WORKING TOGETHER: VBA, XML, AND RESTAPI -- Appendix: Installing Internet Information Services (IIS) -- Index restricted access http://purl.org/coar/access_right/c_16ec online access with authorization star Updated for Access 2021 and based on the bestselling editions from previous versions, Access 2021 / Microsoft 365 Programming by Example is a practical, how-to book on Access programming, suitable for readers already proficient with the Access user interface (UI). If you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. With concise and straightforward explanations, you learn how to write and test your programming code with the built-in Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, collections and dictionaries; code a "message box"; reprogram characteristics of a database; and use various techniques to query and manipulate your Access .mdb and .accdb databases. The book shows you how you can build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with SQL; enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports. You also learn how to use Access with XML and REST API. The book includes a comprehensive disc with source code, supplemental files, and color screen captures (also available from the publisher for download). FEATURES: Contains 28 chapters loaded with illustrated "Hands-On" exercises and projects that guide you through the VBA programming language. Each example tells you exactly where to enter code, how to test it and run it.Explains how to store data for further manipulation in variables, arrays, collections, and in a VBA Dictionary object while teaching you to write both simple and complex VBA programming routines and functions.Teaches you how to programmatically create and access database tables and fields, enforce data integrity and relationships between tables.Includes a comprehensive disc with source code, supplemental files, and color screen captures (also available from the publisher for download). Issued also in print. Mode of access: Internet via World Wide Web. In English. Description based on online resource; title from PDF title page (publisher's Web site, viewed 08. Aug 2023) Data. Programming. Software. COMPUTERS / Programming / Microsoft. bisacsh ASP. Access 2021. Business. Computer Science. Data Science. MS 365. VBA. XML. EPUB 9781683928393 print 9781683928416 https://www.degruyter.com/isbn/9781683928409 Cover https://www.degruyter.com/document/cover/isbn/9781683928409/original |
language |
English |
format |
eBook |
author |
Korol, Julitta, Korol, Julitta, |
spellingShingle |
Korol, Julitta, Korol, Julitta, Access 2021 / Microsoft 365 Programming by Example / Frontmatter -- Contents -- Acknowledgments -- Introduction -- PART I ACCESS VBA PRIMER -- PART II ACCESS VBA PROGRAMMING WITH DAO AND ADO -- PART III ACCESS STRUCTURED QUERY LANGUAGE (SQL) -- PART IV IMPLEMENTING DATABASE SECURITY -- PART V VBA PROGRAMMING IN ACCESS FORMS AND REPORTS -- PART VI ENHANCING THE USER EXPERIENCE -- PART VII ADVANCED CONCEPTS IN ACCESS VBA -- PART VIII VBA AND MACROS -- PART IX WORKING TOGETHER: VBA, XML, AND RESTAPI -- Appendix: Installing Internet Information Services (IIS) -- Index |
author_facet |
Korol, Julitta, Korol, Julitta, |
author_variant |
j k jk j k jk |
author_role |
VerfasserIn VerfasserIn |
author_sort |
Korol, Julitta, |
title |
Access 2021 / Microsoft 365 Programming by Example / |
title_full |
Access 2021 / Microsoft 365 Programming by Example / Julitta Korol. |
title_fullStr |
Access 2021 / Microsoft 365 Programming by Example / Julitta Korol. |
title_full_unstemmed |
Access 2021 / Microsoft 365 Programming by Example / Julitta Korol. |
title_auth |
Access 2021 / Microsoft 365 Programming by Example / |
title_alt |
Frontmatter -- Contents -- Acknowledgments -- Introduction -- PART I ACCESS VBA PRIMER -- PART II ACCESS VBA PROGRAMMING WITH DAO AND ADO -- PART III ACCESS STRUCTURED QUERY LANGUAGE (SQL) -- PART IV IMPLEMENTING DATABASE SECURITY -- PART V VBA PROGRAMMING IN ACCESS FORMS AND REPORTS -- PART VI ENHANCING THE USER EXPERIENCE -- PART VII ADVANCED CONCEPTS IN ACCESS VBA -- PART VIII VBA AND MACROS -- PART IX WORKING TOGETHER: VBA, XML, AND RESTAPI -- Appendix: Installing Internet Information Services (IIS) -- Index |
title_new |
Access 2021 / Microsoft 365 Programming by Example / |
title_sort |
access 2021 / microsoft 365 programming by example / |
publisher |
Mercury Learning and Information, |
publishDate |
2022 |
physical |
1 online resource (1132 p.) Issued also in print. |
contents |
Frontmatter -- Contents -- Acknowledgments -- Introduction -- PART I ACCESS VBA PRIMER -- PART II ACCESS VBA PROGRAMMING WITH DAO AND ADO -- PART III ACCESS STRUCTURED QUERY LANGUAGE (SQL) -- PART IV IMPLEMENTING DATABASE SECURITY -- PART V VBA PROGRAMMING IN ACCESS FORMS AND REPORTS -- PART VI ENHANCING THE USER EXPERIENCE -- PART VII ADVANCED CONCEPTS IN ACCESS VBA -- PART VIII VBA AND MACROS -- PART IX WORKING TOGETHER: VBA, XML, AND RESTAPI -- Appendix: Installing Internet Information Services (IIS) -- Index |
isbn |
9781683928409 9781683928393 9781683928416 |
url |
https://www.degruyter.com/isbn/9781683928409 https://www.degruyter.com/document/cover/isbn/9781683928409/original |
illustrated |
Illustrated |
work_keys_str_mv |
AT koroljulitta access2021microsoft365programmingbyexample |
status_str |
n |
ids_txt_mv |
(DE-B1597)653876 |
carrierType_str_mv |
cr |
is_hierarchy_title |
Access 2021 / Microsoft 365 Programming by Example / |
_version_ |
1775793046646947840 |
fullrecord |
<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>04877nam a22006975i 4500</leader><controlfield tag="001">9781683928409</controlfield><controlfield tag="003">DE-B1597</controlfield><controlfield tag="005">20230808014301.0</controlfield><controlfield tag="006">m|||||o||d||||||||</controlfield><controlfield tag="007">cr || ||||||||</controlfield><controlfield tag="008">230808t20222022 fo d z eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781683928409</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-B1597)653876</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-B1597</subfield><subfield code="b">eng</subfield><subfield code="c">DE-B1597</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">vau</subfield><subfield code="c">US-VA</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM051380</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Korol, Julitta, </subfield><subfield code="e">author.</subfield><subfield code="4">aut</subfield><subfield code="4">http://id.loc.gov/vocabulary/relators/aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Access 2021 / Microsoft 365 Programming by Example /</subfield><subfield code="c">Julitta Korol.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Dulles, VA : </subfield><subfield code="b">Mercury Learning and Information, </subfield><subfield code="c">[2022]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2022</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (1132 p.)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield><subfield code="b">PDF</subfield><subfield code="2">rda</subfield></datafield><datafield tag="505" ind1="0" ind2="0"><subfield code="t">Frontmatter -- </subfield><subfield code="t">Contents -- </subfield><subfield code="t">Acknowledgments -- </subfield><subfield code="t">Introduction -- </subfield><subfield code="t">PART I ACCESS VBA PRIMER -- </subfield><subfield code="t">PART II ACCESS VBA PROGRAMMING WITH DAO AND ADO -- </subfield><subfield code="t">PART III ACCESS STRUCTURED QUERY LANGUAGE (SQL) -- </subfield><subfield code="t">PART IV IMPLEMENTING DATABASE SECURITY -- </subfield><subfield code="t">PART V VBA PROGRAMMING IN ACCESS FORMS AND REPORTS -- </subfield><subfield code="t">PART VI ENHANCING THE USER EXPERIENCE -- </subfield><subfield code="t">PART VII ADVANCED CONCEPTS IN ACCESS VBA -- </subfield><subfield code="t">PART VIII VBA AND MACROS -- </subfield><subfield code="t">PART IX WORKING TOGETHER: VBA, XML, AND RESTAPI -- </subfield><subfield code="t">Appendix: Installing Internet Information Services (IIS) -- </subfield><subfield code="t">Index</subfield></datafield><datafield tag="506" ind1="0" ind2=" "><subfield code="a">restricted access</subfield><subfield code="u">http://purl.org/coar/access_right/c_16ec</subfield><subfield code="f">online access with authorization</subfield><subfield code="2">star</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Updated for Access 2021 and based on the bestselling editions from previous versions, Access 2021 / Microsoft 365 Programming by Example is a practical, how-to book on Access programming, suitable for readers already proficient with the Access user interface (UI). If you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. With concise and straightforward explanations, you learn how to write and test your programming code with the built-in Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, collections and dictionaries; code a "message box"; reprogram characteristics of a database; and use various techniques to query and manipulate your Access .mdb and .accdb databases. The book shows you how you can build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with SQL; enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports. You also learn how to use Access with XML and REST API. The book includes a comprehensive disc with source code, supplemental files, and color screen captures (also available from the publisher for download). FEATURES: Contains 28 chapters loaded with illustrated "Hands-On" exercises and projects that guide you through the VBA programming language. Each example tells you exactly where to enter code, how to test it and run it.Explains how to store data for further manipulation in variables, arrays, collections, and in a VBA Dictionary object while teaching you to write both simple and complex VBA programming routines and functions.Teaches you how to programmatically create and access database tables and fields, enforce data integrity and relationships between tables.Includes a comprehensive disc with source code, supplemental files, and color screen captures (also available from the publisher for download).</subfield></datafield><datafield tag="530" ind1=" " ind2=" "><subfield code="a">Issued also in print.</subfield></datafield><datafield tag="538" ind1=" " ind2=" "><subfield code="a">Mode of access: Internet via World Wide Web.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">In English.</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Description based on online resource; title from PDF title page (publisher's Web site, viewed 08. Aug 2023)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data.</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Programming.</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Software.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming / Microsoft.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">ASP.</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Access 2021.</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Business.</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Computer Science.</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Data Science.</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">MS 365.</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">VBA.</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">XML.</subfield></datafield><datafield tag="776" ind1="0" ind2=" "><subfield code="c">EPUB</subfield><subfield code="z">9781683928393</subfield></datafield><datafield tag="776" ind1="0" ind2=" "><subfield code="c">print</subfield><subfield code="z">9781683928416</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://www.degruyter.com/isbn/9781683928409</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="3">Cover</subfield><subfield code="u">https://www.degruyter.com/document/cover/isbn/9781683928409/original</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">EBA_CL_CHCOMSGSEN</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">EBA_DGALL</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">EBA_EBKALL</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">EBA_ECL_CHCOMSGSEN</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">EBA_EEBKALL</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">EBA_ESTMALL</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">EBA_STMALL</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV-deGruyter-alles</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">PDA12STME</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">PDA13ENGE</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">PDA18STMEE</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">PDA5EBK</subfield></datafield></record></collection> |