Work With Tables

Create a table

Open a table

Design a table

What table type should I use for my table

Maintaining Your Tables

Adding Fields and Choosing Data Types

Add a field to a table

Create a field for text or memos

Create a field for numbers or currency

Create a field for dates and times

Create a field that automatically increments numbers

Create a field for sets and enumerates

Create a field to store BLOB (Binary Large Objects)

Customizing Fields

Change a field name in a table

Delete a field from a table

Change a field's data type

Change the field size for text and number fields

Define a default value for a field

Working with Primary Keys and Indexes

What kind of primary key should I use

Set or change the primary key

Remove the primary key

Create an index to find and sort records faster

Create a subpart index

Create a fulltext index

Delete an index

Prevent duplicate values from being entered in a combination of fields

Prevent duplicate values from being entered into a field

View or edit indexes