Data access and data management are at the core of any database application. Although you can do a decent job building applications with bound forms and reports, using Visual Basic for Applications (VBA) code to access and manipulate data directly provides far greater flexibility than a bound application can. Anything that can be done with bound forms and controls can be done with a bit of VBA code using ActiveX data objects (ADO) or data access objects (DAO) to retrieve and work with data.
The VBA language offers a full array of powerful commands for manipulating records in a table, providing data for controls on a form, or just about anything else. This chapter provides some in‐depth examples of working with procedures that use DAO or SQL and ADO to manipulate database data.