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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.