Page 43 - TP_Prime_V2.2_Class8
P. 43
To create table in Design view, follow these steps:
Step 1: Click on Table Design command from Tables group
under Create tab. This will create a new table as Table1
in the database.
This will open a blank table in the Design view. The table
is divided into three columns: Creating a Table
• Field Name: This column is used to enter the name of the field to be
displayed as column heading in the table. WORKING WITH ACCESS 2016
• Data Type: This column is used to define the type of data that can be entered
in that field. The commonly used data types in Access are Short Text, Number,
Date/Time, Currency, AutoNumber, Yes/No, etc.
• Description: This column is used to give additional comments or information to
the user while entering data. The entry in this field is optional.
Step 2: Enter the names of the fields and assign suitable data types.
41
Step 3: Assign the primary key to the Roll No field.
Design View Entering Field Names
To move between columns and insert new fields at the end, press the Tab key.
Setting Field Properties
The detailed properties of each field can be defined in the
Field Properties pane according to the rules for writing a field
name discussed earlier.
Perform the following steps to set field properties:
Step 1: Click on the field name for which you want to set the
properties.
Step 2: Specify the required properties in the Field
Properties pane. Setting Field Properties
Step 3: Similarly, you can set the properties for the other fields.

