The Fundamentals of Using SQL
Michael Alexander, Dick Kusleika · 2018
Structured Query Language (SQL) is the language that relational database management systems (such as Access) use to perform their various tasks. In order to tell Access to perform any kind of query, users have to convey your instructions in SQL. This chapter allows the users to discover the role that SQL plays in your dealings with Access and learn how to understand the SQL statements generated when building queries. The users will also explore some of the advanced actions they can take with SQL statements, allowing them to accomplish actions that go beyond the Access user interface. SQL-specific queries are essentially action queries that cannot be run through the Access query grid. There are several types of SQL-specific queries, each performing a specific action. The chapter introduces few of these queries, focusing on those that can be used in Access to shape and configure data tables.