SQL for Microsoft Access, 2nd Edition

Chapter 3Creating Tables and Inserting Records

Introduction

In this chapter, you will learn how to create a table and insert records into a table. You will learn about data types, field sizes, and constraints. You will also learn how to update and delete records in a table. Read the definitions for this chapter before you begin.

Keywords

ALTER TABLE

CREATE TABLE

DELETE

INSERT INTO

SELECT INTO

UPDATE

Definitions

ALTER TABLE — Keywords that are used to modify columns and constraints in an existing table.

Constraints — Used to restrict values that can be inserted into a field and to establish referential integrity.

CREATE TABLE — Keywords that are used to instruct the database to create a new table.

Data type — Specifies the type of data a ...