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

Get Sams Teach Yourself Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.