Write the steps to create table with minimum 10 fields on an entity "Student" in design View.
Answers
Answered by
17
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).
Similar questions
Social Sciences,
2 days ago
Music,
2 days ago
Computer Science,
5 days ago
English,
8 months ago
Geography,
8 months ago