O'Reilly logo

Microsoft® Access VBA Programming for the Absolute Beginner by Michael Vine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 9MICROSOFT ACCESS SQL

In this chapter I show you how to use Microsoft Access SQL for querying and managing databases without the help of Access wizards. I specifically show you two subsets of the Access SQL language, called DML and DDL.

If you’re new to database languages such as SQL, consider this chapter a prerequisite for Chapter 10, “Database Programming with ADO.” Even if you’ve worked with SQL before, you may find this chapter a refresher for Microsoft Access SQL syntax and common functionality.

INTRODUCTION TO ACCESS SQL

Most databases, including Microsoft Access, incorporate one or more data languages for querying information and managing databases. The most common of these data languages is SQL (Structured Query Language), which ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required