Tables

Â

CREATE TABLE

Â

(A) create table in Design view will allow you to create the fields of the table. this is the most common way of creating a table and is explained in detail below.

Â

(B) Create table using wizard will step you through the creation of a table.

Â

(C) Create table by entering data will give you a blank datasheet with unlabelled columns that looks much like an Excel worksheet. Enter data into the cells and click the Save button. You will be prompted to add a primary field. After the table is saved, the empty cells of the datasheet are trimmed. The fields are given generic names such as "Field1", "Field2", etc. fields, select Format|Rename olumn from the menu bar or highlight the column, right-click on it with the mouse, and select Rename Column from the shortcut menu

Â

Â

Â

Â