Chapter 2Structured Query Language and Microsoft Access

Introduction

In this chapter, you will learn about Structured Query Language (SQL) and the Microsoft Access database management system. You will also learn how to open Microsoft Access and how to locate SQL view within Microsoft Access. Be sure to read over the definitions for this chapter before you begin.

Definitions

Clause — A segment of an SQL statement that assists in the selection and manipulation of data.

Keywords — Reserved words used within SQL statements.

Microsoft Access — A desktop database management system used to create, manage, and secure relational databases.

Query — A question or command posed to the database.

Statements — Keywords combined with data to form a database query. ...

Get SQL for Microsoft Access, 2nd Edition 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.