Home / MS-Access / Getting Started

Creating Tables and Inserting Records

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 tutorial before you begin.

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 column can store.

DELETE statement - Used to remove records from a table.

Field - Equivalent to a column.

Field size - Specifies the maximum number of characters that a field can hold.

INSERT statement - Used to add records to a table.

NULL - Used to indicate no value.

SELECT statement - Used to retrieve records from the database.

UPDATE statement - Used to update records in a table.

In this tutorial:

  1. Data Definition Language Component
  2. CREATE TABLE Syntax
  3. SQL Data Types
  4. Constraints
  5. NULL/NOT NULL Constraint
  6. PRIMARY KEY Constraint
  7. FOREIGN KEY Constraint
  8. Adding Constraints to Existing Tables
  9. Constraint Syntax
  10. Inserting Records
  11. Inserting Data without Specifying Column Names