How can you insert multiple fields in a table.

Q17. How can you insert multiple fields in a table?

Ans. In this question, we are using the Stud_Database database that has two tables named Faculty and Student. Let’s assume that you want to add additional fields in the Student table. For this, you first need to open the Student table in the Table Design view. After this, perform the following steps to add fields in the Student table:

  1. Right-click the Student table to add fields in it. A context menu appears .
  2. Select the Edit option from the context menu,

The Table Design window appears.

  1. Type the desired field name in the Field Name column to add the field in the Student table. In our case, we have typed Stud_Marks in Science.
  2. Press the ENTER key to move to the Field Type column to define the field type.
  3. Select the Number [NUMERIC] field type for the Stud_Marks in the Maths field from the Field Type column.
  4. Click the Save button to save data in the table.


The required fields are now added in the Student table. To view the modifications, open the table in Table Data View by double-clicking the name of the table in the BASE window. The table appears in Table Data View with the required changes.

Entry Required field property.

Q13. What do you understand by the Entry Required field property? Explain with a suitable example.

Ans. The Entry required specifies whether the entry of data in the selected field is mandatory or not. For example, in case you set the value as Yes in the field property of a selected field, it means that you must enter data in the field. On the other hand, if the value is set as No, then you need not enter any data in the field. Read More …