Access 2021 / Microsoft 365 Programming by Example

Paperback
October 2022
9781683928416
More details
  • Publisher
    Mercury Learning and Information
  • Published
    21st October
  • ISBN 9781683928416
  • Language English
  • Pages 1132 pp.
  • Size 7" x 9"
$64.95
E-Book

E-books are now distributed via RedShelf or VitalSource

You will choose the vendor in the cart as part of the check out process. These vendors offer a more seamless way to access the ebook, and add some great new features including text-to-voice. You own your ebook for life, it is simply hosted on the vendors website, working much like Kindle and Nook. Click here to see more detailed information on this process.

September 2022
9781683928393
More details
  • Publisher
    Mercury Learning and Information
  • Published
    22nd September
  • ISBN 9781683928393
  • Language English
  • Pages 1132 pp.
  • Size 7" x 9"
$54.95
Lib E-Book

Library E-Books

We are signed up with aggregators who resell networkable e-book editions of our titles to academic libraries. These editions, priced at par with simultaneous hardcover editions of our titles, are not available direct from Stylus.

These aggregators offer a variety of plans to libraries, such as simultaneous access by multiple library patrons, and access to portions of titles at a fraction of list price under what is commonly referred to as a "patron-driven demand" model.

September 2022
9781683928409
More details
  • Publisher
    Mercury Learning and Information
  • Published
    22nd September
  • ISBN 9781683928409
  • Language English
  • Pages 1132 pp.
  • Size 7" x 9"
$169.95

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).

Julitta Korol

Since 1993, Julitta Korol (Long Island, NY) has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. She has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).

MS 365; Access 2021; Data Science; Business; Computer Science; VBA; XML; ASP