describe different parts of the design view window of a table.
Answers
Answered by
3
A table in Design View is divided in two sections: one in the upper area and another in the bottom: The top area is made of columns and rows. The lower portion of the window is made of two sections. The left section is made of two tabs labeled General and Lookup.......☺
Answered by
3
Working with a Table in Design View
Most Access objects are displayed in Design view, which allows you to work with the underlying structure of your tables, queries, forms, and reports. To create a new table in Design view, you define the fields that will comprise the table before you enter any data. In Design view for tables, each row corresponds to a field. You can edit, insert, and delete fields in your database tables in Design view. You insert a field by adding a row, while you delete a field by removing a row. You can also change field order by dragging a row selector to a new position.
Create or Modify a Table in Design View
yellow_1.jpg Click the Create tab, and then click the Table Design button, or select the table you want to modify in the Navigation pane, and then click the Design View button.
03fig18.jpg
Click to view larger image
yellow_2.jpg Click in a Field Name cell, and then type a modified field name.
yellow_3.jpg Click in a Data Type cell, click the Data Type list arrow, and then click a data type.
yellow_4.jpg Click in a Description cell, and then type a description. If the Property Update Options button appears, select an option, if necessary.
yellow_5.jpg To insert a field, click the row selector below where you want the field, and then click the Insert Rows button on the Ribbon.
yellow_6.jpg To delete a field, click the row selector for the field you want to delete, and then click the Delete Rows button on the Ribbon.
yellow_7.jpg Click the Save button on the Quick Access Toolbar, and then if necessary, enter a table name and click OK.
yellow_8.jpg When you’re done, click the Close button in the Table window.
Most Access objects are displayed in Design view, which allows you to work with the underlying structure of your tables, queries, forms, and reports. To create a new table in Design view, you define the fields that will comprise the table before you enter any data. In Design view for tables, each row corresponds to a field. You can edit, insert, and delete fields in your database tables in Design view. You insert a field by adding a row, while you delete a field by removing a row. You can also change field order by dragging a row selector to a new position.
Create or Modify a Table in Design View
yellow_1.jpg Click the Create tab, and then click the Table Design button, or select the table you want to modify in the Navigation pane, and then click the Design View button.
03fig18.jpg
Click to view larger image
yellow_2.jpg Click in a Field Name cell, and then type a modified field name.
yellow_3.jpg Click in a Data Type cell, click the Data Type list arrow, and then click a data type.
yellow_4.jpg Click in a Description cell, and then type a description. If the Property Update Options button appears, select an option, if necessary.
yellow_5.jpg To insert a field, click the row selector below where you want the field, and then click the Insert Rows button on the Ribbon.
yellow_6.jpg To delete a field, click the row selector for the field you want to delete, and then click the Delete Rows button on the Ribbon.
yellow_7.jpg Click the Save button on the Quick Access Toolbar, and then if necessary, enter a table name and click OK.
yellow_8.jpg When you’re done, click the Close button in the Table window.
Similar questions