Home » Microsoft Access » 06 - Fields
6
Adding a Field to a Table in Design View
Before entering data, Michael checks the table design. This is an important activity, as it enables you to add/delete a field before entering the data.
- In the Database window, under the Tables tab, select a table.
- Click Design.
- Click a blank row under the Field Name column.
- Enter a field name.
- Press the tab key to move to the next column.
- Under the Data Type column, select the Data Type from the drop-down list that opens.
- Press the tab key to move to the next column.
- Enter a description for the field under the Description column.
- To save the changes to the table design, click Save on the toolbar.
Note: If a table is already open for data entry and editing, you can click the Design View button on the Access toolbar to switch to design view. You can move a field up or down by clicking once in the field’s far left column i.e. row selector button and then click again and drag the field.
