Page 42 - TP_Prime_V2.2_Class8
P. 42
Design View
The Table Design View allows users to define and modify the structure of a table,
including field types, properties, etc. The Design view window is divided into two parts:
• Field Grid Pane: It is used to define the field names and their data types.
• Field Properties Pane: It is used to set the properties for the fields defined in the
Prime (Ver. 2.2)-VIII table. Field Properties pane
Field grid pane
40
Design View
Naming Conventions for Writing a Field Name in Access
Following naming conventions you should remember while writing field names:
• Field name can be up to 64 characters long.
• Field name can include any combination of letters, numbers, spaces, and special characters
except a period (.), an exclamation mark (!), an accent grave (') and brackets ([ ]).
• Field name cannot begin with the leading spaces.
• Field name cannot include a double quotation mark (").
Creating a Table
Table can be created in three ways:
• Creating tables using Design View
• Creating tables using Datasheet View
• Creating tables using Templates
Let us create a table using Design view.
Creating a Table Using Design View
In this view, you can define fields which are to be included in the table. You can simultaneously
define properties of these fields.

