Fundamental Microsoft Jet SQL for Access

Fundamental Microsoft Jet SQL for Access

Acey James Bunch
Microsoft Corporation

February 2000

ApplIEs To: Microsoft® Access 2000

Summary: This article discusses the basic mechanics of using Jet SQL to work with data in an Access 2000 database. It also delves into using SQL to create and alter a database''s structure. If you''re new to manipulating data with SQL in an Access database, this article is a great place to start. (21 printed pages)

Download AcFundSQL.exe.

Contents

Introduction
SQL Defined
Using Data Definition Language
Using Data Manipulation Language
Using SQL in Access
One Last Comment
Additional Resources

Introduction

This is the first in a serIEs of articles that explain what SQL is and how you can use it in your Microsoft® Access 2000 applications. There are three articles in all: a fundamental, an intermediate, and an