O'Reilly logo

SQL for Microsoft Access, 2nd Edition by Neal A. Berkowitz, Cecelia L. Allison

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 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 ...

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