Welcome To Access Databases
Create Database
Table
Query
Form Button
Report
 
 
 
 

 

Begin New Table


If necessary, click Tables button in the Objects List.

Above Objects List click New.
In New Table dialog box, double click Design View.
Click OK.

 

Add Fields to New Table Design (should look like illustration below)

 

The blinking insertion point is in the first row of Field Name column.

Type Name and Tab .  The insertion point moved to Data Type column.  Default data

type Text appears.   Look at drop-down list for Data Type column.  These are all available types in Access.

Tab to accept Text and move to Description column

Tab to move to the next Name Field.

Type Native to: and Tab

On the Data Type column Tab to accept Text and Tab again to move the new field.

Type Habitat Type and Tab to the next field.

Type Temperature and for Data Type used the drop-down list to choose Number.

Type Food as the last field name and Tab to choose Text as the Data Type.

Save, Name and Close Table Design

Choose File/Save

The Save As dialog box appears. 

Type Aquarium and click OK

You must also decide about primary key.  Click Yes.  The new table design is saved.

File/Close