You're beyond the basics, so dive right in and customize, automate, and extend Access-using Visual Basic for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access-and challenge yourself to new levels of mastery!
Enhance your application with VBA built-in functions and SQL code
Use the Access Object Model to work with data in forms and reports
Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
Create classes for handling form and control events
Connect your Access database to different sources of data
Effectively plan how to upsize an existing Access database to Microsoft SQL Server
Dynamically update Microsoft Excel spreadsheets from the database
Migrate your Access database directly to the cloud using SQL Azure
Sprache
Verlagsort
Zielgruppe
Maße
Höhe: 228 mm
Breite: 192 mm
Dicke: 39 mm
Gewicht
ISBN-13
978-0-7356-5987-2 (9780735659872)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
Andrew Couch is a Microsoft MVP for Access and an experienced instructor who has taught Introductory and Advanced Access courses as well as VBA programming courses. He is the author of Microsoft Access 2010 VBA Programming Inside Out.