Chapter 16. Using Advanced SQL Techniques
Access programming is Visual Basic for Applications programming. That is, when you program with Access, you are writing Visual Basic (VBA) code. Structured Query Language (SQL, pronounced sequel) is not the same thing as VBA. VBA and SQL are two separate languages. VBA is an all-purpose programming language, and SQL is a language designed specifically for programming databases.
No book on Access programming would be complete without a tour of SQL programming because SQL is especially useful for programming databases. In the last hour, you had an opportunity to write code using the
ADODB object. What might not be readily apparent is that the
ADODB object converts a lot of the VBA code that you write into ...