Question

Write the steps to create table with minimum 10 fields on an entity "Student" in design View.
​

Answer 1

Answer:

We will design the following table:

Field Name Data Type Constraint

ID Integer Primary Key

Name Varchar

Address Varchar

Phone Varchar

DOB Date

1. Click on Create Table in Design View option available under Tasks and a Table. The design window appears as shown below.

2. Specify the field name and data type of the field to be created as shown below.

3. In the grey box at the left of the line, right-click and select Primary Key bringing up a key icon in the box.

4. Save the table (File > Save).